I made a report based upon the “WORK ORDER”… and gave “EXPORT TO EXCEL” functionality. Now, the problem is that, I need to give a heading to the EXCEL sheet…such as “WORK ORDER REPORT”, each time the Excel Sheet is created.
Kindly suggest me the solutions…
Just days back I found this link from Denster, thanks to him and Faithie
EnterCell(1, 1, ‘WORK ORDER REPORT’, TRUE, TRUE, FALSE);
When we want a header we add it to the OnPreDataitem 1st cell.
Or are you talking about naming the Tab?
on PostReport Trigger you can write
ExcelBuf.CreateSheet(‘Work Order Report’,‘Vendor’,COMPANYNAME,USERID);