Maximum number of records to display

Options
Priya R
Priya R
edited February 11, 2022 in Analytics #1
<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>

Comments

  • SailRCG
    SailRCG
    #2
    Options
    <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
    Priya R
    #3
    Options
    <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>

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs