cross tab fetching data error

I am working on birt 2.3. I made a report using cross tab(data cubes). It gives error when i tried to fetch many rows(almost 2000 rows) while its working fine if i fetch some rows. Is there any limitation in Birt? I want to show more than 20000 rows can you please tell me how i can generate report with 20000 rows.

Thanks.

I got following error

"The following items have errors:

ReportDesign (id = 1):
- Retrieving binding data error
Retrieving binding data error ( 5 997 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Retrieving binding data error at org.eclipse.birt.report.engine.internal.document.v4.DataItemExecutor.doExecute(DataItemExecutor.java:96) at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:293) at org.eclipse.birt.report.engine.internal.document.v4.ExtendedItemExecutor.prepareChildExecutor(ExtendedItemExecutor"

Find more posts tagged with

Comments

mwilliams

Hi Soft,

Are you getting this error in the BIRT report designer or are you using the BIRT design engine in another program?

iggster

<blockquote class='ipsBlockquote' data-author="soft">I am working on birt 2.3. I made a report using cross tab(data cubes). It gives error when i tried to fetch many rows(almost 2000 rows) while its working fine if i fetch some rows. Is there any limitation in Birt? I want to show more than 20000 rows can you please tell me how i can generate report with 20000 rows.</blockquote>
 
I am running BIRT 2.2 and find that the limit gets reached at about 4000 rows. This has been reported before (see <a class='bbc_url' href='http://dev.eclipse.org/newslists/news.eclipse.birt/msg28493.html'>http://dev.eclipse.org/newslists/news.eclipse.birt/msg28493.html</a>) but there have been no follow ups. Is there anyone out there who knows the cause / solution ? 
 
TIA

soft

I get error in BIRT report designer. I am still trying to solve this issue. It will be greate help if some one give hints or solution.

agbnmrtam

I get this error too, but only using 'frameset' servlet in Birt Viewer. It seems frameset servlet does not use context variables for limitation in web.xml