Ssrs Show Value Only On Last Page In Body Of Report

I'm attempting to show a sum in a table footer on a report. It will be in the body of the report and can't be in the header or footer. The table footer repeats on each page but s

Solution 1:

I simply resolved it using ...

=iif(Globals!PageNumber=Globals!TotalPages,false,true)

Put that in the Expression editor for the HIDDEN property of all the objects/controls you have in your footer.

It will only show you the footer once the last page is processed.

I hope that's what you meant/want? Thanks

Solution 2:

Can you not just create a group that includes a group footer. Then in the group properties make sure that the "Repeat Group Footer" isn't checked and Sum() the total in the group footer?

Solution 3:

try something like this

=iif(Globals!PageNumber=Globals!TotalPages,data,nothing)

Solution 4:

Just add a textbox below the table. The textbox will be visible after the last page of the table.

Solution 5:

Below solutions can help.

1. Create Functions to access Page Number in Body

https://stackoverflow.com/a/11722295/2218697

2. Add a rectangle

Add a rectangle with required Textbox or other controls in it and set the visibility of Rectangle like below:

=IIF(code.PageNumber=code.TotalPages,false,true) 

This will show the Rectangle as Footer only on last page.