SSRS only shows the value on the last page in the report summary

Question

I am trying to show the amount in the footer of a table in a report. It will be in the body of the report and cannot be in the header or footer. The table footer is repeated on each page, but should only show the amount on the last page. It will display another piece of text on all other pages. Is it possible?

Additional information: The detailed part of the table does not correspond to the height, but the page represents a constant height. I cannot accept the standard number of parts per page.

Just to be clear. I talked about adding it to the table footer, not the page footer. It should still be in the body of the page.

Answer 1

Can you not just create a group containing the group footer. Then, in the group properties, make sure that the “re-group footer” is not checked, and that Sum () is the total number in the group footer?

Answer 2

I just decided to use it ...

=iif(Globals!PageNumber=Globals!TotalPages,false,true) 

Put this in the Expression editor for the HIDDEN property of all the objects / controls that you have in the footer.

It will only show the footer after processing the last page.

I hope you wanted / wanted? Thanks

Answer 3

try something like this

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

Answer 4

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

Answer 5

if you want it in the body, if the rest of the report layout changes dynamically, it will not be displayed in the same place. otherwise, it should appear in the same place, and you can just put it at the bottom of the last page.

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

Answer 6

Is hidden:

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

use the information above about the hidden property of the footer.