asmgx
asmgx

Reputation: 8054

SSRS Report Footer

I know about Page Footer, and I know I can make it look like Report Footer by controlling the visibility of Page Footer.

I want Report Footer it only shows in the very last page of the report.

The problem with the work around above is that it will reserve the space for the page footer and because what I want to be in report footer is quiet large in size (almost one third of the page) the Page footer work around is not a good solution.

Anyone has any other idea how to fix that?

I am using SSRS 2008 R2

Upvotes: 0

Views: 1747

Answers (1)

Lucky
Lucky

Reputation: 4493

I tested this and it works.

Right click the textbox or item you want to hide in your footer and go to properties. Click the visibility tab in the properties pane. Check show or hide based on expression and enter this code in the expression:

=IIF(Globals!PageNumber = Globals!TotalPages, False, True)

This will hide your footer for all pages except the last.

Upvotes: 1

Related Questions