This document demonstrates how to add a chart to a report, provide data for chart series, and set up chart elements. This topic shows two chart series based on the same data source. You can use different data sources for different series.

1.Drop the Chart control from the Toolbox onto the Detail band.

The Chart Designer wizard is invoked. Disable the Display the designer every time a new chart is added option if you do not want to trigger the wizard the next time you create a chart.

Close the wizard at this stage.

2.Click the chart's smart tag to bind the chart to data. Expand the Data Source property's drop-down and click Add New Data Source.

 

Note

Ensure that the report's Data Source property is set to None when you place a chart into the Detail band. Otherwise, the chart is repeated as many times as there are records in the report's data source.

1.Select the chart. Switch to the Chart Tools toolbar tab and click Run Designer.

2.Add a new series to the chart.

oLocate Series in the chart elements tree and click the plus button.

oSelect the series type (for example, Bar) from the invoked list.

3.Populate the created series with points.

oSwitch to the Data tab.

oSelect a data source from the drop-down list.

oDrop data fields onto the Argument and Value cells to define the series' points.

4.Filter series data.

oSwitch to the Properties tab.

oClick the Filter String property's ellipsis button.

oConstruct filter criteria in the invoked FilterString Editor and click OK.

5.Create another series with the same settings. Select the Point view type for this series.

Improve the chart's appearance:

•Remove the chart legend, because the chart series are bound to the same data. Select Legend in the chart elements tree and disable the Visibility check box in the Options tab.

•Select the Label node under Series 1 and disable the Visibility check box to hide point labels.

•Customize the Series 2 markers' appearance. Set Size to 12 and Kind to Inverted Triangle to replace the default circle with an upside down triangle.

•Customize the chart's appearance settings. For instance, select Nature Colors from the drop-down Palette list.

Switch to Print Preview to preview your report.