Specifications

Using Quick Select
156 InfoMaker
Using Quick Select
The easiest way to define a data source is using Quick Select.
❖ To define the data using Quick Select:
1 Click Quick Select in the Choose Data Source dialog box in the wizard and
click Next.
2 Select the table that you will use in the report.
For more information, see “Selecting a table” next.
3 Select the columns to be retrieved from the database.
For more information, see “Selecting columns” on page 158.
4 (Optional) Sort the rows before you retrieve data.
For more information, see “Specifying sorting criteria” on page 159.
5 (Optional) Select what data to retrieve.
For more information, see “Specifying selection criteria” on page 159.
6 Click the OK button in the Quick Select dialog box.
You return to the wizard to complete the definition of the report.
Quick Select
limitations
When you choose Quick Select as your data source, you cannot:
• Specify grouping before rows are retrieved
• Include computed columns
• Specify retrieval arguments for the
SELECT statement that are supplied at
runtime.
To use these options when you create a report, choose SQL Select as your data
source. If you decide later that you want to use retrieval arguments, you can
define them by modifying the data source. For more information, see Chapter
6, “Enhancing Reports.”