Wednesday, December 28, 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

Power Automate vs Azure Logic Apps vs Azure Data Factory: What They Are, When to Use Them, and How to Integrate Non-Microsoft Systems

  In today’s cloud-first, API-driven enterprise landscape, automation and integration have become vital pillars of operational agility. Micr...