RE: [sqr-users] (no subject)

["Graeme Steyn " <g.steyn@cqu.edu.au>]

Hi Steve.  Thank you for the pointer.  The PeopleTools8.44 PeopleBook:
SQR Language Reference for PeopleSoft and Brio Report 6.0 Help files do
not contain any reference to the set-delay-print and print delay
options.  Your previous response to RE: [sqr-users] set-delay-print
command and Page X of Y a useful reference for the command usage (sorry
only found this article after my original posting.

Regards,

Graeme

-----Original Message-----
From: Steve Cavill [mailto:steve.cavill@infoclarity.com.au] 
Sent: Wednesday, 19 January 2005 9:29 PM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] (no subject)


Hi Graeme,
Look at the set-delay-print command and the delay option of the print
command. This lets you print a "place-holder" for the "of n" part of
your report. When you have printed the last page of the statement you
use the set-delay-print command to go back and fill in the page count on
the pages you have already printed. Cheers, Steve.  

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On
Behalf Of Graeme Steyn
Sent: Wednesday, 19 January 2005 4:11 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] (no subject)

Hi,
 
I am currently experiencing a problem attempting to produce page numbers
in the format "page x of n" for a report header, where the report
contains multiple statements.  The SQR process is generating a batch of
statements, all of which are processed and output to the same .lis file
to make printing the batch easier (i.e new-page forced between
statements and #page-count reset).  The problem is that I have no easy
way of determining how many pages are going to be printed per statement
within the batch.  Using Last-Page and manipulating #page-count as shown
in the following code, does not provide a solution:
 
begin-heading 1
    page-number (1,1) 'Page '
    last-page () ' of ' '.'
end-heading
 
begin-program
print 'Header should read: Page 1 of 2.' (10, 10) print 'Statement 1'
(11,10) new-page print 'Header should read: Page 2 of 2' (10,10) print
'Statement 1' (11,10) new-page
move 1 to #page-count        !reset page counter.
print 'Header should read: Page 1 of 4' (10,10) print 'Statement 2'
(11,10) new-page print 'Header should read: Page 2 of 4' (10,10) print
'Statement 2'
(11,10) new-page print 'Header should read: Page 3 of 4' (10,10) print
'Statement 2' (11,10) new-page print 'Header should read: Page 4 of 4'
(10,10) print 'Statement 2' (11,10) end-program
 
This generates the following result:
 
Statement 1:    2 pages            Header reads Page 2 of 4, when it
should be Page 2 of 2.    
Statement 2:    4 pages            Header correct for page x of 4.
 
The second statement in the .lis file thus has the correct number of
pages, however, the first statement in the .lis file has its total
number of pages shown as being 4 (the last value of #page-count when the
report was completed).  If you have n statements in the batch, then all
statement headers will have the total number of pages determined by the
last statement generated in the process.  Does anyone have a simple
solution for this problem?  I wish to avoid having to do complex
calculations to pre-determine the number of pages that will be used by
any statement.  I would also like to avoid creating a single file per
statements using the new-report command.
 
Details of the platform that I am running this on appear as follows:
 
Platform:          WINDOWS-XP Professional Version 2002 SP1
SQR Version:   SQR for PeopleSoft/8.44.12     /PC/Windows NT 4.0/Oracle
8.0.6/Jul 13 2004
Database:        Oracle 9.2.0.1
Application:      PeopleSoft 8.44.12

Thank you.
 
Regards,
 

Graeme Steyn
Corporate Information Systems
Information Technology Division
Central Queensland University
Tel: +61 7 4930 9256
E-mail: g.steyn@cqu.edu.au 

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users





_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users