Telerik Forums
Reporting Forum
1 answer
107 views
I have a report viewer in a silverlight control, and when it loads it comes up blank until I hit refresh on the viewer, and then the report is finally loaded. What could be happening? Here's the code I'm using:

public ReportWrapper()
{
    InitializeComponent();
 
    this.rptViewer.RenderBegin += new Telerik.ReportViewer.Silverlight.RenderBeginEventHandler(rptViewer_RenderBegin);
    this.Loaded += ReportWrapper_Loaded;
 
    this.rptViewer.ReportServiceUri = new Uri("http://webserver/reportserver/reportservice.svc");
    this.rptViewer.Report = "ReportLib.TestReport";
}
 
void rptViewer_RenderBegin(object sender, Telerik.ReportViewer.Silverlight.RenderBeginEventArgs args)
{
 
    args.ParameterValues["ID"] = ID;
}
Steve
Telerik team
 answered on 08 Jun 2012
1 answer
157 views
Hello,

I have 2 dates which i need to display on x axis labels.

For Eg : 04/01/12 to 04/30/12
is the text and I want to display it as-

04/01/12
   to
04/30/12

i can get the dates in separate column or in a single column , whatever is convenient.
please let me know a way I can display the labels in the above format.

thanks!
-priti
Elian
Telerik team
 answered on 08 Jun 2012
1 answer
151 views
Hi

I have a bar chart and want to display the Y axis label from codebehind.
I tried with code -

 Chart1.PlotArea.YAxis.AxisLabel.TextBlock.Text = "%"

but that does not show up on the chart.
please suggest how can i make a Y axis label displayed.

thanks!
-priti
Elian
Telerik team
 answered on 08 Jun 2012
1 answer
213 views
Hi there,

Im going through a similar situation:
I have a chart inside a report that wont bind at all, iv tried several options

