Report Chart add up values DataGroupColumn

4 posts, 1 answers
  1. Robert Lampe
    Robert Lampe avatar
    13 posts
    Member since:
    Jan 2010

    Posted 31 Jul 2010 Link to this post

    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
  2. Answer
    Peter
    Admin
    Peter avatar
    1611 posts

    Posted 03 Aug 2010 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. DevCraft banner
  4. Roy Halvorsen
    Roy Halvorsen avatar
    83 posts
    Member since:
    Oct 2008

    Posted 03 May 2011 Link to this post

    Does the Chart item now support out of the box grouping in the newest Telerik Q1 release? Any examples?
  5. Peter
    Admin
    Peter avatar
    1611 posts

    Posted 06 May 2011 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top