SPOOLING AND SETTING NEW PAGE IS CREATING A BLANK PAGE

[sherryborden]

I have written an SQL script that validates various tables. This script produces a different report for each table. Only if there's an error on a table do I want that particular report to print. Different people are responsible for the diffent tables so I need to do a page break between the reports. I have this working. MY PROBLEM IS A BLANK PAGE IS PRINTED FIRST & then any of the other reports that have errors. How do I prevent the blank page from printing OR how do I force just a header onto the blank page? We use E-PRINT and it's skipping the first report.
All help is greatly appreciated.
Sherry

 

[NoCoolHandle]

Seems like you need to ask e-print for help. this forum is more about writing querys and programming the database.