Auto report - Page orientation

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi Rick.

This link might help you.

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

Was this reply helpful? Yes No
Suggested answer

Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Kumar Gaurav @ MS on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

UPDATE

Microsoft have confirmed this is a bug in R2 and will be fixed in R3. The Microsoft bug ID is #844620

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Rick,

thanks for the update.

Cheers

Soren

Was this reply helpful? Yes No
Marcin_Szoltysek 10 on at

Like (0)

Report
Copy link

Link copied!

Hi Rick, did they mention any patch for R2? I've checked LCS but no result for the issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Marcin_Szoltysek 10 on at

Like (0)

Report
Copy link

Link copied!

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".

Was this reply helpful? Yes No