Report Chart add up values DataGroupColumn

[Robert Lampe]

Hi Guy,

I have a problem with the next chart inside my report.

I have the following data

Name	Year	Amount
Company A	2009	5
Company A	2009	5
Company B	2009	5
Company B	2009	5

I want two bars, one for Company A at X-axis value 2009 and Y value: 10, second is Company B with X-axis value 2009 and Y value 10.

The current situation is that I get two bars, for company A, one company B with both value: 5

How can I add up these values?

            this.chart1.DataGroupColumn = "Name";
            this.chart1.DataSource = this.sqlDataSource1;
            this.chart1.PlotArea.XAxis.AutoScale = false;
            this.chart1.PlotArea.XAxis.DataLabelsColumn = "Year";

Thank you,
Robert

[Peter]

Hi Robert Lampe,

Currently the Chart item doesn't support out of the box grouping. However this is on our To Do list and we will introduce this feature in a subsequent version of Telerik Reporting. In the meantime as a workaround our suggestion is to group and aggregate your data appropriately in the SQL query as shown in the following example:
 

SELECT Name,Year,SUM(Amount) FROM Orders
GROUP BY Name

 

All the best,
Peter
the Telerik team

[Roy Halvorsen]

Does the Chart item now support out of the box grouping in the newest Telerik Q1 release? Any examples?

[Peter]

Hi Roy Halvorsen,

The task for a chart item that supports grouping is with high priority. However the chart item included in Q1 2011 still don't support grouping.

Regards,
Peter
the Telerik team