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.
Windows & Linx
January 29, 2010 8:50 PM
February 1, 2010 2:29 PM