[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
On-break, Multiple page breaks
- Subject: On-break, Multiple page breaks
- From: "Chavira, Denise" <Dchavira@STATE.MT.US>
- Date: Thu, 17 Dec 1998 11:27:14 -0700
I am having some difficulty with my on-break code. I am required to print a
report that prints a new page at each new business unit (level 1), each new
fund code (level 2), and skiplines and sum amounts at every change in
account (level 3). The problem is that if both BU and fund code change at
the same time, I get an extra blank page (header only) between the change in
BU and fund. My code is as follows:
begin-SELECT
A.BUSINESS_UNIT_IU () on-break print=never level=1 after=New-Page
B.FUND_CODE () on-break print=never level=2 after=New-Page
B.ACCOUNT (+1,#1) on-break print=change/top-page level=3 skiplines=1
after=Print-Totals
The procedure New-Page is just that, new-page. I also am ordering by BU and
then Fund Code. I have tried switching levels and making both BU and Fund
level 1 but that doesn't work either. It is necessary that I use new-page
for both BU and fund code because any combination of BU and fund code is
possible. Is there a way to use before instead of after or switch the levels
another way to make it work? Any input would be greatly appreciated. Thank
you.
DC