My report currently has a page number expression at the very bottom of the page footer. On the last page of the report, I'd like to display some report notes immediately above the page number expression (that is, at the bottom-most position of the page). The report notes is a fixed piece of text composed of seven lines.
I achieve this using a textbox in the page footer and controlling its visibility using the CurrentPage and TotalPage i.e. =Iif(Globals!PageNumber = Globals!TotalPages, false, true)
But I find that on the pages other than the last page, the page number expression renders several centimeters up the page (when exporting to PDF).
In other words, the page footer takes up the space of the report notes textbox, even though it renders to hidden.
My report has the ConsumeContainerWhitespace set to true.
Does anyone have a way to resolve this?
I would place your text in a textbox in a rectangle on your report body and have that control location and visibility. Placing it at the bottom of the report will ensure it is after all content.
If you ~must~ have it in the footer then I would try using the function of the footer content to control the value shown in a single text box.
answered Jan 18, 2013 at 11:12 AM