Re: Column Headings Appearing Above level 1 break field print

["Risman, Mark" <mrisman@PAINEWEBBER.COM>]

Jenny,

If I am following your code correctly, what you are seeing is exactly what 
would happen.  You use "on-break...before=dept-change" - this would print your 
headings one line below the current line (since you specify (+1,1)).  This will 
print before the data prints, since you said on-break=before.  You then start 
printing the data, also initially at (+1,1), which would then print the data 
one line below the current line, which is the line with the headings on it.  If 
you want to print your headings after all related rows have been selected, 
maybe you should investigate on-break=after instead of on-break=before.

Hope this helps,
- Mark

                -----Original Message-----
                From:   Jenny Mckeon [mailto:MCKEON@SHANDS.UFL.EDU]
                Sent:   Wednesday, July 12, 2000 5:19 PM
                To:     SQR-USERS@list.iex.net
                Subject:        Column  Headings Appearing Above level 1 break 
field print

                 << File: SQRPROG.TXT >> In my recently written report,  I want 
the column headings to appear under the department name. I am page breaking on 
Department, and it's my level 1 control break, so I don't see how in the world 
the column names are managing to come out on top, but they are.
                So the output looks like this:
                JOBCODE   POSITION TITLE  NAME          EMPLID   STATUS   FTE  
ect.
                Department:  123456   AnyDeptName

                99999999     Unit Clerk             Smith,Joe       12345       
    A          1.0

                What would cause this mixed up sequencing of report lines ?
                Code is attached.  Any suggestions would be greatly appreciated.
                If this is an easy one I appologize (it's my first SQR program 
written from scratch)

                Jenny Mckeon
                Shands Healthcare, Info. Svcs.
                Application Systems Analyst, Senior
                (352) 395-0680, ext. 8-5232
                internet:mckeon@shands.ufl.edu