Suppress Page Header when export to Excel

Suppress Page Header when export to Excel

Posted by: mdynna on 4 March 2025, 12:54 pm EST

• 

  mdynna

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 March 2025, 12:54 pm EST

  When exporting a Page Report to Excel, is there a way to suppress the Page Header after the first time it prints? Essentially, turning the Page Header into a Report Header. We’re exporting with MultiSheet = False so all records are on the same sheet.

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 5 March 2025, 8:24 am EST

  Hi Mark,

  You can set Pagination as ‘false’ in the ExcelRenderingExtension. For reference, please check the following documentation pages:

  • https://developer.mescius.com/activereportsnet/docs/latest/online/excel-export-page-rdl.html
  • https://developer.mescius.com/activereportsnet/docs/latest/online/MESCIUS.ActiveReports.Export.Excel~GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings~Pagination.html
• 

  mdynna

  • Post Options:
  • Link
    Copy

  Posted 5 March 2025, 3:36 pm EST

  Thanks, that is the option I was looking for. I should add that “Forces pagination or galley report layout mode.” is a definition that only has meaning for a limited audience. Some further explanation couldn’t hurt.