can't get more than 500 results

gib65

<p>Hello,</p><p> </p><p>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.</p><p> </p><p>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.</p><p> </p><p>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?</p>

CBR

<p>Hi,</p><p> </p><p>this is just a setting for the preview. This preview is "preview report" and "preview data in the dataset dialog". This is the reason why you also do not see all the data if you do a preview report in the designer. </p><p> </p><p>If you are running the report in "Display in Webviewer" it does not use this limit and you should therefore be able to see all the data.</p><p> </p><p>If you want to remove the limit completely: <a data-ipb='nomediaparse' href='http://birtworld.blogspot.de/2006/10/birt-preferences.html'>http://birtworld.blogspot.de/2006/10/birt-preferences.html</a></p><p>The blog post is quite old and the dialog look a bit different in the current version. The reason why i m relating to it is just because i just want to let you know how you can open the birt settings.</p><p>Have a look at section data to change the limit for the preview in the dataset dialog, and Preview->Data to change the limit for the preview report.</p>