REPORT.DESIGNER.CS===============================================================
 partial class ReportUserCompletion
    {
        #region Component Designer generated code
        /// <summary>
        /// Required method for telerik Reporting designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ReportUserCompletion));
            Telerik.Reporting.Charting.ChartAxisItem chartAxisItem1 = new Telerik.Reporting.Charting.ChartAxisItem();
            Telerik.Reporting.Charting.ChartAxisItem chartAxisItem2 = new Telerik.Reporting.Charting.ChartAxisItem();
            Telerik.Reporting.Charting.ChartAxisItem chartAxisItem3 = new Telerik.Reporting.Charting.ChartAxisItem();
            Telerik.Reporting.Charting.ChartAxisItem chartAxisItem4 = new Telerik.Reporting.Charting.ChartAxisItem();
            Telerik.Reporting.Charting.ChartAxisItem chartAxisItem5 = new Telerik.Reporting.Charting.ChartAxisItem();
            Telerik.Reporting.Charting.ChartAxisItem chartAxisItem6 = new Telerik.Reporting.Charting.ChartAxisItem();
            Telerik.Reporting.Charting.ChartAxisItem chartAxisItem7 = new Telerik.Reporting.Charting.ChartAxisItem();
            Telerik.Reporting.Charting.ChartSeries chartSeries1 = new Telerik.Reporting.Charting.ChartSeries();
            Telerik.Reporting.Charting.Styles.Corners corners1 = new Telerik.Reporting.Charting.Styles.Corners();
            Telerik.Reporting.Charting.ChartSeries chartSeries2 = new Telerik.Reporting.Charting.ChartSeries();
            Telerik.Reporting.Charting.Styles.Corners corners2 = new Telerik.Reporting.Charting.Styles.Corners();
            Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
            this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
            this.pictureBox1 = new Telerik.Reporting.PictureBox();
            this.textBox7 = new Telerik.Reporting.TextBox();
            this.detail = new Telerik.Reporting.DetailSection();
            this.chart1 = new Telerik.Reporting.Chart();
            this.odsReportGraph = new Telerik.Reporting.ObjectDataSource();
            this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
            ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
            //
            // pageHeaderSection1
            //
            this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Cm(4.5D);
            this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.pictureBox1,
            this.textBox7});
            this.pageHeaderSection1.Name = "pageHeaderSection1";
            //
            // pictureBox1
            //
            this.pictureBox1.Docking = Telerik.Reporting.DockingStyle.Top;
            this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(0D));
            this.pictureBox1.Name = "pictureBox1";
            this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(19D), Telerik.Reporting.Drawing.Unit.Cm(3.2000997066497803D));
            this.pictureBox1.Sizing = Telerik.Reporting.Drawing.ImageSizeMode.AutoSize;
            this.pictureBox1.Style.BackgroundImage.ImageData = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Style.BackgroundImage.ImageData")));
            this.pictureBox1.Style.BackgroundImage.MimeType = "image/png";
            this.pictureBox1.Style.BackgroundImage.Repeat = Telerik.Reporting.Drawing.BackgroundRepeat.NoRepeat;
            //
            // textBox7
            //
            this.textBox7.Docking = Telerik.Reporting.DockingStyle.Top;
            this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(3.2000997066497803D));
            this.textBox7.Name = "textBox7";
            this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(19D), Telerik.Reporting.Drawing.Unit.Cm(0.800000011920929D));
            this.textBox7.Style.Font.Bold = true;
            this.textBox7.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(18D);
            this.textBox7.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox7.Value = "Completion per User";
            //
            // detail
            //
            this.detail.Height = Telerik.Reporting.Drawing.Unit.Cm(8.3999996185302734D);
            this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.chart1});
            this.detail.Name = "detail";
            //
            // chart1
            //
            this.chart1.BitmapResolution = 96F;
            this.chart1.ChartTitle.TextBlock.Text = "Progress By Industry Association or Regulatory Body";
            this.chart1.DataSource = this.odsReportGraph;
            this.chart1.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;
            this.chart1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.00010012308484874666D), Telerik.Reporting.Drawing.Unit.Cm(0.00010012308484874666D));
            this.chart1.Name = "chart1";
            this.chart1.PlotArea.XAxis.AutoScale = false;
            this.chart1.PlotArea.XAxis.AxisLabel.Appearance.RotationAngle = 270F;
            this.chart1.PlotArea.XAxis.DataLabelsColumn = "OrgTitle";
            chartAxisItem1.Value = new decimal(new int[] {
            1,
            0,
            0,
            0});
            chartAxisItem2.Value = new decimal(new int[] {
            2,
            0,
            0,
            0});
            chartAxisItem3.Value = new decimal(new int[] {
            3,
            0,
            0,
            0});
            chartAxisItem4.Value = new decimal(new int[] {
            4,
            0,
            0,
            0});
            chartAxisItem5.Value = new decimal(new int[] {
            5,
            0,
            0,
            0});
            chartAxisItem6.Value = new decimal(new int[] {
            6,
            0,
            0,
            0});
            chartAxisItem7.Value = new decimal(new int[] {
            7,
            0,
            0,
            0});
            this.chart1.PlotArea.XAxis.Items.AddRange(new Telerik.Reporting.Charting.ChartAxisItem[] {
            chartAxisItem1,
            chartAxisItem2,
            chartAxisItem3,
            chartAxisItem4,
            chartAxisItem5,
            chartAxisItem6,
            chartAxisItem7});
            this.chart1.PlotArea.XAxis.MinValue = 1D;
            this.chart1.PlotArea.YAxis.AxisLabel.Appearance.RotationAngle = 0F;
            this.chart1.PlotArea.YAxis.AxisMode = Telerik.Reporting.Charting.ChartYAxisMode.Extended;
            this.chart1.PlotArea.YAxis.MaxValue = 100D;
            this.chart1.PlotArea.YAxis.Step = 10D;
            this.chart1.PlotArea.YAxis2.AxisLabel.Appearance.RotationAngle = 0F;
            corners1.BottomRight = Telerik.Reporting.Charting.Styles.CornerType.Round;
            corners1.TopRight = Telerik.Reporting.Charting.Styles.CornerType.Round;
            chartSeries1.Appearance.Corners = corners1;
            chartSeries1.Appearance.FillStyle.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(213)))), ((int)(((byte)(247)))), ((int)(((byte)(255)))));
            chartSeries1.DataXColumn = "OrgLimit";
            chartSeries1.DefaultLabelValue = "CPD Goal";
            chartSeries1.Name = "Series 1";
            corners2.BottomRight = Telerik.Reporting.Charting.Styles.CornerType.Round;
            corners2.TopRight = Telerik.Reporting.Charting.Styles.CornerType.Round;
            chartSeries2.Appearance.Corners = corners2;
            chartSeries2.Appearance.FillStyle.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(218)))), ((int)(((byte)(254)))), ((int)(((byte)(122)))));
            chartSeries2.DataXColumn = "MyScore";
            chartSeries2.DefaultLabelValue = "My Score";
            chartSeries2.Name = "Series 2";
            this.chart1.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {
            chartSeries1,
            chartSeries2});
            this.chart1.SeriesOrientation = Telerik.Reporting.Charting.ChartSeriesOrientation.Horizontal;
            this.chart1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(19D), Telerik.Reporting.Drawing.Unit.Cm(7.5D));
            this.chart1.NeedDataSource += new System.EventHandler(this.chart1_NeedDataSource);
            //
            // odsReportGraph
            //
            this.odsReportGraph.DataMember = "ReportSelectUserDataByOrganization";
            this.odsReportGraph.DataSource = typeof(CPDOne.Warehouse.ReportFactory);
            this.odsReportGraph.Name = "odsReportGraph";
            this.odsReportGraph.Parameters.AddRange(new Telerik.Reporting.ObjectDataSourceParameter[] {
            new Telerik.Reporting.ObjectDataSourceParameter("UserId", typeof(long), "=Parameters.UserId.Value"),
            new Telerik.Reporting.ObjectDataSourceParameter("needId", typeof(bool), "=Parameters.needId.Value")});
            //
            // pageFooterSection1
            //
            this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Cm(3D);
            this.pageFooterSection1.Name = "pageFooterSection1";
            //
            // ReportUserCompletion
            //
            this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.pageHeaderSection1,
            this.detail,
            this.pageFooterSection1});
            this.Name = "ReportUserCompletion";
            this.PageSettings.Landscape = false;
            this.PageSettings.Margins.Bottom = Telerik.Reporting.Drawing.Unit.Cm(1D);
            this.PageSettings.Margins.Left = Telerik.Reporting.Drawing.Unit.Cm(1D);
            this.PageSettings.Margins.Right = Telerik.Reporting.Drawing.Unit.Cm(1D);
            this.PageSettings.Margins.Top = Telerik.Reporting.Drawing.Unit.Mm(1D);
            this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
            reportParameter1.Name = "UserId";
            reportParameter1.Text = "UserId";
            reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer;
            reportParameter2.Name = "needId";
            reportParameter2.Text = "needId";
            reportParameter2.Type = Telerik.Reporting.ReportParameterType.Boolean;
            this.ReportParameters.Add(reportParameter1);
            this.ReportParameters.Add(reportParameter2);
            this.Style.BackgroundColor = System.Drawing.Color.White;
            this.Width = Telerik.Reporting.Drawing.Unit.Cm(19D);
            this.NeedDataSource += new System.EventHandler(this.ReportUserCompletion_NeedDataSource);
            ((System.ComponentModel.ISupportInitialize)(this)).EndInit();

        }
        #endregion

        private Telerik.Reporting.PageHeaderSection pageHeaderSection1;
        private Telerik.Reporting.DetailSection detail;
        private Telerik.Reporting.PageFooterSection pageFooterSection1;
        private Telerik.Reporting.PictureBox pictureBox1;
        private Telerik.Reporting.TextBox textBox7;
        private Telerik.Reporting.Chart chart1;
        private Telerik.Reporting.ObjectDataSource odsReportGraph;
    }


