Microsoft Dynamics AX (Archived)

Purchase order Report Converting to PDF

(0) Share

Report

Posted on by srinivas pamidi

1,737

i am Adding Some New Fields in the Footer Page of the Visual studio.

I am View the Report in Ax All Data Is Coming in One Page.

when i am Converting to PDF the data Not Coming Properly,

In that Newly Added Fields Last Field is Comes in Every Page in PDF Format.

i want that New Fields in Last Page of the PDF Format.

How to Get this.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Hariharans87 3 on at

Like (0)

Report

1. Please refer this link for to display the fields only on last page

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

stackoverflow.com/.../ssrs-show-value-only-on-last-page-in-body-of-report

2. "when i am Converting to PDF the data Not Coming Properly,"

The value are not coming in the PDF or the PDF report is not fit in one page. Please explain.

If it is not fit in one page in PDF, you should check and adjust your SSRS report page and design size.

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

Hi Hariharan,

Thank you For your Reply,

My scenario is I am adding four Text Fields in the Footer Section of the Visual Studio and I am view the report in Ax it is coming in One Page and I am save this one to PDF the footer data is coming on Every Page.

Like I have 11 Items in the Purchase order when i am Converting to PDF First 8 Lines are Come in one page and Footer Section is also Coming, remaining Three lines are come in the Next Page and foollwed by Footer section.

I want the Footer Section in Only the Second Page.

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

Header and footer sections will display in all page. If you don't want to display in all page, move the contents from footer to body section. It will display only one time.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

In order to display report footer only on the last page of the report. You need to follow the below steps.

Right click the report footer.

Go to Footer properties.

Check "Display footer for this page".

Check "Print on last page".

Save, build, deploy. (Make sure to clear all the cahce).

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

@Syed saad, If you uncheck the print on first page, it won't display only on first page but it will display on other pages.

e.g. If you have 3 pages report, footer won't display on first page. But it ll display on second and third pages. I faced this issue on header part.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Yes @Hariharan, you are right.

@Srinivas, if you want your footer to be displayed only on the last page you need to follow below steps,

In the report footer add a rectangle.

Set the Visibility expression of the rectangle in the footer to below expression,

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

Now place your textboxes in the rectangle inside your footer.

Keep in mind that the report footer will not display but it will exist on every page. So in PDF you will get an extra space on every page.

All done......

Was this reply helpful? Yes No