Series Question

[Gary]

Hello all -

I have a quick question about series.  Given the following result set:

Content Knowledge           Other Supervisor    3.846153
Content Knowledge           Peer                4.423076
Content Knowledge           Primary Supervisor  4.571428
Content Knowledge           Self                4.000000
Cross Cultural Intelligence Other Supervisor    3.933333
Cross Cultural Intelligence Peer                4.941176
Cross Cultural Intelligence Primary Supervisor  5.000000
Cross Cultural Intelligence Self                4.333333
Emotional Intelligence      Other Supervisor    4.375000
Emotional Intelligence      Peer                4.363636
Emotional Intelligence      Primary Supervisor  5.000000
Emotional Intelligence      Self                3.888888
Leadership Attributes       Other Supervisor    4.045454
Leadership Attributes       Peer                4.157894
Leadership Attributes       Primary Supervisor  4.916666
Leadership Attributes       Self                4.083333
Social Intelligence         Other Supervisor    4.050000
Social Intelligence         Peer                4.625000
Social Intelligence         Primary Supervisor  4.181818
Social Intelligence         Self                4.200000

Is it possible to auto generate the series rather than having to create them manually?  In this example there should be 4 series (Self, Peer, Other Supervisor, Primary Supervisor).  The x-axis grouping should be Content Knowledge, Emotional Intelligence, etc.  The y data value should be average score.

It seems if I don't manually create the series but only set the following properties on the chart object, it will create the series for me automatically but it is always of type bar chart and I need a line chart.

chart1.DataGroupColumn = "RaterType";
chart1.Legend.Appearance.GroupNameFormat = "#VALUE";
chart1.PlotArea.XAxis.DataLabelsColumn = "QuestionSetName";

Having to create the series manually seems like a lot of work.  Any insight to this matter will be greatly appreciated.

Thanks!

[Chavdar]

Hello Gary,

You can try by setting the DefaultType property of the Chart report item. For example:

     this.chart1.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.Line;

This property can be set from the Properties grid at design time as well.

Regards,
Chavdar
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.