REPORT.CS===============================================================
    using System;
    using System.ComponentModel;
    using System.Drawing;
    using System.Windows.Forms;
    using Telerik.Reporting;
    using Telerik.Reporting.Drawing;

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

            //
            // TODO: Add any constructor code after InitializeComponent call
            //
        }

        private void chart1_NeedDataSource(object sender, EventArgs e)
        {
            //odsReportGraph.Parameters["needId"].Value = this.ReportParameters["needId"].Value;
            //odsReportGraph.Parameters["UserId"].Value = this.ReportParameters["UserId"].Value;
            //chart1.DataSource = odsReportGraph;

            ReportFactory _ReportFactory = new ReportFactory();
            chart1.DataSource = _ReportFactory.ReportSelectUserDataByOrganization(Int64.Parse(this.ReportParameters["UserId"].Value.ToString()));

        }

        private void ReportUserCompletion_NeedDataSource(object sender, EventArgs e)
        {

            ReportFactory _ReportFactory = new ReportFactory();
            chart1.DataSource = _ReportFactory.ReportSelectUserDataByOrganization(Int64.Parse(this.ReportParameters["UserId"].Value.ToString()));
            //this.DataSource = _ReportFactory.ReportSelectUserDataByOrganization(Int64.Parse(this.ReportParameters["UserId"].Value.ToString()));
        }
    }

