How to open the report directly in excel farmat

Dynamics 365 for Finance and Operations/AX Technical Forum
#1

Hi All

I need small help in report ,How can i open reports directly in Excel farmat in ax2009.and how can i show the reports in graphs can you please help me anyone.

Thanks in Advance

Nani

#2

Hi,

You can use the below written code to get the report in excel format…

public boolean fetch()

{

boolean ret;

;

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

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

element.printJobSettings().fileName(@'D:\abc.xls);

ret = super();

return ret;

}

#3

This answered my question too.