10000 rows max

Hey there,
 
I am new to BIRT and have the following problem: I want to export worktimes, which are several thousand rows. In BIRT the max. number of rows is 10.000 before a page break when I want to export in xls. 
How can I raise the limit of rows?
 
I am using BIRT 4.3.1 and the xls spudsoft emitter
 
Can you please help me?

Find more posts tagged with

Comments

Matthew L.

Try adding the following to your reports beforeFactory method:
<pre class="_prettyXprint _lang-js">
//BIRT 4.3+ go past the 10,000 row limit (10k), place in beforeFactory of a report design.
reportContext.getAppContext().put("MAX_PAGE_BREAK_INTERVAL", 1000000); //1M rows
</pre>

neuling

Hey Matthew thanks for your reply! Unfortunately it did not work, do you have any other suggestions?

Matthew L.

I've investigated this further on two separate copies of OS BIRT 4.3.1.
In one of my copies, the Spudsoft Emitter fails to run but the default XLS emitter works and will export up to 65535 per Excel tab when using the previously mentioned code in the report design.
In the second copy, the Spudsoft Emitter works but I have only been able to export about 36,000 rows of data before hitting an Out-Of-Memory error.
 
Is there a reason you cannot using the default XLS emitter, or could you test to see if this works for you?
I would also try downloading a fresh copy of OS BIRT 4.3.1, with a fresh workspace to see if that makes a difference.
One last thing you could try is to download and install the latest version of the Spudsoft Emitter to see if that makes a difference.