Bar and line chart in a single chart

[Mohamad Javad]

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.

 

[Mohamad Javad]

Hello,
I added the attached Report1.cs to an ASP.NET (Web .NET Framework) project using the Add → Project menu and the wizard. I display it using Telerik ReportViewer.
I am sending the entire project and the method I used to add it as attachments.

Thank you.

[Ivet]

Hello Mohamad,

Thank you for the project and the screenshots. Could you please take a look at the response I sent and give the report a try? If anything comes up or you have questions, feel free to reach out.

[Ivet]

Hi Mohamad,

Thank you for the provided files.

If I understand correctly, you want to configure your graph so that only the SumAll series is shown as a line while Tow and Staple remain as bar series.

What I did to achieve the result you wanted was to change the SeriesGroup property of lineSeries1 to staticGroup so that the three lines would be reduced to just one.

After that, I changed the expression of the Y‑axis so that the line would appear on top of the bars. You can see the expression and sample screenshot below:

= Sum(Fields.ProductionType = "SumAll" ? Fields.Value : 0)

I am sending you the fixed report. You can download and test it.

If further questions arise, do not hesitate to ask.

Regards,
Ivet
Progress Telerik