Pages

Friday, December 14, 2007

Print report to Excel

I have a client who asked me if it was possible to print a report from AX using Excel as the output media. My first thought was, “Eeeh – no”. But this was something they could do in their old Baan system, so I was really provoked to find a solution.

Actually it turns out that AX has a framework allowing you to integrate your own media as the target for an AX report. This is covered by mainly the ReportOutputUser class hierarchy.

But for some ¤/#&%” reason you can’t really hook this up to the print job settings and get the report engine to use your classes. I hope that will be fixed for 5.0.

In the mean time you’ll have to pull some tricks. In regards to my solution let me just give you this hint; the user should not attempt to make a PDF file with XLS extension of the filename.

Apart from the tricks I had to pull it works really well.

Contact thy:data if you are interested in learning more about the solution.

4 comments:

Lauren said...

How did you do it?

ioana said...

I have the same issue. How did you solve this?

Robert said...

I am very interested in how you did this. Especially the tricks you had to pull.

Did you use the createviewer() method of the ClassFactory class?

Robert

nari said...

Hi,
I am looking for report to excel option.Could you please help me how to do this one.plz send me details to pacharlanaresh@gmail.com

Regards
Naresh p