SSRS show value only on last page in body of report

Question

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 should show the sum only on the last page. It will show another piece of text on all other pages. Is this possible?

Additional pieces of information: The detail part of the table isn't a consistent height, but the page is a consistent height. I can't assume a standard number of detail items per page.

Just to be clear. I was talking about adding it to table footer and not the page footer. It should still be in the page body.

Answer 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

Answer 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?

Answer 3

try something like this

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