ssrs report footer 'pinned' to bottom of last page

I have a report that has a legal disclaimer that must fall at the bottom of the last page of the report.  I have read many people have tried to work around this problem.  I can put it in a text box at the bottom of the report body, but it does not stay pinned to the bottom.  I put in a page footer then set it to hidden=true for all pages except for the last, but that leaves blank space at the bottom of all other pages.  Does anyone have a better way to handle this problem?
Thanks
jat0818Asked:
Who is Participating?
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.

sammySeltzerCommented:
hi,

I *think* you can solve the positioning problem by clicking on the text you are using as your footer, click on Properties on the right side of the report, scroll down till you see Layout, expand it, expand location and adjust left/top postions.

You may do the same for your main report you are creating a footer for.

Good luck.
jat0818Author Commented:
You can set the position that way, but it does not stick.  It will float up the page and end up just below the data table.
BostonMACommented:
How many lines is your disclaimer?  If its holding spaces, can you put the message in the dataset and then retreive it in the text box instead of writing it out?   That way it should only hold the amount of space which equals the size of the text box.
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

planoczCommented:
Use the report footer and in the Visibity-hide expression place this in it.....
= IIF(Globals!PageNumber <> Globals!TotalNumber,  True , False)
jat0818Author Commented:
BostonMA,
I could possibly get it in the dataset and set a text box to use that field as its source, but I do not see how that would help to get it to stay fixed at the bottom of the page.

Planocz,
I can do it that way for this particular report, but it does reserve that space on every page other than the last.  On another report that I have, the footer is about 4" tall.  I cannot leave that much blank space on all of the the other pages.

Does anybody know if it is possible to modify properties such as location in the Report Code section?  I can see how to change the value, visibility, etc. but the location property cannot accept an expression.
BostonMACommented:
If you shrink the text box and use planocz's suggestion it should not hold any spaces.  Could you provide some screen shots so we can see?
jat0818Author Commented:
Ok, I understand what you are saying.  I only populate the text box on the last page.  That should work fine for this disclaimer, however I have some with much more complicated footers.  It requires many fields, different formatting, underlines for users to sign, etc.  There is no way I can get all of it in a single control.  What I would really like is to put all of this in some sort of container (rectangle??) and position that at the bottom of the last page of the report.
Any thoughts as how I could accomplish that?

Thanks,
I do appreciate the input so far.  
BostonMACommented:
of course a rectangle is the only way is ssrs to acheive complex formating such as underlining certain things but not others. It takes some trial and error.  I would give it a shot and if you get stuck open a new ticket here.

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
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
Microsoft SQL Server 2008

From novice to tech pro — start learning today.