XLSX reports max records per worksheet

Hi All,
 
I am generating xlsx report.After reaching 10,000 records,records are displayed in another worksheet.
 
Can any one tell me what is the max limit for displaying records per sheet?
I want to display all records in one worksheet.
 
 
Report layout is Auto layout.
 
Thank you,
Kavitha

Find more posts tagged with

Comments

shamo

Take a look at this and use this export setting if it helps

Matthew L.

The "MAX_PAGE_BREAK_INTERVAL" in BIRT 4.3+ has a max default of 10,000 rows (Unknown Reason).
However you can work around this issue by placing the following line of code in the beforeFactory method of your report to allow it to export 1 million rows per page (Assuming you set the Page Break Interval of the table to 0).
<pre class="_prettyXprint _lang-js">
reportContext.getAppContext().put("MAX_PAGE_BREAK_INTERVAL", 1000000);
</pre>

KavithaDeepak

Thank you for your reply..
 
Mathew,
 
your suggestion worked.

ronald_ecq

Muchas Gracias. Me sirvio mucho.