How to make AX normal Reports in to Excel report in AX2009

We can make Normal Ax reports into Excel Report in 3 Ways .

1) Open ax reports click ctrl+p

Printer SetUp Window->File -> Give file name ->  Test.xls,fatmat ->ASCII.Select the location .report automatically convrted to Excel.

2)  we can write few lines of code in fetch method after  the super().

public boolean fetch()

{

boolean ret;

;

element.printJobSettings().setTarget(Printmedium::File);

element.printJobSettings().format(Printformat::ASCII);

element.printJobSettings().fileName(@’C:\Projectionsreport\Projection.xls’);

ret = super();

return ret;

}

The Above path If you want You can create Folder then only this report will be sit in that place.

3) we can use the class to create report as Excel .

 

Link: http://axhelpdesk.blogspot.in/2013/03/how-to-make-ax-normal-reports-in-to.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s