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 .

Thanks

DAX