Home
Analytics
Maximum number of records to display
Priya R
<p>Hi,</p>
<p> </p>
<p>I would like to know if there is any limit to show the total number of records in a report. if so, how much is the limit?</p>
<p> </p>
<p>Thanks,</p>
<p>Pri</p>
Find more posts tagged with
Comments
SailRCG
<p>Pri, </p>
<p> </p>
<p>I believe the maximum number is dependent on memory. However, if you simply want to show how many records are in a report, you can use a simple "RUNNINGCOUNT" aggregation in your data set. Then add a data element to your report using MAX() in the header of a table: see the attached example. </p>
<p> </p>
<p> </p>
Priya R
<p>Hi SailRCG,</p>
<p> </p>
<p>Thanks for your reply. I wanted to display the whole records not just the total count. Few reports I'm working have more than 100,000 thousand records and I wanted to display all that in an Excel sheet.. When I run the report in BIRT viewer as well in application server, timeout exception is getting. If I specify the Limit in settings, it is working fine.</p>
<p> </p>
<p>Thanks,</p>
<p>Pri</p>