To use the chart wizard

1. Open a report definition in the Report Designer.
2. Do one of the following:
   • Click Add Chart To The Report to insert a new chart.
   • On the Design tab, select an existing chart control. On the left pane, in the property grid, select Config, and click the browse button.
3. In the Chart Wizard dialog box, specify the chart layout.
4. Click OK.
5. In the Report Designer, on the Design tab, define the SQL select statement to query the data to be visualized.
6. Select the chart control. In the Control property grid, select Sql, and click the browse button.
7. In the SQL Assistant dialog box, define the SQL select statement that returns the data to be visualized in the chart.

   The query for the chart representation must return an appropriate number of values:

   Line chart—Series (legend text), X, Y

   Point chart—Series (legend text), X, Y

   Bar chart—Legend, value

   Pie chart—Legend, value

   See Report Designer: Chart Control for examples of select statements.

8. Click the Preview tab to generate a preview of the report.