A script-enabled browser is required for this page to function properly.

Creating a query: SQL Query tool

To create a SQL query:

  1. In the Data Model view, single-click the SQL Query tool in the tool palette.

  2. Click in the main area (canvas region) of the window.

  3. In the SQL Query Statement dialog box, define a SELECT statement for the query:

  4. Click OK.

  5. Refine the query using either of the following methods:

  6. Repeat Steps 1 through 5 for each query you want to create.

Note: If you define multiple queries in the Data Model view of your report, the Data page does not appear when you invoke the Report Wizard to default the layout.

Next step

Creating a data link

Creating a default layout for a report

See also

Creating a query

Creating a query: Data Wizard

Creating a query: XML Query tool

Creating a query: JDBC Query tool

Creating a query: Text Query tool

Creating a query: Express Server Query tool

Creating a query: OLAP Query tool

Creating a query: Ref Cursor Query tool