Report in Excel Format

rashi.kaushik

Hi all,

Is there a way in Axapta to save a report directly in Excel. Also i want to print data in multiple excel sheets based on some criteria.

Thanx in advance.

Mugur

Hi,

Axapta does support printing of a report into a file, but the only allowed formats are: txt,rtf,pdf & html.

You can do some customization for this purpose. I think that printing into Excel is more difficult to achieve (that is if you want to keep the data format as it looks in Axapta), and i'm not certain if someone can create a tool to work for all reports. That is because each report in Axapta has its own Desing/Designs (which may be very different from another's report Design) and this tool would have to match dinamically all Axapta design with the Excel files in order to export the data correctly.

If you create a solution for a particular report, it could be made to work dinamically for all reports which respect the same data format template.

Thanks,
Ciprian

jfrey

Hi
There is printer driver print2excel. You can download a trial version at
http://www.print2excel.com/login.asp.
Regards
Joerg

steenandreasen

There exists an add-on module for Axapta using Excel for reporting. It might be worth checking out: http://www.atlasxl.com.au/Products.htm

Best regards,
Steen Andreasen
http://www.steenandreasen.com/axaptabook.asp

kgaurav

Hi Rashi,

There are various ways to save a report in MS excel, first and the straight forward approach is in the output option you can set the output medium as an excel file, but as you are saying that depending on various criteria you want to create many excel file than i belive you need to use the com connector concept of axapta in through which nee files are created as well as data from excel file are retrived. The classes used will be com and comvarient.

Hope it will help you.

Bye

KGaurav =;

susana2

Hi, the TXT format can be imported in Excel as a CSV file. For manual use, it might be appropriate.

Harish

Hi Rishi,

In addition to the other excellent suggestions -
it is not too difficult to develop reports using Excel VBA integrating either directly with Axapta via COM or the SQL back end route etc.

Once developed these reports could easily be hosted on the company Intranet or just could be distributed to users.

Regards,