Using Query

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:

  1. 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.

  2. Type the name of a query or use the Browse button to find the query, then click Next.

  3. Finish interacting with the report wizard as needed for the presentation style you are using.

To learn how to create queries, see Defining queries.