Birt Runtime: limited number of rows per XLSX-Sheet

birttom

<div>Hi,</div><div> </div><div>first of all, i use version 4.3.1.</div><div> </div><div>i have a problem when I want to retrieve a birt report from the birt runtime on </div><div>my tomcat webserver with the output format xlsx.</div><div> </div><div>The DataSet contains more than 10.000 lines, but there are only 33 rows per a xlsx sheet and</div><div>the result set is split in multiple work sheets.</div><div> </div><div>The complete result set is shown in only one work sheet, when I increase the page height</div><div>of the master page to (unrealisitc) high numbers. This can not be done, because it should also be possible</div><div>to use the same report design for other output formats like PDF (with "normal" page break).</div><div> </div><div>Does anybody have an idea what the problem is, or how can I retrieve xlsx, xls reports with the maximum number of rows?</div><div> </div><div> </div><div>Thanks in advance</div><div> </div>

mwilliams

<p>Try setting the design layout to auto.  If this report will be ran in PDF format as well where you want the fixed layout, you can put a script in your report's beforeFactory like:</p><p> </p><p>if (reportContext.getOutputFormat == "xlsx"){</p><p>    reportContext.getDesignHandle().layoutPreference = "auto layout";</p><p>}</p><p> </p><p>That should be close, anyways.  Let me know.  If that doesn't work, change the page break interval on your table to 0 when the output is xlsx using the same check as above.</p>