Report in Excel Format

rashi.kaushik
rashi.kaushik Member Posts: 52
edited 2006-05-31 in Dynamics AX
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.

Comments

  • Mugur
    Mugur Member Posts: 93
    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
    Kind regards,

    Ciprian Dudau
    Axapta Developer
  • jfrey
    jfrey Member Posts: 43
    Hi
    There is printer driver print2excel. You can download a trial version at
    http://www.print2excel.com/login.asp.
    Regards
    Joerg
    Navision 3.70, SQL Server 2000, Citrix Metaframe
  • steenandreasen
    steenandreasen Member Posts: 5
    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
    kgaurav Member Posts: 32
    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
    susana2 Member Posts: 2
    Hi, the TXT format can be imported in Excel as a CSV file. For manual use, it might be appropriate.
  • Harish
    Harish Member Posts: 172
    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,
    Harish Mohanbabu
    Long way to go before I sleep..

Categories