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

Adding a newline into a string in C# and X++

Below is the sample code we can use for  adding a newline after every occurrence of "@" symbol in the string in C#   using System...