MY_WEB_APP.ASPX ===============================================================
here is where i load the variables and pass onto the report and subsequently to the datasource inside the report that loads the graph:
// this is my dataobject
       CPDOne.Warehouse.ReportUserCompletion _ReportUSerCompletion = new ReportUserCompletion();
        _ReportUSerCompletion.ReportParameters["UserId"].Value = UserId;
        _ReportUSerCompletion.ReportParameters["needId"].Value = true;
        ReportViewer1.Report = _ReportUSerCompletion;


Please help me, what am i doing wrong, i need to bind data to this chart inside the report. thanks in advance.
Elian
Telerik team
 answered on 08 Jun 2012
1 answer
325 views
We have a report that uses a crosstab (created by the wizard). There is one row group and three column groups, with totals at each level. The three column groups are region, location and gender. See the attached screenshot.

The user has asked if we can also add row total columns by location and gender, ie a total of the second and third grouping, to appear at the right before the grand total.  So there would be a set of columns for totals by location and gender for all regions, along with subtotals by location (again for all regions).

Is this possible, and if so can anyone point me in the right direction as to how to do it?

Hadib Ahmabi
Top achievements
Rank 1
 answered on 08 Jun 2012
1 answer
168 views
Hi ,
i am using a telerik reporting within a table to show several details from a database table . haw can i using "Conditional Formatting" to make different a row when a fields value is equal to MyValue  .

thank you . 
Hadib Ahmabi
Top achievements
Rank 1
 answered on 08 Jun 2012
4 answers
155 views
Hello,

For some reason, the expressions window is no longer showing to me.  It actually appears that it may be hidden or visible behind something because I can't focus or do anything in Visual Studio.  So it looks like Visual Studio is locked up, but it is not because it's pegging out the processor, but because it's waiting for the expressions window to be closed.  But I can't see this window??????  Any ideas?

Thanks.
Steve
Telerik team
 answered on 08 Jun 2012
1 answer
517 views
Can I install Reporting on VS 2012 RC?  I currently have it installed for VS 2010.  When I run Telerik_Reporting_Q1_2012_v6_0_12_215_Dev.msi I don't get a VS 2012 (or VS 11 Beta) option.

The VS Gallery page indicates that 2012 RC is supported.  http://visualstudiogallery.msdn.microsoft.com/479B9219-1B37-461D-B85B-2AA9BAD5BCEB?SRC=Featured

Thanks
Steve
Telerik team
 answered on 08 Jun 2012
3 answers
320 views
Hi Support,
Could you please clear my doubt whether it is possible to generate a report at run time using a dataset that was created manually using c#. I may not design the report, rather i will keep it as a blank one and then at the run time...I will creating a data set using certain business logic on various tables of my Sql server database. Using that dataset is there any possibility to load it on a report at run time itself?
I need various graphs to be generated based on the data i acquire, will it be part of telerik reporting tool or should i have to buy a new telerik tool for it seperately? How far the graphs are integrated in telerik? could you give me clear information of graphs that i can generate using telerik?
Thanks,
Ramakrishna
Steve
Telerik team
 answered on 08 Jun 2012
1 answer
129 views
I am completely new to Silverlight and was wondering if I can integrate this easily into my standard .NET WebForms Application? 

In my project I am currently running the Telerik AJAX RadChart which is great, but the Silverlight version allowed for Zooming/Scroll and Tooltips enabled simultaneously, which the AJAX version did not.

Essentially I would like to have this Chart component be in Silverlight, but simply integrated into my existing .NET page (Similar to how you would embed a Flash object for use in your existing functionality)

Is this possible without a huge headache?  I am hoping to quickly translate the functionality of my existing AJAX RadChart into the Silverlight counterpart.

Thanks in advance!
Petar Kirov
Telerik team
 answered on 07 Jun 2012
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?