Hi All,
I have 3 columns of data that get returned from a stored procedure. Date, Error code,
and Quantity. On one day we can have 8 different error codes, with different quantities.
For example on the date of 18 Nov we had error code 101 = 24, error code 102 = 36,
error code 103 = 4, etc. I am trying to display the different error codes in columns
with their quantity by date. There will be multiple columns for a given day because
the error codes range from 101 -124. How can I display this? I currently have Just one
at a time being display based on which the end user picks.
If DS.Tables.Count > 0 AndAlso DS.Tables(0).Rows.Count > 0 Then
ErrorCodes.DataSource = DS
ErrorCodes.Series("Exceptions").XValueMember = "Error Date"
ErrorCodes.Series("Exceptions").IsValueShownAsLabel = True
ErrorCodes.Series("Exceptions").YValueMembers = "Total"
ErrorCodes.ChartAreas("ChartArea1").AxisX.MajorGrid.Enabled = False
ErrorCodes.ChartAreas("ChartArea1").AxisY.MajorGrid.Enabled = False
ErrorCodes.ChartAreas("ChartArea1").AxisX.Interval = 1
ErrorCodes.DataBind()
ErrorCodes.Legends.Add("Legend")
ErrorCodes.Legends("Legend").Enabled = False
ErrorCodes.Legends("Legend").Docking =DataVisualization.Charting.Docking.Right
End If
Thanks for your help.