Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

PAGE FOOTER wants to show in last page only

(0) ShareShare
ReportReport
Posted on by 6

Hi All,

Can you please let me know , i have added PAGE FOOTER in SSRS report but my requirement is to print the page footer in LAST PAGE only.

As i know , PAGE FOOTER will print every pages not the last page.

pagefot.jpg

How i will achieve this.

Please give me more shed on this.

Thanks!

  • Blue Wang Profile Picture
    on at
    RE: PAGE FOOTER wants to show in last page only

    You are welcome.

    By the way, you posted two threads with the same requirements, if you get a solution, please close them both, thank you.

    community.dynamics.com/.../how-i-will-print-header-only-first-page-and-footer-only-last-page-on-ssrs-report

  • @rp@n Profile Picture
    6 on at
    RE: PAGE FOOTER wants to show in last page only

    thanks Blue

  • Blue Wang Profile Picture
    on at
    RE: PAGE FOOTER wants to show in last page only

    Find this, you can try this method:

    social.msdn.microsoft.com/.../print-specific-items-only-on-last-page

  • Verified answer
    Blue Wang Profile Picture
    on at
    RE: PAGE FOOTER wants to show in last page only

    HI @rp@n,

    Yes, the expression is correct.

    For white space.  Sorry. I don't know the way of removing the white space taken by a reserved footer.

    Maybe you can refer to the Sum group to change your report design, without using the page footer.

  • @rp@n Profile Picture
    6 on at
    RE: PAGE FOOTER wants to show in last page only

    ok, the below expression

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

    is checking the total number of pages. based on that it will make visible true and false.

    means for last page only true

    rite?

    for other pages , except last page the blank space will come. is there any solution for this?

  • Blue Wang Profile Picture
    on at
    RE: PAGE FOOTER wants to show in last page only

    Yes.

  • @rp@n Profile Picture
    6 on at
    RE: PAGE FOOTER wants to show in last page only

    blue,

    the 3rd point

    you mean to say each control rite?

    and the expression in each control as they mentioned in blogs. that one?

  • Verified answer
    Blue Wang Profile Picture
    on at
    RE: PAGE FOOTER wants to show in last page only

    HI @rp@n,

    Your another thread:community.dynamics.com/.../how-i-will-print-header-only-first-page-and-footer-only-last-page-on-ssrs-report

    The blog you have shared is very clear, I am not very clear, where are you confused.

    rahulmsdax.blogspot.com/.../how-to-display-information-only-on-last.html

    In short:

    1. Add page footer to report

    2. Add controls to the Page footer (other data or what to display according to your own needs)

    3. Then open the properties of the control, click on the visibility, select according to the expression, enter the expression condition.

  • @rp@n Profile Picture
    6 on at
    RE: PAGE FOOTER wants to show in last page only

    ok, please let me know the steps . how i will achieve

  • Verified answer
    Blue Wang Profile Picture
    on at
    RE: PAGE FOOTER wants to show in last page only

    HI @rp@n,

    No, every page of the Page footer will exist, but the controls and content will not be displayed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,202 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans