Finance | Project Operations, Human Resources, ...

How to display footer only last page in SSRS report in D365FO

(0) Share

Report

Posted on by Rahul.p

632

HI Friends,

My query is, I have a SSRS Report - PurchPurchaseOrder, In footer we have 20 line and we want to show footer only last page.

Could you please help me how footer will show only last page In d365fo.

Thank's and Regards

Rahul

I have the same question (0)

All responses (7)

Answers (0)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Rahul,

As this is related to SSRS development, you can probably better ask your question on the SSRS forum. social.msdn.microsoft.com/.../home

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Page footers are used for something you want to show on every page. You can hide its content at some pages, but the footer will still consume space, which you likely don't want if it has twenty lines of text. Therefore a page footer isn't the right solution for your requirement.

I would simply put it at the end of the report body.

Was this reply helpful? Yes No
Rahul.p 632 on at

Like (0)

Report

@Martin Darb

I would simply put it at the end of the report body.

If i keep after body and if body is ending middle of second page, then footer some part is coming second page and some is coming third page.

Is there any solution for that?

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

The exact solution depends on your particular design. For example, the Tablix control has "Keep together on one page if possible" property for this purpose.

Was this reply helpful? Yes No
Rahul.p 632 on at

Like (0)

Report

The exact solution depends on your particular design. For example, the Tablix control has "Keep together on one page if possible" property for this purpose.

How to achieve this?

If report contain 1-4 item only one page has generated and everything is fine.

But if report contain more then 10 items then only footer some part is coming second page and some is coming third page.

Was this reply helpful? Yes No
Suggested answer

reachnaidu 890 on at

Like (0)

Report

Hi Rahul,

I did not test it myself but can you try to hide the report footer with an expression for all pages except the last page

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

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

It's possible, but it'll have the problem I mentioned in my first reply ("you can hide its content at some pages, but the footer will still consume space, which you likely don't want if it has twenty lines of text").

Was this reply helpful? Yes No