SSRS show value only on last page in body of report

sql-server reporting-services reportingservices-2005
BenMaddox picture BenMaddox · Nov 17, 2009 · Viewed 29.4k times · Source

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

Fandango68 picture Fandango68 · Feb 12, 2014

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

Related questions

SSRS report not displaying data

I have just created an SQL Server 2005 SSRS report and the data is not being displayed in the Preview pane. The dataset is correctly populated from a stored procedure against a String parameter. I can execute it in the Data …

Read More
how to set SSRS Report parameters to be optional i.e Non-Mandatory field in SSRS 2005

Please help me to set the SSRS Report parameters to be optional i.e Non-Mandatory field in SSRS 2005.

Read More
How do I pass parameter TO SSRS report FROM ASP.NET page which has the reportviewer for the report

I have an ASP.NET page which has report viewer control to access reports from report manager. I need to pass report parameter from this ASP.NET page to the report server. I want to pass region number based on …

Read More