Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the maximum number of rows I can display from the results of a query?

April 26, 2017display maximum query results rows

0

Posted

What is the maximum number of rows I can display from the results of a query?

1 Answer

0

Posted

QLR Manager displays reports in blocks of pages, or “page sets”. The number of rows in a page set is defined as the reportRows value in the qlr.ini file created when QLR Manager is installed. If the block size is set to 500 (default value), then 500 rows can be displayed at one time. QLR Manager can create up to 1,000 page sets for a report. Therefore, using this reportRows setting, 500,000 rows of data can be displayed. If queries do generate more than the allowable maximum rows, you can either use the “Group” Action in the Layout panel to compress rows, or Group the data in your query with the SQL “Group By” function. Navigation links (First, Back, More, Last) are provided above the report output to move between page sets. The value established during installation and recorded in the qlr.ini file becomes the default for the installation. There is also a “Max displayed rows” control in the Report Body section of the Layout panel that will override the installation default. If this val