web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS report static tex...
Finance | Project Operations, Human Resources, ...
Suggested Answer

SSRS report static text print above footer in D365 FO - fixed position

(0) ShareShare
ReportReport
Posted on by vicky1234 66

Hi,

I have a requirement to show a static text (comp bank details) of 4 lines  just above the footer in SSRS report D365 FO .

The problem is that I have added the text in the designer just above the footer but It prints the bank details in the middle of the page in case the sales invoice is of just 1 lines .
My requirement is that irrespecctive of the SO lines it should always print the text just above the footer and the requirement is to print this section in the end of body and not in the footer.

Also note that in case the report prints on multiple pages then it prints the bank details at very top level of the body as there is very less to print in the body content.

Can someone please let me know how can we achive the requirement.

Or do you think that the best position will be footer ? but it needs to be printed only on that last page and in my case the footer is printed on all the pages.

Thanks,

VK.

I have the same question (0)
  • Suggested answer
    id365font Profile Picture
    id365font 398 on at

    Hello,

    Personally I don't think the best place of this requirement was in the body. If you want to place this text only in the last page you can print it in the footer with an expression in the Hidden property. You can easily make an expression controlling the global parameter "TotalPages" and "PageNumber" in order to know if it's the last page or not.

    This expression is used in many standard SSRS Reports in order to do just what you are telling.

    Please mark the answer as correct if it fits.

  • vicky1234 Profile Picture
    vicky1234 66 on at

    Hi Ivan,

    Thankf for the reply,

    So in this case the size of the footer will increase or descrease automatically or it will remain fixed.

    The static text is of around 10 lines and if I keep it at the footer level then in that case lets say it prints on first page then its ok however if it prints on multiple pages and with logic of footer section(only stici part) being printed only on last page.

    In that case will the footer size auto adjust to a smaller one or it will print some balnk spaces

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans