When you define a report, you can specify whether the system should select all the data for the report when you execute it, or whether it should select the data for each navigation step when you carry out that step.
- Select all data
When you execute the report, the system selects the data at the lowest level of detail required for that report and loads that data in the main memory. The system then displays the report. In comparison with the option "Select data step by step", this setting has the advantage that it does not prevent you from using any other report functions. However, performance problems may arise when processing large amounts of data.
- Select data step by step
The system does not display all report data when you execute the report. At first, the system only displays data for the initial list. For each navigation function that you execute after that, the system selects the data required for the resulting list. This option improves response times, but does not allow you to use certain functions which require all of the report data at once (such as the download to XXL).
There are two places in which you can make these settings:
- On the Options tab page in the Data import group.
- In the dialog box when you first save the report definition (after creating a new report). Here, choose the required option.