If a report retrieves hundreds of rows, there can be a noticeable delay while all the rows are retrieved. For these reports, InfoMaker can retrieve only as many rows as it has to before displaying data.
For example, if a report displays only 10 rows at a time, InfoMaker only needs to retrieve 10 or more rows before presenting the data. Then, as users page through the data, InfoMaker continues to retrieve what is necessary to display the new information. There may be slight pauses while InfoMaker retrieves the additional rows, but these pauses are usually preferable to waiting a long time to start working with data.
To specify that a report retrieve only as
many rows as it needs to:
Select Rows>Retrieve Options>Rows As Needed from the menu bar.
With this setting, InfoMaker presents data and returns control to you when it has retrieved enough rows to display in the report.
Retrieve Rows As Needed is overridden if you have specified sorting or have used aggregate functions, such as Avg and Sum, in the report. This is because InfoMaker must retrieve every row before it can sort or perform aggregates.
In a multiuser situation, Retrieve Rows As Needed might lock other people out of the tables.
