Is it Possible to get a axapta report in excel sheet?

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

Hi Friends,

i want axapta report in excel sheet.

If i save the axapta report it shows only PDF, HTML and Text.

How can i convert the report to the excel directly from axapta?

Thanks in advance.

#2

Use HTML and save the file as .xls

#3

Hi Kranthi.

Thanks for your valuable response.

Ok. It is one of the way to convert to the excel.

But Client asked like

They want a excel sheet directly from the axapta report.

Because they going to take more report in the excel sheet. They cant convert to html and again convert to excel.

Is it possible because there is no option to convert directly to the excel?

thanks.

#4

Hi,

In DAX 2009, there is no out of the box solution for generating Excel reports. You may have to develop this.

#5

Only SSRS reports give you that option.

#6

Hi Arun ,

Its posible , u can save the report direcally in excel. only add a new SysPrintFileType xls. and defined the File micros .xls and modified the four methos in sysPrinForm(isSingleLargePageValid,checkFileType,changeFormat and findFileNameType)

regards

chandresh