RE: [sqr-users] Putting a line a the top of every page in a report

["Wright, Rodney" <rwright@therousecompany.com>]

Have you tried using the

     on-break print=change/top-page

option of the Print statement? This would go where you print the body of
the report, not in the heading area. It will always print as the first
line of a new group and at the top of each page. It will not print on
subsequent lines within the group.

Rod Wright
Senior Applications Specialist
The Rouse Company
410-992-6307


-----Original Message-----
From: Kirk Katzbet [mailto:kk_413@hotmail.com] 
Sent: Monday, January 20, 2003 10:57 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Putting a line a the top of every page in a report




Thanks in advance!!


I have a line with some variables: Base and Alias Client #, and Client
and
Alias name at the
bottom of my headings of a report (so it is at the top of the body of my
report).  This line is
also printed throughout the body of the report as the variables
change(as a
new record gets read).
This heading line is the first thing that gets printed as I read a new
record.


Also maybe there is a better way to do this without using the heading to
put
this line at
the top of every page?


Here are my problems using the line as part of the heading?


Problem 1:
=============
I am having a problem with that I do not want to print this line in the
body
of the report for the first GOOD record that I read because it will be
there
already because it is in the heading.


                                  PeopleSoft AP
Report ID:  SSS2034               FYAP CLIENTS COMBINED
                          Page No.  1
                                                       Run Date 12/12/02
                                                       Run Time 16:39:56

Base Client #  Client Name             Alias Client #  Alias Name
__________________________             __________________________

0000000389     EDWARDS, JOSEPH        0000000100      KELLY, MARY
--------------------------------  -------------------------------------


0000000389     EDWARDS, JOSEPH        0000000100      KELLY, MARY
--------------------------------   -----------------------------------

The Alias Client Id has been updated to the Base Clients ID for Voucher
ID
00000083, Contract ID 0000000190

The Alias Client Id has been updated to the Base Clients ID for Voucher
ID
00000002, Contract ID 0000000011

The Alias Client Id has been updated to the Base Clients ID for Voucher
ID
00000003, Contract ID 0000000011

The Alias Client Id has been updated to the Base Clients ID for Voucher
ID
00000005, Contract ID 0000000012

The Alias Client Id has been updated to the Base Clients ID for Voucher
ID
00000006, Contract ID 0000000012


Problem 2:
=============
Also when a new record is read and the variables in that line are
populated
in the middle of
the page(body of the report), then the page is printed when it has the
maximum number of lines
the heading is printed last and it has the new record information when I
need it to have the
previous record information because there is some lines at the top of
the
body of the
report that belong to the previous record.


                                  PeopleSoft AP
Report ID:  SSS2034               FYAP CLIENTS COMBINED
                      Page No.  5
                                                   Run Date 12/12/02
                                                   Run Time 16:39:56

Base Client #  Client Name      Alias Client #  Alias Name
__________________________      __________________________



0000000389     EDWARDS, JOSEPH        0000000101      KELLY, SANDRA
--------------------------------   ------------------------------------

he Alias Client Id has been updated to the Base Clients ID for the
Ledger
ACTUALS, Office 017, Object Code 074001, Organization RG, Fiscal Year
1996,
Accounting Period 8

The Alias Client Id has been updated to the Base Clients ID for the
Ledger
ACTUALS, Office 017, Object Code 074001, Organization RG, Fiscal Year
1996,
Accounting Period 9

The Alias Client Id has been updated to the Base Clients ID for the
Ledger
ACTUALS, Office 017, Object Code 074002, Organization ER, Fiscal Year
1996,
Accounting Period 8

The Alias Client Id has been updated to the Base Clients ID for the
Ledger
ACTUALS, Office 017, Object Code 021705, Organization RG, Fiscal Year
1997,
Accounting Period 1

The Alias Client Id has been updated to the Base Clients ID for Case
Number
123456, Involvement Number 1, Office 017 and Unit Case Load B016


0000000389     EDWARDS, JOSEPH     0000000101      KELLY, SANDRA
--------------------------------   ---------------------------------


The Alias Client Id has been updated to the Base Clients ID for Purchase
Order ID 0000000003

The Alias Client Id has been updated to the Base Clients ID for Purchase
Order ID 0000000004

The Alias Client Id has been updated to the Base Clients ID for Purchase
Order ID 0000000007

The Alias Client Id has been updated to the Base Clients ID for Purchase
Order ID C000000011

The Alias Client Id has been updated to the Base Clients ID for Purchase
Order ID 0000000012



_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail

_______________________________________________
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