The easiest way to define a data source is using Quick Select.
To define the data using Quick Select:
Click Quick Select in the Choose Data Source dialog box in the wizard and click Next.
Select the table that you will use in the report.
For more information, see “Selecting a table”.
Select the columns to be retrieved from the database.
For more information, see “Selecting columns”.
(Optional) Sort the rows before you retrieve data.
For more information, see “Specifying sorting criteria”.
(Optional) Select what data to retrieve.
For more information, see “Specifying selection criteria”.
Click the OK button Quick Select dialog box.
You return to the wizard to complete the definition of the report.
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.”
