excel format tool

shwetashweta Member Posts: 94
Is there any tool which can convert navision report in to excel format.
Please reply

Comments

  • kinekine Member Posts: 12,562
    You can save the report as html and open the html in excel. Layout is weird but it is fastest solution.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • tinoruijstinoruijs Member Posts: 1,226
    What Kamil suggests works fine. And if you make sure the column headings are small, you will have the best result when you open the file in Excel. And the more your NAV-report looks like a Excel-document, the better the result in Excel will be.

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • shwetashweta Member Posts: 94
    tinoruijs wrote:
    What Kamil suggests works fine. And if you make sure the column headings are small, you will have the best result when you open the file in Excel. And the more your NAV-report looks like a Excel-document, the better the result in Excel will be.

    It is working but the designing is disturbed when it is opened in excel format
  • tinoruijstinoruijs Member Posts: 1,226
    shweta wrote:
    tinoruijs wrote:
    What Kamil suggests works fine. And if you make sure the column headings are small, you will have the best result when you open the file in Excel. And the more your NAV-report looks like a Excel-document, the better the result in Excel will be.

    It is working but the designing is disturbed when it is opened in excel format

    I know. It all depends on how your report in NAV is designed.
    If you for example have the following design, Excel will have problems with placing columnheader3.

    columnheader1 columnheader2
    ________columnheader3


    The following is better:

    columnheader1 columnheader2
    columnheader3

    Tino Ruijs
    Microsoft Dynamics NAV specialist
Sign In or Register to comment.