controlling page breaks in a spooled SQL report

85 pts.
Tags:
Microsoft SQL Reporting Services
SQL Reports
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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
    69,045 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following