excel format tool

shweta
shweta Member Posts: 94
edited 2008-05-14 in NAV/Navision Classic Client
Is there any tool which can convert navision report in to excel format.
Please reply

Comments

  • kine
    kine 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.
  • tinoruijs
    tinoruijs 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
  • shweta
    shweta 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
  • tinoruijs
    tinoruijs 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

Categories