Telerik Forums
Reporting Forum
1 answer
76 views
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
Telerik team
 answered on 13 Aug 2010
1 answer
124 views
Dear All,

I am using telerik report in mvc 2.0,I am getting report but report toolbar is not clear.
Chavdar
Telerik team
 answered on 13 Aug 2010
1 answer
102 views
I have a report with two groups.  In this report, only the lower-level group footer is displayed, detail lines and the higher-level group footer lines are hidden.  In the footer that is displayed is a link to another report with the field values from the group footer used as parameters to the other report.  Although I am using the Last() aggregate function on both the fields displayed on the group footer and in the report parameters of the link, one of the parameter values I am passing is getting lost when it gets to the routine specified in the other report's data source even though it is displayed correctly in the footer itself.

Does anyone have any suggestions?

Thanks,

Lee Sauer
Milen | Product Manager @DX
Telerik team
 answered on 12 Aug 2010
5 answers
375 views
Is it possible to style report parameters section.

I want to put some labels on there  and plus change backgroud of dropdown lists ,also  to play with the width  and height of parameters entry textbox/dropdownlist ?

Thanks in advance

Regards

Milen | Product Manager @DX
Telerik team
 answered on 12 Aug 2010
0 answers
99 views
Hi,
I need sample code for a chart report, which should have multiple series (Line chart).

Example the Employee sales summary report in "On line Example".
The report data should bind from the database table. Y-Axis should be some range of data(any datatype) and X-Axis should be date/time range.

Thanks,

Regards,
Manoj
manoj
Top achievements
Rank 1
 asked on 12 Aug 2010
0 answers
69 views
Hi
Telerik team please help me ,


I working on mvc telerik .my requirement is report filtering with drop down .i am using partial views and client events of drop down onchange function so how to implement this code please help me .please give any solution 


thanks and regards 

shanker.B 
shanker bangari
Top achievements
Rank 1
 asked on 12 Aug 2010
1 answer
192 views
Hello:
first of all, i want to tell you that i´m new in telerik, and i ´ve searched this problem in the forum but i can´t solve it.
i'm working with a List in the report.
i'm using linq to set the list.datasource  (in the detail_ItemDataBinding event) and it works well, but, when the datasource.count() == 0, all the textbox inside the list give this error

An error has occured while processing TextBox 'textBox22':
The expression contains object 'fechaHora' that is not defined in the current context.

Telerik.Reporting.Processing.Table _listTriage = (Telerik.Reporting.Processing.Table)detailSection.ChildElements.Find("TriageList", true)[0];                   
                   var dsTriag= from d in dc.Guardia.Where(w => w.registroGuardia == id) select d;

it only appears when linq return 0 rows.

In the list i´ve 10 textbox with the property value = = Fields.[fechaHora]

Thanks for your help and sorry for my english.

Sebastián
Chavdar
Telerik team
 answered on 12 Aug 2010
1 answer
90 views
Have just upgraded my website to Reporting 4.1.10.714.  The reporting chart pages execute as expected when run from VS2010.  However, if I publish the website out to my IIS server, then my report viewer shows no data for my report parameter controls.  Two of these controls are drop down lists that are fed from SQL table selections, and the drop downs are empty and the chart will net render since the parameters have no initial value.  In both cases the datasource for the controls is from the same database, accessed by the same userid in SQL.

This all worked fine under VS2008 using Reporting 2008_3_1402.

Any ideas how I might be able to diagnose this?  Thanks.

Dan
Steve
Telerik team
 answered on 12 Aug 2010
0 answers
120 views
I'm currently trying to make a report that displays information from 2 separate sql views. Unfortunately this means I have to make 2 separate reports since I need to use a different dataset for each view. Both sub reports generate 1 column and 24 rows with each value calculated. I simply want to add the rows from both reports into a total on the parent report. Is this at all possible, and if not is there an alternative?
Steven
Top achievements
Rank 1
 asked on 11 Aug 2010
1 answer
359 views
I'm using vb.net and telerik reporting.  I have an object that I set as my report datasource.  This object has an array in it.  When I go to my report and input values in the textboxes or even in the code behind in my report, I do not know how to get the items from the array in the object onto my report.  Does anyone know how to do this?
Steve
Telerik team
 answered on 10 Aug 2010
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?