Re: Print last page

["Wendel, Robbi" <rwendel@NESPOWER.COM>]

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
>
>