Re: Print last page

[Sherry Jin <sjin@WINSTAR.COM>]

Kris,

I believe this is a problem generated within peoplesoft. SQRIBE doesn't
recommend attaching printer name after -f (The recommendation is to attach
file directory/file after -f). In Peoplesoft,  When printer is specified as
the output, peoplesoft generates -fLPT2 into the parameter list. Last-Page
tries to generate a buffer file to be able to compute last page. Mostly
likely, it considers LPT2 as the directory file and attempts to open it as
a file.

I left a voice mail for peoplesoft regarding this case.

Sherry
At 09:58 AM 7/1/99 -0700, Kris Narravula wrote:
>Robbi,
>
>I am not trying to create multiple reports and I am also not trying to do
>any manipulation of Page Numbers, etc. My question is very simple, I am
>getting the error while I am trying to run the report to the printer via
>PeopleSoft with SQR's LAST-PAGE command in the report. It works fine when I
>run it to the file from the same PeopleSoft Menu.
>
>The error I am getting is
>(SQR 6002) Cannot open the printer file: \\cairo\infosrvs.spf
>(2): No such file or directory
>
>It is not addressed yet.
>
>Thanks in advance.
>Kris
>
>----- Original Message -----
>From: Wendel, Robbi <rwendel@NESPOWER.COM>
>Sent: Thursday, July 01, 1999 4:59 AM
>Subject: Re: Print last page
>
>
>I apologize if this is something that you have already addressed or answered
>previously, but have you considered trying to use NEW-REPORT instead? It
>resets the internal page counter and permits multiple reports from same SQR.
>I didn't backtrack to look at all information regarding this posting to
>date, so you may have already addressed this or ruled this out.
>
>Have a great day,
>Robbi
>
>-----Original Message-----
>From: Kris Narravula [mailto:kris_narravula@HOTMAIL.COM]
>Sent: Wednesday, June 30, 1999 3:57 PM
>To: Multiple recipients of list SQR-USERS
>Subject: Re: Print last page
>
>
>Hi  John, Sherry and Every Body,
>
>I got the same problem and wanted to post it. At the same time I saw the
>request on the list and looking for the outcome.
>
>I am getting the following error when I use LAST-PAGE command to print the
>last page number of the report on every page header as 'page 1 of  99' and
>run it to a printer from PeopleSoft. It works fine when I run the report to
>a file from the same PeopleSoft.
>
>(SQR 6002) Cannot open the printer file: \\cairo\infosrvs.spf
>(2): No such file or directory
>
>When I remove the LAST-PAGE command and run the report it works fine with
>out any error to  the file as well as to the printer from PeopleSoft.
>
>We are on
>Oracle 7.3.4.3.1 and is on HPUX 10.20 &
>WinNT 4.0 File Server,
>SQR 4.3.2
>PeopleSoft HRMS 7.50.00.000
>PeopleTools 7.54.10
>
>I am sorry, I may be giving a bit of inconvenience to the only SQR users. I
>am posing this here as similar issue is in discussion.
>
>
>Any body has any clues.
>
>
>Thanks in advance
>
>Kris
>
>----- Original Message -----
>From: Sherry Jin <sjin@WINSTAR.COM>
>Sent: Wednesday, June 30, 1999 12:55 PM
>Subject: Re: Print last page
>
>
>John,
>
>Thanks for the response.
>
>The problem is resolved if I add -printer:WP into the SQR flag in config
>manager and specify file as the output destination.
>
>What happens is that whenever printer (Say LPT2) is selected as the output,
>peoplesoft generates -flpt2 into the process parameter. I believe
>"last-page" tries to generate a temp buffer file and considers lpt2 as the
>output directory/file.
>
>Sherry
>
>At 03:02 PM 6/30/99 -0400, John Milardovic wrote:
>>Do you mean 'print-direct'? or -printer:WP? or are you piping to the
>printer
>>in UNIX?
>>
>>If print-direct the problem might be that print-direct sends output
>directly
>>to the printer (i.e.. bypassing the SQR buffer) and so SQR can't calculate
>>the number of pages in the report.
>>
>>John Milardovic
>>
>>> -----Original Message-----
>>> From: Sherry Jin [SMTP:sjin@WINSTAR.COM]
>>> Sent: Wednesday, June 30, 1999 1:54 PM
>>> To:   Multiple recipients of list SQR-USERS
>>> Subject:      Print last page
>>>
>>> I am trying to use last-page to print out the total numbers of pages on
>>> each page. It works when I use file as the output destination, but
>>> receives
>>> error message 'Error reading the printer file (22) Invalid argument' when
>>> printer is used as the output destination.
>>>
>>> This is what I added to the code:
>>>
>>> page-number (1,1) 'Page '
>>> last-page   ()    ' Of '
>>>
>>> Adding command last-page causes the error when output is printer.
>>> Has anyone been able to invoke last-page and send the output directly to
>>> printer?
>>>
>>> Thanks for any help,
>>> Sherry
>>
>>
>
>