locked
hide/remove header and footer RRS feed

  • Question

  • Hi,

    How I want remove header and footer in SSRS for the last 6 page.

    Thank You

    Tuesday, August 29, 2017 7:26 AM

Answers

  • Hi nurulizzati,

    As I know, there is no direct Visibility Properties to hide the Page Header/Footer. So one workaround is that you could hide items in Page Header/Footer to achieve your goal.

    You want to hide the last six pages’ Page Header/Footer, you could set Visibility of Text box in it like below

    =iif (Globals!PageNumber>6,true, false)

    this represents only first 6 pages have Page Header.

    If you have any question, please feel free to ask.
    Best regards,
    Zoe Zhi

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by nurulizzati Wednesday, September 6, 2017 2:08 AM
    Wednesday, August 30, 2017 1:26 AM
  • Hi nurulizzati,

    You could try to use expression below in Visibility of text box properties to achieve this goal

    =iif (Globals!PageNumber>Globals!TotalPages-6,true, false)

    Or 

    =iif(Globals!OverallPageNumber > Globals!OverallTotalPages-6,true, false)

    If you have any question, please feel free to ask.
    Best regards,
    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    Wednesday, August 30, 2017 9:08 AM

All replies

  • Hi nurulizzati,

    As I know, there is no direct Visibility Properties to hide the Page Header/Footer. So one workaround is that you could hide items in Page Header/Footer to achieve your goal.

    You want to hide the last six pages’ Page Header/Footer, you could set Visibility of Text box in it like below

    =iif (Globals!PageNumber>6,true, false)

    this represents only first 6 pages have Page Header.

    If you have any question, please feel free to ask.
    Best regards,
    Zoe Zhi

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by nurulizzati Wednesday, September 6, 2017 2:08 AM
    Wednesday, August 30, 2017 1:26 AM
  • Hi Zoe Zhi,

    Thank You for your answer.But the problem is how to control visibility for example the 6 last pages...means the earlier page is not fixed maybe 1 page or more..thankyou in advance.

    Wednesday, August 30, 2017 1:39 AM
  • Hi nurulizzati,

    You could try to use expression below in Visibility of text box properties to achieve this goal

    =iif (Globals!PageNumber>Globals!TotalPages-6,true, false)

    Or 

    =iif(Globals!OverallPageNumber > Globals!OverallTotalPages-6,true, false)

    If you have any question, please feel free to ask.
    Best regards,
    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    Wednesday, August 30, 2017 9:08 AM
  • Hi nurulizzati,

    Did you solve this problem? If yes and if you would like to, you can post a reply to share your solution or mark corresponding post as answer. That way, other community members could benefit from your sharing.

    Thanks for your understanding and support.
    Best Regards,

    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, September 4, 2017 5:29 AM
  • Its working! Thank Youuuuuu~ :)
    Tuesday, September 5, 2017 2:32 AM