Re: [sqr-users] on-break print=change/top-page

[Al H <star111lists@mindspring.com>]

Most problems in this area are related to not realizing when the page
is actually printed.

Unlike line oriented languages, SQR buffers your page in memory until
it is ready for printing.  The page is not physically printed until
the new-page command is executed, or the end of detail lines is
encountered. This means that if you are breaking on a field, by the
time the page is printed, that field already contains the new value.
Thus, if you print it during the page break time, the new value will
print.

Example:

If you are page breaking on DEPT, and you have &DEPT set to print in
your begin-heading, this will create a problem because when you
initiate the page break, the value of DEPT has changed. So the last
page of entries for the old department would actually print with the
NEW department value in the heading.

Your heading section should not contain any database variables.
Instead move any break sensitive values to sqr variables during detail
time and print those values in the heading.

On Fri, 16 May 2003 12:47:19 -0400, you wrote:

>Using SQR/6.1.3/PC/Windows NT 4.0/ODBC Level 2/Oct 20 2000 on Windows 2000.
>Connection to MSSQL Server 7.0.
>
>I can not get the statement - on-break print=change/top-page - to work when
>a new page is produced.  The variables will print when the values change but
>not when a new page happens.  Any ideas?  Very frustrating because from
>reading the past problems/solutions using on-break print=change/top-page
>should be a piece of cake.
>
>J. Copeland
>Application Developer/Analyst


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users