Hello incredible Geeks
I need assistance with how I can print and preview my report in excel format thank you very much
Hey farrell,
NAV Version??
Till NAV 2009 if you want to Print a Report in Excel then you need to write a custom code in your Report to achieve this.
If you are talking about NAV 2013 and later then there’s an inbuilt feature to export your Report.
For writing custom reports you can take help of standard reports. Excel Buffer Table is the Key.
The Version is 2009
Hi,
In standard NAV 2009 R2 you have a option in Preview mode to save as excel. The option bring the output as previewed in excel.
The other way is to custom export to put data on excel as per your requirement. If you want to use that, refer here Standard Report 120 “Aged Accounts Receivable”.
Microsoft have included feature to Print To Excel.
Let us know how it goes.
Hey
I got this piece of code here // ----
CREATE(ExcelApp);
ExcelApp.Visible(TRUE);
Books:=ExcelApp.Workbooks.Add(-4167);
Sheets:=Excelapp.ActiveSheet;
//----
I cant not define variable ExcelApp of type automation i dont seem to see excel as on of the application when i lookup in the globals thankyyou
Are you saying You cant find this variable
For preview Part Whatever said by
Saurav Dhyani
was right .If You Got Now Follow This Link for export to Excel