Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » can't get more than 500 results
can't get more than 500 results [message #1110331] Mon, 16 September 2013 18:42 Go to next message
Gibran Shah is currently offline Gibran ShahFriend
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?
Re: can't get more than 500 results [message #1110656 is a reply to message #1110331] Tue, 17 September 2013 06:38 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
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
Re: can't get more than 500 results [message #1110949 is a reply to message #1110656] Tue, 17 September 2013 14:44 Go to previous messageGo to next message
Gibran Shah is currently offline Gibran ShahFriend
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.
Re: can't get more than 500 results [message #1111127 is a reply to message #1110949] Tue, 17 September 2013 20:53 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Yeah. If it's a monstrous dataset, it'll take a while to run the report, most likely. Good luck!

Michael

Developer Evangelist, Silanis
Previous Topic:Suppressed Column
Next Topic:Error while opening .rptdesign file in Eclipse Juno
Goto Forum:
  


Current Time: Sat Oct 23 07:48:56 GMT 2021

Powered by FUDForum. Page generated in 0.01259 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top