0

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

Dijkgraaf
  • 11,049
  • 17
  • 42
  • 54
asmgx
  • 7,328
  • 15
  • 82
  • 143
  • 1
    One alternative maybe could be adding the footer data at the end of your report body instead of the footer – niktrs Jun 23 '17 at 03:24
  • this will not make the footer data at the end of the last page.. it will be just after the report body. – asmgx Jun 23 '17 at 04:09
  • I have tested it and it works. You have to size your report height to match your print page size, and move the "footer" fields at the report bottom. The only disadvantage I can think is the tablix last page size makes the "footer" print in a page it self – niktrs Jun 23 '17 at 05:16
  • thats one thing, the other it is not aligned to the bottom of the page – asmgx Jun 23 '17 at 05:20
  • Since footer can not be hidden or resized with custom expressions, I cannot think somethink better than what I have already suggested. I hope someone else has a better idea – niktrs Jun 23 '17 at 11:21

1 Answers1

1

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.

Lucky
  • 4,443
  • 2
  • 8
  • 18