Excel rendering pagination rows limit

Excel rendering pagination rows limit

Posted by: aespinosa on 1 February 2024, 12:25 am EST

• 

  aespinosa

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 1 February 2024, 12:25 am EST

  Hello, i’m trying to render a report to Excel using ExcelRenderingExtension using pagination to separate the data i have into groups using pagebreak in the RDL to separate sheets for every grouping, the problem i have is that using this type of pagination i’m limited to the value of PageHeight property which it’s max value is 160in which causes the data to separate to sheets every ~800 rows. Is there any way to achieve unlimited rows per sheet/group using PageReport render? If not is there any render/export class that can achieve what i need?

  I’m attaching the RDL that i’m using. Thank you.RDL.zip

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 4 February 2024, 5:01 pm EST

  Hi Antonio,

  It is not possible to achieve such an output with just ActiveReports.

  I would suggest you to set MultiSheet property as false of the excel export to false and use a third party tool to split the excel sheet into multiple sheets.

  You may add a simple text saying “–Break sheet here–” at the end of each group and use it as a sheet break flag and remove this text from the final export.