Re: Column Headings Appearing Above level 1 break field print

[Mark Castleberry <Mark.Castleberry@SHAWINC.COM>]

To print a value in the heading you will need to add the print commands for
that value to the BEGIN-HEADING section of the report.  BEGIN-HEADING 8, as
you have specified, will reserve the first 8 rows of each page for the
report heading.  Other print commands will begin on the next available
line.  That is why the print commands in your Dept-Change procedure print
below the heading columns.

Keep in mind that the heading is the last part of the page to be printed.
This means that if you use a variable in BEGIN-HEADING the contents of the
variable when SQR reaches the end of the page will be printed (rather than
the beginning).

Good luck!
Mark




                    Jenny Mckeon
                    <MCKEON@SHANDS        To:     SQR-USERS@list.iex.net
                    .UFL.EDU>             cc:
                    Sent by:              Subject:     Column Headings 
Appearing Above level 1 break field print
                    "Discussion of
                    SQR, Brio
                    Technology's
                    database
                    reporting
                    language"
                    <SQR-USERS@lis
                    t.iex.net>


                    07/12/00 05:19
                    PM
                    Please respond
                    to sqr-users






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

(See attached file: SQRPROG.TXT)

Text - character set unknown