We are using Birt 2.6.2 to generate the excel reports.
We have two report design files(for two report types).
For one report design file, excel generation working fine for large data. It automatically adds new sheet in the excel. Its working properly.
For this we are using static design file.
For another report design file, excel generation fails with following exception for large data(more than 67000 rows). This design file is generated dynamic.
If the no. of rows are less than 65,000 then its working properly.
Caused by: java.lang.NegativeArraySizeException
What could be the reason for above exception?
Is there anything wrong in design file or something wrong in my code?
Hiren Parghi wrote:
> Actually i found following thing. My report has following property:
> <property name="layoutPreference">auto layout</property>
> If i remove the auto layout then excel creates new sheet once first
> sheet reach to 65535 rows. But it shows only 8 columns even though i
> have 20 columns in the report.
> If i keep the auto layout then excel is not generated properly.It throws
On auto layout, have you set the page break interval on your table? You
might try setting that to something like 100 and seeing if you can force
it to work that way, otherwise are you able to use the spudsoft xls emitter?