Eclipse Community Forums: BIRT » can't get more than 500 results

Help

Home

Home » Eclipse Projects » BIRT » can't get more than 500 results

Show: Today's Messages :: Show Polls :: Message Navigator

can't get more than 500 results [message #1110331]

Mon, 16 September 2013 18:42

Gibran Shah

Messages: 33
Registered: September 2013

Member

Hello,

Whenever I preview my results in the data set editor, it says: Total 500 record(s) shown. Result contains more records that are not displayed.

Now, this is fine, but it seems like my data set onFetch script has no access to these non-displayed records either. I have a counter variable that I increment in my onFetch script which I print in the onClose script, and it only reaches 500.

How can I increase the number of records my onFetch script has access to. Or better yet, how do I remove the limit on number of records all together?

Report message to a moderator

Re: can't get more than 500 results [message #1110656 is a reply to message #1110331]

Tue, 17 September 2013 06:38

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Have you ran the report in the web viewer or another non-preview output? The limit of 500 can be changed in the designer preferences if you need to see all the records in preview mode.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: can't get more than 500 results [message #1110949 is a reply to message #1110656]

Tue, 17 September 2013 14:44

Gibran Shah

Messages: 33
Registered: September 2013

Member

Thanks Michael, that helps.

I tried viewing it in web viewer and it takes forever to load. The dataset I'm dealing with is monstrous. Even bumping up the limit to 5000 is not enough to get all the data that's relevant to my purposes. This is a sticky situation I'm in but at least my question is now answer. So thanks.

Report message to a moderator