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

Modifying a query

To modify a SQL query statement or the columns displayed in your report:

  1. In the Data Model view, click the query object, then right-click and choose Data Wizard.

  2. To change the SELECT statement, click the Data tab.

  3. To change the break groups, click the Groups tab.

  4. To add or change summary columns for totals, click the Totals tab.

  5. To change which selected database columns are displayed in your report, choose Toolsright arrowReport Wizard, then click the Fields tab.

To modify the properties of a query:

  1. In the Data Model view, click the query object, then right-click and choose Property Inspector.

  2. In the Property Inspector, modify the properties as desired.

See also

Creating a local query