Incremental Loading

Incremental loading limits the amount of data that is returned for each database query. This allows users to load reports incrementally, starting with a small set of rows and adding more in steps as desired.

Incremental loading can shorten the amount of time it takes a report to load and be usable. It can also help reduce continuous load on a database which may improve load balancing performance.

To enable it, set Admin Console > General > Database Settings > Row Limit Step Size to a value greater than 0. This value sets the initial number of rows returned when the report is first executed, as well as the number of rows returned for each subsequent query.

Note

We recommend setting Row Limit Step Size to a minimum of 1000.

The step size can be overridden for with a smaller value at the report-level with the Advanced Report Designer’s Report Viewer option Report Row Step Limit.

Choosing a Row Limit Step Size that allows most reports to avoid reaching the limit entirely is ideal since truncated results can affect report accuracy. Summary data may not be accurate if not all of the pertinent rows are available for aggregation. Another consideration is performance. If there are a lot of slow running reports due to the amount of data being returned, then the need to balance between report completeness in the first execution vs performance by limiting the number of rows returned will need to be considered. Each environment is unique, so the 1000 row recommendation can be used as a starting point and then fine tuning applied.

Usage

With incremental loading enabled, when an ExpressView is run or a report is run in the Report Viewer (the interactive toolbar must be enabled), the report will only query the first number of rows specified in the configuration setting.

If there are fewer rows than the full data set:

• (v2021.1+) a link displays on the toolbar with the message Showing X Results. Click the link to load more data:
  • Load X more Records — get the next number of data rows and add them to the existing report
  • Load All Data — get the remainder of the data set
• (pre-v2021.1) an alert icon displays on the toolbar with the message “Truncated results displayed” unless the report qualifies for Infinite Scrolling.
  

  

  Alert icon in Report Viewer, pre-v2021.1

   

  

  Alert icon in ExpressView, pre-v2021.1

   

  Click the icon to retrieve more data. Choose from:

  • Generate +number to retrieve the next number of rows and add them to the report. (The number is determined by the Row Limit Step Size setting).
  • Generate All to get the full data set.

Note

Exporting a truncated report from the Report Viewer generates a file with only the existing rows.

Incremental loading has no effect for Dashboards, Chained Reports, or Scheduled Reports. Exporting from the Report Tree and Advanced Report Designer is not affected by incremental loading.