Multiple break processing

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

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...