Auto report - Page orientation

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

For info, we use AX 2012 R2.

I've been trying to create a layout template that users can choose when they run an auto report. Currently if users try to print these auto reports, they are printed in portrait rather than landscape and the print is very small, too small to read.

If I go to General Ledger > Common > Trial Balance, select a row and click on balance, select File > Print I get a prompt asking for me to select a report. Here I chose Modify > New and went through the wizard. I chose just five fields to display (to return a short row). For the report layout I chose our own layout template and the same for the table style template (I chose our own). The default layout prints in portrait also.

When I view the report on screen, it's in landscape, when I do a print preview it's in portrait and if I actually print the result, not surprisingly it is also in portrait. If I change the printer setting to landscape, the page comes out in landscape, but the report is printed very small in the middle of the page and doesn't use all of the page width.

My question is, how can I print this report in landscape?

Thanks in advance.

*This post is locked for comments

All responses (9)

Answers (1)

Marcin_Szoltysek 10 on at

Like (0)

Report

RE: Auto report - Page orientation

I've tested it on most recent AX 2012 R3 and got the same, on screen seems "landscape" but printed to PDF or printer, always "portrait".
Community Member Microsoft Employee on at

Like (0)

Report

RE: Auto report - Page orientation

This was a while back... but I was told no patch for R2 you'll need to upgrade to R3.
Marcin_Szoltysek 10 on at

Like (0)

Report

RE: Auto report - Page orientation

Hi Rick, did they mention any patch for R2? I've checked LCS but no result for the issue.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Auto report - Page orientation

Hi Rick,

thanks for the update.

Cheers

Soren
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Auto report - Page orientation

UPDATE

Microsoft have confirmed this is a bug in R2 and will be fixed in R3. The Microsoft bug ID is #844620
Community Member Microsoft Employee on at

Like (0)

Report

RE: Auto report - Page orientation

Thanks everyone for your replies.

There maybe a little confusion. The report in question is an autoreport. It's standard "user" functionality. I have not had to create the report myself, it's done on the fly in AX using the autoreport wizard (see the steps in the original post).

In the autoreport wizard, the user has the option to set the report layout template and the table template. I cannot see where in a template I can set the page orientation.

The wizard steps are as follows

1

2

3

4

As I said, the report shows as landscape on screen, but portrait in print preview and when actually printed. I need to find a way to print it in landscape.

Thanks.
Suggested answer

Kumar Gaurav @ MS on at

Like (0)

Report

RE: Auto report - Page orientation

on the design node of your report you can specify the page size and interactive size for your report, so if you have to print on a A4 size , you can specify height 21cm and width as 29.7 cm. The report will adjust the orientation it self. As you are in AX 2012 so this will be done in VS report development environment.
Suggested answer

Umesh Pandit 9,298 User Group Leader on at

Like (0)

Report

RE: Auto report - Page orientation

Check this also,

element.printJobSettings().preferredOrientation(PrinterOrientation::Portrait);

element.printJobSettings().fitToPage(false);

or

AOT>Report>New Report>Design> orientation set to Landscape in report design property.
Suggested answer

Umesh Pandit 9,298 User Group Leader on at

Like (0)

Report

RE: Auto report - Page orientation

Hi Rick.

This link might help you.

technet.microsoft.com/.../ee873254.aspx