Re: Multiple break processing

[Jimmy Webb <JimmyW@SNELLINGCORP.COM>]

Rebecca,

I noticed that you are using the on-break command with the 'Print'
statement, as opposed to using it on a field from the select list, i.e.

>j.location   () on-break print = never...
j.location
j.deptid     ()   on-break print = never...
>j.deptid
j.paygroup () on-break  print = never...
j.paygroup

This will control your SQL loop easier. The second instance of the
variable creates the variable, print = never kills your variable. Don't
use the skip lines, do everything from the 'after' procedure, sometimes
you just never know when or where that skip is going to come, especially
>if you do it with the on-break on the print.



 Jimbo


>----------
>From:  Rebecca Kuehn[SMTP:Rebecca.Kuehn@APPOUTFIT.COM]
>Sent:  Wednesday, December 30, 1998 9:18 AM
>To:    Multiple recipients of list SQR-USERS
>Subject:       Re: Multiple break processing
>
>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...
>