[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Stopping pages with no 'body' being printed?



The easiest solution is to put the new-page in the part of your SQR that
does the processing.  Put it directly before the first print command.  I
assume that when you say "I'm doing prints all over the place" you are
talking about actual PRINT commands, not printing directly from a
begin-select statements.  If the first line in the body never gets printed
the new-page before the first PRINT command should not get printed also.

scotty



At 05:52 AM 10/25/01, you wrote:
>I have a problem with a report I'm currently writing for PS HRMS:
>
>The report is one page per Emplid, so when the employee changes I'm using a
>new-page command.  On each page I have a heading with some of the current
>employee's information.
>
>My problem is this:  When some data is selected for the employee, the
>new-page is executed.  It's only later on in processing that the decision is
>actually made to print data or not, depending on values etc.  If nothing is
>printed, and the next employee is selected, another new-page goes through
>without any print statements for the previous Emplid.  I think this is the
>cause of having some pages with a heading but no body.  I'm doing prints all
>over the place, and I don't particularly want to keep a variable that is
>updated on the first print per person, then check that before issuing the
>new-page.  Is there an easy way to stop the 'blank body' pages being
>printed?
>
>Thanks
>Greg
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


----------

Scott A Barnes
Programmer/Analyst
Wesleyan University
North College
860-685-2807


----------