Options

Export to Excel on Multiple Sheets for Multiple DataItems

sabzamsabzam Member Posts: 1,149
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
Sign In or Register to comment.