Chart with Dynamic Series

To create a report with a Chart control bound to data

This chart ensures that all series will be auto-created using the series template specifying common data binding properties for all series..

The data for all series (the series names along with series points' arguments and values) must be stored in the same data table. Also, the series view type and certain other settings should be the same for all the created series.

In this example the 'GSP' table of the sample gsp.mdb database will be used. This table contains the Gross State Product (GSP) statistics for some US regions.

1. Create a new report.

2. Drag Chart from the Toolbox onto the report's Detail band.

   

   Note: At this point, the Chart Wizard may be displayed (if its Show wizard every time a new chart is added option is enabled). Click Cancel to close the wizard's window and manually customise the chart.

3. To bind the chart to a data source, click its Smart tag, and in the displayed actions list, expand the Data Source dropdown selector and click Add New DataSource.

   The Report Wizard is displayed.

   

   The wizard will guide you through the process of assigning a data source to the chart. For detailed instructions on the wizard's steps, refer to Bind a Report to Data, as this process is similar.

   The specified data source is then assigned to the chart's Data Source property. The Data Member property is also set, which specifies which table or view of the dataset the chart should obtain data from, as is the Data Adapter property.

   

   Note: The report's Data Source property must be set to None. Otherwise, the chart will be blank when previewed.

   

4. Specify a Series Data Member and Adjust a Series Template

5. Customise the Chart

   The chart is now complete.

6. Switch to the Preview tab to view the result.

   

   For further information of another method of binding a chart to data, refer to Chart with Static Series.