Specifications

Retrieving data
232 InfoMaker
Retrieving data
In a report, you can prompt for retrieval criteria, retrieve rows as needed, and
save retrieved rows to disk.
Prompting for retrieval criteria in a report
You can define your report so that it always prompts for retrieval criteria just
before it retrieves data.
❖ To prompt for retrieval criteria in a report:
1 If the Column Specifications view is not already displayed, select
View>Column Specifications from the menu bar.
In the default layout for the Report painter, the Column Specifications
view displays in a stacked pane under the Properties view. All columns
defined for the report are listed in the view.
2 Select the Prompt check box next to each column for which you want to
specify retrieval criteria at runtime.
When you specify prompting for criteria, InfoMaker displays the Specify
Retrieval dialog box just before a retrieval is to be done.
Each column you selected in the Column Specification view displays in the
grid. You can specify criteria here exactly as in the grid in the Quick Select
dialog box. Criteria specified here are added to the
WHERE clause for the SQL
SELECT statement defined for the report.
Testing in InfoMaker
You can test the prompting for criteria by retrieving data in the Preview view
of the report.