Microsoft SQL Server 2008
--
Questions
--
Followers
Top Experts
Thanks
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
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.






EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
= IIF(Globals!PageNumber <> Globals!TotalNumber, True , False)
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.

Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Any thoughts as how I could accomplish that?
Thanks,
I do appreciate the input so far.
Microsoft SQL Server 2008
--
Questions
--
Followers
Top Experts
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.