Matrix to excel

skosta

I need to export form "Items by Location" (matrix like Analysis by Dimensions) to pivot table in Excel 2007.

Please help ASAP!

punossound

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.

skosta

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

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.

skosta

I need to export data into Excel Pivot table, like Analysis by Dimensions.

Anyone, help...

Nitesh

Refere report no. 82 Export Budget to Excel.It may help you..