Kris
Sherry is right. when you use LAST-PAGE SQR will put all the output in buffer cause it need to compute total page count before printing. SQR tries to save this buffer file (same name as output destinationin directory where SQRs are resided and if that directory (\\cairo\) does not have permission for users to write the SQR will raise error saying cannot save the file or whatever. if u make that directory allowed to write no error will come but u end up users tampering that files .....
all the best
Pankaj Bedekar
-----Original Message-----
From: Sherry Jin [mailto:sjin@WINSTAR.COM]
Sent: Friday, July 02, 1999 5:34 AM
To: Multiple recipients of list SQR-USERS
Subject: Re: Print last page
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
>>
>>
>
>