Tuesday, August 07, 2012 1:27 PM
is there a way to add a footnote textbox at the bottom on the last page? My solution is to add a textbox inside the footer and and having this expression on the Hidden=Globals.PageNumber <> Globals.TotalPages.
Now i have the same problem with the empty space like in the following post
Is there any solution for this?
Tuesday, August 07, 2012 1:37 PM
To add a textbox at the last page, do:
Just add a textbox inside the Report Body area (not Page Footer), at the most bottom part of it. This will always be displayed on the last page.
AFAIK, you cannot set the position to consume empty space on the Report Body.
But, what you can do is add a textbox on the footer. Make this textbox hidden, except on the last page of the report.
- Edited by irusulMicrosoft Community Contributor Tuesday, August 07, 2012 1:43 PM
Tuesday, August 07, 2012 1:58 PM"Just add a textbox inside the Report Body area (not Page Footer), at the most bottom part of it. This will always be displayed on the last page."
But the textbox must be at the bottom.
"But, what you can do is add a textbox on the footer. Make this textbox hidden, except on the last page of the report."
This is my current solution. But the empty space (5 - 7 rows) will still be displayed.
- Edited by Noodles_ Tuesday, August 07, 2012 2:11 PM
Wednesday, August 08, 2012 5:05 AM
if you want to display footer (footnotes) only in last page,
use following expression in your textbox properties..
hope it will help.
Find More SSRS Topics @ CrazyErrors
Wednesday, August 08, 2012 6:30 AM
Hello Touseef Kariyania,
this is my current solution. The probelm is that all other sites have many space inside the footer. Since the height isn't dynamic, the result is an ugly document.
Tuesday, August 14, 2012 12:20 PMModerator
Thanks for your posting.
In current release of Reporting Services including SSRS 2012, if we add page header or page footer to the report, the height of the page header or page footer is still reserved within the usable page area on pages where the header or footer is hidden. This behavior is by design.
Based on your scenario, I am afraid the closest approach is trying irusul's suggestion to remove the page footer and place the textboxes in the report body. To make the textboxes be always placed in the bottom of the page, you can increase the height of the report body to the height of the actual physical page size and place the textboxes in the bottom of the report body. Meanwhile, I suggest that you set the bottom Margin of the report to 0.01in, and set the "ConsumeContainerWhiteSpace" to "True" to avoid extra blank page that may be generated due to the preserved white space of the report body.
Personally, I recommend that you submit this suggestion at https://connect.microsoft.com/SQLServer/. If the suggestion mentioned by customers for many times, the product team may consider to add the feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.
Thanks for your understanding.
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, August 19, 2012 3:40 PM