Export to Excel on Multiple Sheets for Multiple DataItems

sabzam
sabzam Member Posts: 1,149
edited 2010-05-20 in NAV/Navision Classic Client
Hi All,

So I have a report I need to export to excel

I have 3 data items and I want each data item on seperate Sheets but in the same work book

Can you please help me with this as it seems it cannot be done

I have inserted
TempExcelBuffer.CreateBook;

in the onPreData Item of the first DataItem and subsequently

TempExcelBuffer.CreateSheet(Text000,Text000,COMPANYNAME,USERID);
TempExcelBuffer.GiveUserControl;

in on PostDataItem of each other Data Item but is giving the following error

" This Automation Variable has not been instantiated. You can instantiate it by either creating or assigning it"

Can you please help me with this

Thanks

Categories