question

Shanvitha-1847 avatar image
0 Votes"
Shanvitha-1847 asked LukasYu-msft commented

footer information only last page

HI SSRS export team,
I have two text box inside Footer in SSRS
1.page information(below image)
2.Note: this is XXXXXXX

1.71972-image.png



I need Page information display all page when export to PDF but Note: thisxxxxx is only last page

mean my last is both page information and note option
before last its should be only page information

please help on this

sql-server-reporting-services
image.png (477 B)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered LukasYu-msft commented

Place the textbox in report body at the end; so it appears at the end of the report.
Or place it in the footer and add an expression on property "Hidden" like

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

It compares the current page number with the count of total pages and set "Hidden" to false only on the last page.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thnaks so much olaf

0 Votes 0 ·

Great Solution !

0 Votes 0 ·