Line PolicyEffectiveDate PolicyYear TotalIncurred ClaimCount
------------------- ----------------------- --------------------------------- ------------
Auto 2002-07-01 00:00:00.000 2002 27510 9
Auto 2003-07-01 00:00:00.000 2003 86348 9
Auto 2004-07-01 00:00:00.000 2004 189816 11
Auto 2005-07-01 00:00:00.000 2005 71493 15
Auto 2006-07-01 00:00:00.000 2006 84040 13
Auto 2007-07-01 00:00:00.000 2007 32843 7
Auto 2008-07-01 00:00:00.000 2008 48563 11
GL 2002-07-01 00:00:00.000 2002 48617 5
GL 2003-07-01 00:00:00.000 2003 305553 4
GL 2005-07-01 00:00:00.000 2005 714 3
GL 2008-07-01 00:00:00.000 2008 23000 2
Property 2003-07-01 00:00:00.000 2003 12782 1
Property 2007-07-01 00:00:00.000 2007 8372 1
WC 2003-07-01 00:00:00.000 2003 384394 25
WC 2004-07-01 00:00:00.000 2004 304270 28
WC 2005-07-01 00:00:00.000 2005 52678 14
WC 2006-07-01 00:00:00.000 2006 4638 2
WC 2007-07-01 00:00:00.000 2007 50125 7
WC 2008-07-01 00:00:00.000 2008 64037 5
I have the following code in my NeedDataSource:
Me.SqlDataAdapter1.SelectCommand.Parameters("@PolicyNum").Value = Me.ReportParameters("@PolicyNum").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@AcctNum").Value = Me.ReportParameters("@AcctNum").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@SaleNum").Value = Me.ReportParameters("@SaleNum").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@Lineid").Value = Me.ReportParameters("@Lineid").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@ParentAgent").Value = Me.ReportParameters("@ParentAgent").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@SubAgent").Value = Me.ReportParameters("@SubAgent").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@StartEffDate").Value = Me.ReportParameters("@StartEffDate").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@EndEffDate").Value = Me.ReportParameters("@EndEffDate").Value
Dim dataSet As New DataSet()
SqlDataAdapter1.Fill(dataSet)
Dim ChartInc As Telerik.Reporting.Processing.Chart = CType(sender, Telerik.Reporting.Processing.Chart)
Dim DefChart As Telerik.Reporting.Chart = DirectCast(ChartInc.ItemDefinition, Telerik.Reporting.Chart)
ChartInc.DataSource = dataSet
I am trying to have 2 different charts: one showing TotalIncurred and one showing ClaimCount as the series. I want to show them by Policy Year and by Line on the same chart, but group them. I thought I could use the DataGroupColumn, so I tried
setting PlotArea->XAxis->DataLabelsColumn to PolicyYear and DataGroupColumn to Line. It isn't working. Any ideas on how to do this?