I am working on a report , where i have to display a stackbar chart . But chart does not display accurate data .
please find attachement for report pdf and code file . please help me Asap.
Private Sub Chart1_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles chart1.NeedDataSource |
Try |
Dim StrSqlConnection As String = ConnectionString |
If Trim(StrSqlConnection) <> "" Then |
If Not ObjSqlCon Is Nothing Then |
ObjSqlCon = Nothing |
End If |
ObjSqlCon = New SqlConnection(StrSqlConnection) |
ObjSqlCon.Open() |
If ObjSqlCon.State = ConnectionState.Open Then |
Dim chart1 As Telerik.Reporting.Processing.Chart = CType(sender, Telerik.Reporting.Processing.Chart) |
Dim defChart As Telerik.Reporting.Chart = DirectCast(Chart1.ItemDefinition, Telerik.Reporting.Chart) |
Dim ProjectRpt As New ProjectTrendDstTableAdapters.ReportProjectTrendAnalysisTableAdapter |
ProjectRpt.Connection = ObjSqlCon |
Dim ProjectDst As New ProjectTrendDst.ReportProjectTrendAnalysisDataTable |
ProjectDst = ProjectRpt.GetData |
SalesPersonQChart.DataSource = ProjectDst |
defChart.DataGroupColumn = "Status" |
defChart.PlotArea.XAxis.DataLabelsColumn = "Territory" |
defChart.Legend.Appearance.GroupNameFormat = "#VALUE" |
End If |
End If |
Catch ex As Exception |
Finally |
If ObjSqlCon IsNot Nothing Then |
ObjSqlCon = Nothing |
End If |
End Try |
End Sub |
Naginder Singh