footer information only last page

Shanvitha 221 Reputation points
2021-02-25T05:19:28.71+00:00

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 42,561 Reputation points
    2021-02-25T06:43:29.847+00:00

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful