Give Heading To Excel Sheet

Dynamics 365 Business Central/NAV User Forum
1

Hi,

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…

2

Just days back I found this link from Denster, thanks to him and Faithie

http://www.archerpoint.com/blog/Posts/beloved-report

3

OnPreDataItem()
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?

4

on PostReport Trigger you can write

ExcelBuf.RESET;

ExcelBuf.CreateBook;

ExcelBuf.CreateSheet(‘Work Order Report’,‘Vendor’,COMPANYNAME,USERID);

ExcelBuf.GiveUserControl;