TextBox for footnotes at the end of the report

Question

Hello,

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
http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/fcdd44ed-4c06-45ab-9a31-77d2e024dd6c/

Is there any solution for this?

Regards

Answer 1

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.

Answer 2

"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.

Answer 3

Helloo Noodles,

if you want to display footer (footnotes) only in last page,

use following expression in your textbox properties..

hope it will help.

---

Touseef
Find More SSRS Topics @ CrazyErrors

Answer 4

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.

Answer 5

Hi Noodles_,

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.

Regards,
Mike Yin

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Mike Yin

TechNet Community Support