Can we export the values from Report to Excel?

Sumathi
Sumathi Member Posts: 24
edited 2004-07-05 in NAV/Navision Classic Client
hi,
Can we export the values from Report to Excel?

regards
Sumathi

Comments

  • alberto
    alberto Member Posts: 60
    You can save as HTML file and then use Excel.
  • Faisal
    Faisal Member Posts: 12
    Hi Sumathi,

    Do not get confused by the ID I am Paramjit Singh(eBrahma friend of Srini) How are you? Posting a lot of queries on MIBUSO.

    Well is you if you want to convert a report in to Excel XLS some of various availbale methods the cheapest and of course best is to produce comma delimited output text file and to open it in Excel staright away no conversion no manual work needed. For a CSV file you can use DATA PORT.

    Paramjit
    Faisal
  • vipulchudasama
    vipulchudasama Member Posts: 17
    Go to the report for which you want the values on EXCEL

    Go to File --> "Save as HTML" --> Change the "File Name" with applying extension as ".xls"

    It should work!!! :)
    VIPUL (NAVISION CONSULTANT)
  • afarr
    afarr Member Posts: 287
    The column layout is not always preserved when exporting to Excel. Navision seems to fit the columns of each into the least amount of space possible, so if the report header prints only on the first page, then you might have this result (I have used . to denote spaces):

    Navision report:

    (page 1)
    Customer Outstanding balance Contact
    ABC...............................3................YYY
    DEF................................4................ZZZ

    (page 2)
    GHI................................5................TTT


    Excel report:
    Customer Outstanding balance Contact
    ABC...............................3................YYY
    DEF................................4................ZZZ
    GHI.5.TTT
    Alastair Farrugia

Categories