Export NAV 5.0 SP1 Reports to Excel (Native DB)

Hi Sundar,

You can use the Excel Buffer table in NAV to export reports into Excel. Look at Report 6 for an example. But you would need to write a line of code to export every single field in NAV report into Excel. There is no other way aroung this.

The other way, is to use Surya’s method of exporting to HTML and opening the report in Excel. But the results may not be desirable, as alignments of fields will be out.

jordi