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

kabrocokabroco Member Posts: 111
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.

Answers

  • binilabrahambinilabraham Member Posts: 45
    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.
    Software Developer,
    Archerpoint India Pvt. Ltd,Chennai.
  • kabrocokabroco Member Posts: 111
    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.
Sign In or Register to comment.