Re: On-break, Multiple page breaks

[Richard McCutcheon <Richard_McCutcheon@HCM.HONDA.COM>]

Well Denise, you could try something like the following:

let $page-flag = 'Y'

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

   let $page-flag = 'Y'

end-SELECT
     |
     |
     |

begin procedure New-Page
if $page-flag = 'Y'
   new-page
   let $page-flag = 'N'
end-if
end procedure


I haven't tried this myself yet, but I'm pretty sure it would work.




"Chavira, Denise" <Dchavira@STATE.MT.US> on 12/17/98 01:27:14 PM

Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Richard McCutcheon/HCM/AM/HONDA)
Subject:  On-break, Multiple page breaks




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