SSRS report print watermark at the back of page

I have an SSRS report being generated as an invoice.  I will like to add the terms and conditions to the back of each page if the invoice goes on to more than one page.  How can this be programmed so the same terms and conditions are always printed to the back of each page?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Data DudeCommented:
>How can this be programmed so the same terms and conditions are always printed to the back of each page?

I pulled this off with previous clients by writing a Stored Procedure named something like rsp_legal_disclaimer that goes something like this:
CREATE PROC rsp_legal_disclaimer AS 

-- Legal disclaimer for use on all reports. 
SELECT 'For company use only.  Don''t screw with us' as label

Open in new window

Then add a dataset that connects to SP rsp_legal_disclaimer, then create a textbox in your report footer whose value is dataset.label, and do this for all reports.  This way, you change the text in one place (the SP), and it'll reflect on all your reports.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim HornMicrosoft SQL Server Data DudeCommented:
This has worked for me in a previous project, assuming it works here.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.