xtrareports-3291-feature-guide-to-devexpress-reports-use-report-controls-use-charts-use-charts-to-visualize-grouped-data.md
This topic describes how to use charts to visualize grouped data in a report.
In this tutorial, the report data is grouped against the CategoryID field. A chart is placed in the Group Footer band and is not bound to data. The report’s data source is used to populate the chart with data.
Follow the steps below to make each chart instance display data for its group.
Click the chart’s smart tag and select Run Designer.
Add a new series. Click the plus button next to the Series item in the Chart Designer.
Provide data for the argument and value axes.
Filter the chart. Go to the Properties tab. Click the FilterString property’s ellipsis button to invoke the FilterString Editor.
Click OK in the FilterString Editor and in the Chart Designer to apply changes.
Switch to Print Preview to see the result.
The code sample below illustrates how to filter chart data in code. An XRChart instance named chart is placed in the Group Footer band.
using DevExpress.XtraCharts;
// ...
// Create a new chart parameter and bind it to the report's group field (CategoryID). Prepend the group field's name with the data member's name.
chart.Parameters.Add(new XRControlParameter("controlParameter1", null, "queryProducts.CategoryID"));
// Create a chart series.
Series series = new Series("Series 1", ViewType.Bar);
// Show product names on the Argument axis.
series.ArgumentDataMember = "queryProducts.ProductName";
// Show product prices on the Value axis.
series.ValueDataMembers.AddRange(new string[] { "queryProducts.UnitPrice" });
// Set up a filter to show products from the specified category only.
series.FilterString = "queryProducts.CategoryID = ?controlParameter1";
// Set up a filter to show products from the specified category only. Use the created parameter's name in the filter string.
series.FilterCriteria = CriteriaOperator.Parse("queryProducts.CategoryID = ?controlParameter1");
chart.Series.Add(series);
Imports DevExpress.XtraCharts
Imports DevExpress.Data.Filtering
' ...
Dim chart As New XRChart()
' Create a new chart parameter and bind it to the report's group field (CategoryID). Prepend the group field's name with the data member's name.
chart.Parameters.Add(New XRControlParameter("controlParameter1", Nothing, "queryProducts.CategoryID"))
' Create a chart series.
Dim series As New Series("Series 1", ViewType.Bar)
' Show product names on the Argument axis.
series.ArgumentDataMember = "queryProducts.ProductName"
' Show product prices on the Value axis.
series.ValueDataMembers.AddRange(New String() { "queryProducts.UnitPrice" })
' Set up a filter to show products from the specified category only.
series.FilterString = "queryProducts.CategoryID = ?controlParameter1"
' Set up a filter to show products from the specified category only. Use the created parameter's name in the filter string.
series.FilterCriteria = CriteriaOperator.Parse("queryProducts.CategoryID = ?controlParameter1")
chart.Series.Add(series)