locked
can i detect in an ssrs footer that this is the last footer? RRS feed

  • Question

  • hi we run 2016 enterprise.  i have some text boxes in my footer i'd like to leave blank except if its the last footer.  is there a way to detect that this is the last footer?
    Friday, August 7, 2020 9:11 PM

Answers

  • Hi,

    I think you could try this way to meet your needs.

    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.

    Choose "show or hide based on expression" and enter this code in the expression:

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

    Regards,

    Zoe

    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    • Proposed as answer by Olaf HelperMVP Monday, August 10, 2020 9:43 AM
    • Marked as answer by db042190 Monday, August 10, 2020 3:59 PM
    Monday, August 10, 2020 5:57 AM