controlling page breaks in a spooled SQL report
I have written a SQL report that validates many of our tables. Only when there is an error on a table will a report of that table print. The script contains 32 different select statements each one associated with a different table. I need to have a page break between the reports because the tables are maintained by different people. I am trying to do 2 things. 1 - eliminate an initial page break which is producing a blank page. The 2nd thing I wanted to do was force the first page to say 'THIS IS THE START OF THE ERROR REPORTS'. I've tried many ways but it never prints this statement on a page by itself. Actually, it never prints at all.
All help would be greatly appreciated.
Sherry
Software/Hardware used:
Windows & Linx
All help would be greatly appreciated.
Sherry
Software/Hardware used:
Windows & Linx
ASKED:
January 29, 2010 8:50 PM
UPDATED:
February 1, 2010 2:29 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Hi Sherry.
I think you would have better chances to get a useful response if you:
- Tag your question appropriately
- Mention the software tool you are using to generate the report (we know the data is coming from a database, but what sofware is processing it to generate the report ?)
- Mention the database platform involved
- Let the community know what are the many ways you have tried, and the results you have got