Report with layout export to excel, PrintArea, TitleColumns, TitleRows

kabroco

Is there a way to predefine in the layout- report in NAV, the PrintArea, Print TitleColumns And TitleRows in Excel?

The print to PDF fits on one page, but in Excel I get two pages.


(I know, to show the header, I can use de report header section, but I get far to many rows in Excel, that is not a solution.)

Thanks in advance.

binilabraham

Hi kabroco, Instead of using Default Print to excel, in NAV you can use table 370 Excel Buffer for Excel input/output. There is functions to help you export to Excel.

Please take a look at an default example report 'Aged Accounts Receivable'.
In that you can find functions MakeExcelInfo, MakeExcelDataHeader, MakeExcelDataBody and CreateExcelbook.

Hope this may help you.

kabroco

Hello binilabraham, I know of the excel buffer and we use this several times for other purposes. But in this case we want the speed of the layout method. But thank you for your help.