Problem is displaying data in StackedSpline chart

[manoj]

Hi,
I have created a report with StackedSpline chart. The report should display the chart for each device with its parameter values(Y-Axis) vs DateTime(X-Axis). Following the code snippet of the report.

namespace Reports
{
    using System;
    using System.ComponentModel;
    using System.Drawing;
    using System.Windows.Forms;
    using Telerik.Reporting;
    using Telerik.Reporting.Drawing;

    /// <summary>
    /// Summary description for Report2.
    /// </summary>
    public partial class Report2 : Telerik.Reporting.Report
    {
        public Report2()
        {
            /// <summary>
            /// Required for telerik Reporting designer support
            /// </summary>
            InitializeComponent();

            //
            // TODO: Add any constructor code after InitializeComponent call
            //
            this.reportTableAdapter1.Fill(this.temp1.report);
        }

        private void chart1_NeedDataSource(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.Chart procChart = (Telerik.Reporting.Processing.Chart)sender;
            procChart.DataSource = this.temp1;

            chart1.Series[0].DataYColumn = "ParamValue";
            chart1.PlotArea.XAxis.DataLabelsColumn = "timeDate";
            chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 300;
            chart1.PlotArea.Appearance.Dimensions.Margins.Bottom = Telerik.Reporting.Charting.Styles.Unit.Percentage(30);
            chart1.PlotArea.Appearance.Dimensions.Margins.Right = Telerik.Reporting.Charting.Styles.Unit.Percentage(30);
        }


    }
}

The chart is plotting the values in one line for all the parameters. But I want to display the parameter values in different line for each parameter name.

My database table looks like this,

DateTimeStamp	Parameter_Name	ParamValue	DeviceID
7:03:58 PM	PM_PH_A_ABC	125	129
7:03:59 PM	PM_PH_A_ABC	125	129
7:04:00 PM	PM_PH_A_ABC	25	129
7:04:01 PM	PM_PH_A_ABC	125	129
7:03:58 PM	PM_XYZ	125	129
7:03:59 PM	PM_XYZ	125	129
7:04:00 PM	PM_XYZ	5	129
7:04:01 PM	PM_XYZ	50	129
7:03:58 PM	PM_PH_A_ABC	100	133
7:03:59 PM	PM_PH_A_ABC	25	133
7:04:00 PM	PM_PH_A_ABC	8	133
7:03:58 PM	PM_XYZ	125	133
7:03:59 PM	PM_XYZ	15	133
7:04:00 PM	PM_XYZ	7	133

From the above table I need to show two lines(PM_PH_A_ABC, PM_XYZ) in the graph.

In my report I am getting one line for the two parameters. Please refer the attached output of my report

Can anyone please help me how to plot lines for each parameters(the parameters are dynamic) in the StackedSpline chart.

Thanks in advance.

Regards,
Manoj

[Steve]

Hi Manoj,

Currently it is not possible to achieve what you're after in the chart item, due to missing functionality. A possible solution would be to generate the chart using our RadChart for ASP.NET AJAX control and show the image in the report through the PictureBox item. You can see sample implementation in the following code library: Use asp:chart in Telerik Reports.
Basically what you need to do is set the ValuesYColumns to the desired parameter e.g.:

RadChart1.DataManager.ValuesYColumns = new string[] {"Parameter_Name"};

All the best,
Steve
the Telerik team