I make report in dynamics nav consist from item ledger entry table as data item only
I make grouping to item no as following
item no quantity cost amount actual
x1 5 2250
x2 10 2240
I need to export this report to excel.
How i can do that
I make report in dynamics nav consist from item ledger entry table as data item only
I make grouping to item no as following
item no quantity cost amount actual
x1 5 2250
x2 10 2240
I need to export this report to excel.
How i can do that
please check report number 6 trail balance in standard NAV.
there is a table called excel buffer which has got the below 4 functions.
Name
MakeExcelInfo
MakeExcelDataHeader
MakeExcelDataBody
CreateExcelbook
use them and create your excel.
Anil.
For grouping the item you need to group the data on ItemNo using Key
The use either Excel Buffer or Excel Automation for exporting data to excel
If you are using RTC then there is utility avaialbe to export to excel in report itself
Can you told me where this utility found. my dynamic nav is 2009 r2
I have send to Microsoft excel icon above found after i run report but not work are this what you mean or what.
thanks
Are you using RTC client ??
If yes then it is available in Report Preview.
If you are using classic client and you are using Send to excel utility available on toolbar which is available only for Forms and not for reports.
For classic client you need to write a program for exporting data to excel using excel buffer or excel automation.