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.

score 16 · Answer 1 · answered Feb 12 '14 at 04:44

16

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

answered Feb 12 '14 at 04:44

Fandango68

4,461
4
39
74

2

Not OP, but I had a similar problem and this worked for me. Thanks! – thnkwthprtls Jun 16 '16 at 17:27
The downside of this is that the space reserved for the footer is still visible - as is shown [here in the comment section](https://thinkaboutit.be/2012/12/show-a-footer-only-on-the-last-page/) and I tested too :( This works if your footer is and the report itself has the same the same color, though. – Mauricio Arias Olave Jun 16 '20 at 21:56

score 1 · Answer 2 · answered Nov 17 '09 at 20:49

1

try something like this

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

answered Nov 17 '09 at 20:49

DForck42

19,789
13
59
84

4

You can't use globals in the page body. – BenMaddox Nov 17 '09 at 20:51
well you contradict yourself a couple of times in your post, stating that you do and then don't want it in the footer. which is it? – DForck42 Nov 17 '09 at 21:29
I want it in a table footer, not the report footer. – BenMaddox Nov 17 '09 at 21:45

score 1 · Accepted Answer · answered Nov 18 '09 at 15:38

1

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?

answered Nov 18 '09 at 15:38

Nathan

160
1
1
7

4

That is not an answer. It's another question. Why was this even voted? – Fandango68 Aug 30 '16 at 01:19

score 0 · Answer 4 · edited Nov 15 '17 at 00:52

0

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

edited Nov 15 '17 at 00:52

SteveJ

3,034
2
27
47

answered Nov 14 '17 at 22:52

Sohail

1

score 0 · Answer 5 · answered Jun 17 '21 at 15:15

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.

score -1 · Answer 6 · answered Nov 17 '09 at 21:31

if you want it in the body, if the rest of the report's layout shifts dynamically, it won't render in the same spot. otherwise it should render in the same spot and you can just put it at the bottom of the last page.

remember, a page is 8 1/2 x 11. if you have 1 inch margins, the first page ends at 6.5 inches.

score -1 · Answer 7 · edited Aug 04 '16 at 12:37

-1

Hidden:

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

use the above one on the hidden property of the footer.

edited Aug 04 '16 at 12:37

Pedram

6,256
10
65
87

answered Nov 21 '13 at 01:20

Michelle

1

SSRS show value only on last page in body of report

7 Answers7

Linked