Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (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>