Rank 2
Iron
Iron
Iron
Hello.
I am using ASP.NET Framework, and in the Telerik.Reporting.Graph section I have a chart that is populated by a stored procedure.
The output of my stored procedure has three columns: DayOfMonth, ProductionType, and Value, and it is structured as follows.
| DayOfMonth | ProductionType | Value |
| 1 | Staple | 1244 |
| 1 | SumAll | 3066.2 |
| 1 | Tow | 1822.2 |
| 2 | Staple | 624.9 |
| 2 | SumAll | 3984.6 |
| 2 | Tow | 3359.7 |
| 3 | Staple | 1865.38 |
| 3 | SumAll | 5126.18 |
| 3 | Tow | 3260.8 |
ProductionType has three values: Tow, Staple, and SumAll.
I need SumAll to be displayed as a line chart, and Tow and Staple to be displayed as bar (column) charts within the same chart.
DayOfMonth should be displayed horizontally on the X-axis and represent the days of the month.
No matter how much I tried, I could not limit the ProductionType values in the line chart using the filters in:
- series < lineSeries1 < GraphGroup < Filters
- series < SeriesGroup < Filters
so that only ProductionType = SumAll is shown in the line chart.
The only place where I managed to apply this filter was in:
- Data < SeriesGroup < Filters
but that filters the entire dataset, causing the bar chart to be filtered as well.
Please help me with this issue.
A sample of my code is attached.
Thank you.