Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

PAGE FOOTER wants to show in last page only

Posted on by 5,885

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
    Blue Wang 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
    @rp@n 5,885 on at
    RE: PAGE FOOTER wants to show in last page only

    thanks Blue

  • Blue Wang Profile Picture
    Blue Wang 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
    Blue Wang 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
    @rp@n 5,885 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
    Blue Wang on at
    RE: PAGE FOOTER wants to show in last page only

    Yes.

  • @rp@n Profile Picture
    @rp@n 5,885 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
    Blue Wang 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
    @rp@n 5,885 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
    Blue Wang 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans