Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by vicky1234

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.

All responses (2)

Answers (0)

vicky1234 64 on at

Like (0)

Report

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

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
Suggested answer

id365font 398 on at

Like (1)

Report

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

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.