How to enable Export to Excel (Ctrl+E) in file menu of Report Window (After opening the Report)

Finance and Operations/AX Technical Forum
1

Hi All,

Can Anybody tell me How to enable Export to Excel (Ctrl+E) in file menu of Report Window (After opening the Report)

Or Please tell me how to export a report in Excel Spread sheet file from AX 2009

I want to see AX 2009 Reports in Ms Office Excel.

Thank you

2

You cannot export a report data into Excel by doing it.

The alternative way is you can print the report in html file and saving it with the .xls filename extension.

3

Hi Kranthi,

Thank you for your quick reply

I tried that it is working for me now i am able to get excel file properly from print dialog box.

If i want to open this Excel format of report directly from a menuitem button on form means.

How can i achieve this.

Thanks in advance…[:)]

4

You need to put some code for that[:)]

see this https://community.dynamics.com/product/ax/axtechnical/b/daxit/archive/2010/03/17/dynamics-ax-2009-58-exporting-data-to-excel-40-part2-41.aspx it may help you…

5

Thanks a lot