Re: Multiple break processing

[Rebecca Kuehn <Rebecca.Kuehn@APPOUTFIT.COM>]

Thanks Jim. I still have a problem though...

The totals are printing okay. The problem is that when level 3 breaks, the
level 1 and level 2 fields are being printed before the level 3 total line.
Then, on the line following the total, the detail line continues, starting
with the level 3 field. It's as if the program doesn't realize there is a
level 3 break until after it has already started the detail line and printed
the level 1 and 2 fields.

Any suggestions for this?

***********************************************

Rebecca,

With the level option, when one of the field breaks, all higher number
breaks will clear.

So in other words:
when level 3 breaks (paygroup)  -> (3)print-paygroup-totals

when level 2 breaks (dept)      ->(3)print-paygroup-totals      (2 then 3)
                                ->(2)print-dept-totals

when level 1 breaks (div)               ->(3)print-paygroups-totals     (3,2
then 1)
                                ->(2)print-dept-totals
                                ->(1)print-division-totals

Hope that helps.



Jimbo


>----------
>From:  Rebecca Kuehn[SMTP:rebecca.kuehn@APPOUTFIT.COM]
>Sent:  Tuesday, December 29, 1998 4:57 PM
>To:    Multiple recipients of list SQR-USERS
>Subject:       Multiple break processing
>
><<File: ATT00149.html>>
>When doing multiple break processing, why are the first and second level
>fields printing on the detail line before the "after" processing, a
sub-total
>line, of the the third level field? The code is very straight-forward, from
>an example right out of the SQR Users Guide:
>
>
>begin-select
>j.paygroup
>j.deptid
>j.location
>j.emplid...
>
>print &j.location (+1,1) on-break print=change/top-page skiplines=2 level=1
>after=print-division-totals
>print &j.deptid (,10) on-break print=change/top-page skiplines=2 level=2
>after=print-dept-totals
>print &j.paygroup (,20) on-break print=change/top-page skiplines=2 level=3
>after=print-paygroup-totals...
>print $j.emplid (,30)
>
>from ps_job j
>
>order by j.location, j.deptid, j.paygroup, j.emplid
>
>The output looks like this:
>Location     Dept     Paygroup     Emplid
>-------------    --------    ---------------    ------------
>location1    dept1    paygroup1    emplid1
>                                                emplid2
>
>location1    dept1
>
>Total by paygroup1: 2
>
>                            paygroup2    emplid3
>
>
>Any help would be greatly appreciated...