When you choose Query as the data source, you select a predefined SQL SELECT statement (a query) as specifying the data for your report.
To define the data using Query:
-
While using any of the report wizards, click Query in the Choose Data Source dialog box, and click Next.
The Select Query dialog box displays.
-
Type the name of a query or use the Browse button to find the query, then click Next.
-
Finish interacting with the report wizard as needed for the presentation style you are using.
To learn how to create queries, see Defining queries.
