Wednesday, 28 December 2016

How to display information only on the last page within the page footer in SSRS

Since SSRS does not have a report footer, it can be challenging to figure out how to display information one time within the page footer on the last page. Here is one workaround that works well.
At the top of the page footer, add a rectangle. Change the hidden property of the rectangle to:
=IIF(Globals!PageNumber=Globals!TotalPages,false,true)
In order to not upset the height of the footer area on the last page, the first control after the rectangle (The rest of the page footer information) needs to overlap the rectangle.

No comments:

Post a Comment

Foreign currency revaluation currencies not showing in drop down in dynamics 365 finance & Operations 8.0

In the previous versions you can see all currency codes in the currency drop down, but Dynamics 365 finance and operations 8.0 you don'...