Matrix to excel

skosta
skosta Member Posts: 6
edited 2008-05-27 in NAV/Navision Classic Client
I need to export form "Items by Location" (matrix like Analysis by Dimensions) to pivot table in Excel 2007.

Please help ASAP!

Comments

  • punossound
    punossound Member Posts: 35
    If you are using NAV 5.0, you can use the stylesheets button(located at the standard menu button). If you are using older version. You may write a code in the form Item by Location and use the buffer table to export it to excel.
    ma
  • skosta
    skosta Member Posts: 6
    Thanks punossound, I'm using NAV 4.0. I need the Excel file to look exactly like matrix box in NAV, and I don't know how to make it happen through code.

    Any suggestions, examples,...

    Anyone?
  • punossound
    punossound Member Posts: 35
    Example of how to use the excel buffer table in nav is in the FORM 113 - Budgets menu button Function > Export. Navigate the code.

    Finding how it works is very interesting. :D
    ma
  • skosta
    skosta Member Posts: 6
    I need to export data into Excel Pivot table, like Analysis by Dimensions.

    Anyone, help...
  • Nitesh
    Nitesh Member Posts: 43
    Refere report no. 82 Export Budget to Excel.It may help you..

Categories