Pie chart not displaying label connector line

10 posts, 0 answers
  1. J
    J avatar
    18 posts
    Member since:
    Sep 2015

    Posted 24 Oct Link to this post

    Hello,

    I am using Telerik Reporting with WPF Windows Application to show a Pie Chart like the one in the image I have attached. I am not able to get the DataPointLabelConnector, I mean the line that connects the label with its part of the pie chart.

     

    These are the properties I set for the Serie:

    • DataPointLabelAlignment: OutsideColumn.
    • DataPointLabelOffset: 30px.
    • DataPointLabelConnectorStyle has its Visible property set to true.

     

    Do you know what is happening? 

     

    Many thanks.

  2. Ivan Hristov
    Admin
    Ivan Hristov avatar
    123 posts

    Posted 25 Oct Link to this post

    Hello,

    Please check the value of DataPointLabelConnectorStyle.LineColor property if is set to White or Transparent. It determines the color that will be used to draw the connector line. You can reset the property, which will use the default Black color. You can also check the DataPointLabelConnectorConditionalFormatting property if it has some rules defined that might affect the line color.

    In case you still have troubles, please send us the report definition so we can test it on our side.

    Regards,
    Ivan Hristov
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. J
    J avatar
    18 posts
    Member since:
    Sep 2015

    Posted 25 Oct in reply to Ivan Hristov Link to this post

    Thanks for your answer.

    DataPointLabelConnectorStyle.LineColor property is set to Black.
    The DataPointLabelConnectorConditionalFormatting property has not any rule defined. 

    I have copied the code below from my Designer.cs file (is that what you mean with the report definition?):

    //
    // barSeries6
    //
    this.barSeries6.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked100;
    graphGroup16.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Sector"));
    graphGroup16.Name = "sectorGroup2";
    graphGroup16.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
    this.barSeries6.CategoryGroup = graphGroup16;
    this.barSeries6.CoordinateSystem = this.polarCoordinateSystem6;
    this.barSeries6.DataPointLabel = "= Format(\"{0} {1:P1}\", Fields.Sector, CDbl(Sum(Fields.Total) / CDbl(Exec(\'graph2\'" +
    ", Sum(Fields.Total))) ))";
    this.barSeries6.DataPointLabelAlignment = Telerik.Reporting.BarDataPointLabelAlignment.OutsideColumn;
    this.barSeries6.DataPointLabelFormat = "{0:P}";
    this.barSeries6.DataPointLabelOffset = Telerik.Reporting.Drawing.Unit.Pixel(30D);
    this.barSeries6.DataPointLabelStyle.Font.Bold = true;
    this.barSeries6.DataPointLabelStyle.Font.Size = Telerik.Reporting.Drawing.Unit.Point(5D);
    this.barSeries6.DataPointLabelStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Point(0D);
    this.barSeries6.DataPointLabelStyle.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
    this.barSeries6.DataPointLabelStyle.Visible = true;
    this.barSeries6.DataPointStyle.LineColor = System.Drawing.Color.White;
    this.barSeries6.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0.0099999997764825821D);
    this.barSeries6.DataPointStyle.Visible = true;
    this.barSeries6.LegendItem.Value = "= Fields.Categoria + \' \' +  Format(\'{0:p1}\',CDbl(Exec(\'categoriaGroup2\', Sum(Fiel" +
    "ds.Total))) / CDbl(Exec(\'graph2\', Sum(Fields.Total))))";
    this.barSeries6.Name = "barSeries6";
    graphGroup17.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Categoria"));
    graphGroup17.Name = "categoriaGroup2";
    graphGroup17.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
    this.barSeries6.SeriesGroup = graphGroup17;
    this.barSeries6.ToolTip.Text = "= Format(\'{0:P}\', Sum(Fields.Total) / CDbl(Exec(\'graph2\', Sum(Fields.Total))))";
    this.barSeries6.ToolTip.Title = "= Fields.Categoria";
    this.barSeries6.Y = "= Sum(Fields.Total)";
  4. Ivan Hristov
    Admin
    Ivan Hristov avatar
    123 posts

    Posted 25 Oct Link to this post

    Hello,

    I examined the code you pasted (yes, that's a part of the report definition) and it actually shouldn't produce any label connectors, because it has a category group defined.
    Having set a category grouping would produce more than one "layer" on your pie chart, making the outside-column labels unreadable. That's why the OutsideColumn property is only respected when the chart's CategoryGroup.Groupings is empty (No grouping). When I made that change to your code, the pie chart was displayed with visible black label connectors, as you can see in the attached example.

    If you're still experiencing problems after applying the changes suggested above, please send us the whole report definition along with some sample data so we can test it on our side.

    Regards,
    Ivan Hristov
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  5. J
    J avatar
    18 posts
    Member since:
    Sep 2015

    Posted 26 Oct in reply to Ivan Hristov Link to this post

    Hello Ivan,

    I have tried what you suggest but I can not get it working. You can download an example of datasource for the sqlDataSourceRvGroupbySector from this link. In the report definition I have more than one pie chart but the one we are working on is the "graph2". You can see below my report definition:

    namespace mynamespace
    {
        partial class ReportCompCartRV
        {
            #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(ReportCompCartRV));
                Telerik.Reporting.GraphGroup graphGroup1 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup4 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphTitle graphTitle1 = new Telerik.Reporting.GraphTitle();
                Telerik.Reporting.NumericalScale numericalScale1 = new Telerik.Reporting.NumericalScale();
                Telerik.Reporting.CategoryScale categoryScale1 = new Telerik.Reporting.CategoryScale();
                Telerik.Reporting.GraphGroup graphGroup2 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.Drawing.FormattingRule formattingRule1 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule2 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule3 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule4 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule5 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule6 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.GraphGroup graphGroup3 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup5 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup6 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup8 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphTitle graphTitle2 = new Telerik.Reporting.GraphTitle();
                Telerik.Reporting.NumericalScale numericalScale2 = new Telerik.Reporting.NumericalScale();
                Telerik.Reporting.CategoryScale categoryScale2 = new Telerik.Reporting.CategoryScale();
                Telerik.Reporting.Drawing.FormattingRule formattingRule7 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule8 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule9 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule10 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule11 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule12 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.GraphGroup graphGroup7 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup9 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphTitle graphTitle3 = new Telerik.Reporting.GraphTitle();
                Telerik.Reporting.NumericalScale numericalScale3 = new Telerik.Reporting.NumericalScale();
                Telerik.Reporting.CategoryScale categoryScale3 = new Telerik.Reporting.CategoryScale();
                Telerik.Reporting.GraphGroup graphGroup10 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup11 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphTitle graphTitle4 = new Telerik.Reporting.GraphTitle();
                Telerik.Reporting.NumericalScale numericalScale4 = new Telerik.Reporting.NumericalScale();
                Telerik.Reporting.CategoryScale categoryScale4 = new Telerik.Reporting.CategoryScale();
                Telerik.Reporting.GraphGroup graphGroup12 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup13 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphTitle graphTitle5 = new Telerik.Reporting.GraphTitle();
                Telerik.Reporting.NumericalScale numericalScale5 = new Telerik.Reporting.NumericalScale();
                Telerik.Reporting.CategoryScale categoryScale5 = new Telerik.Reporting.CategoryScale();
                Telerik.Reporting.GraphGroup graphGroup14 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup15 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup18 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphTitle graphTitle6 = new Telerik.Reporting.GraphTitle();
                Telerik.Reporting.CategoryScale categoryScale6 = new Telerik.Reporting.CategoryScale();
                Telerik.Reporting.NumericalScale numericalScale6 = new Telerik.Reporting.NumericalScale();
                Telerik.Reporting.GraphGroup graphGroup16 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup17 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
                Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
                Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
                this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
                this.LogoPortada = new Telerik.Reporting.PictureBox();
                this.TituloReport = new Telerik.Reporting.TextBox();
                this.detail = new Telerik.Reporting.DetailSection();
                this.graph1 = new Telerik.Reporting.Graph();
                this.polarCoordinateSystem4 = new Telerik.Reporting.PolarCoordinateSystem();
                this.graphAxis9 = new Telerik.Reporting.GraphAxis();
                this.graphAxis10 = new Telerik.Reporting.GraphAxis();
                this.sqlDataSourceRvGroupbySector = new Telerik.Reporting.SqlDataSource();
                this.barSeries4 = new Telerik.Reporting.BarSeries();
                this.textBoxISIN = new Telerik.Reporting.TextBox();
                this.RvGroupbySector2 = new Telerik.Reporting.Graph();
                this.polarCoordinateSystem5 = new Telerik.Reporting.PolarCoordinateSystem();
                this.graphAxis11 = new Telerik.Reporting.GraphAxis();
                this.graphAxis12 = new Telerik.Reporting.GraphAxis();
                this.barSeries5 = new Telerik.Reporting.BarSeries();
                this.RvGroupbyDivisa = new Telerik.Reporting.Graph();
                this.polarCoordinateSystem1 = new Telerik.Reporting.PolarCoordinateSystem();
                this.graphAxis1 = new Telerik.Reporting.GraphAxis();
                this.graphAxis2 = new Telerik.Reporting.GraphAxis();
                this.sqlDataSourceRvGroupbyDivisa = new Telerik.Reporting.SqlDataSource();
                this.barSeries1 = new Telerik.Reporting.BarSeries();
                this.RvGroupbyPais = new Telerik.Reporting.Graph();
                this.polarCoordinateSystem2 = new Telerik.Reporting.PolarCoordinateSystem();
                this.graphAxis3 = new Telerik.Reporting.GraphAxis();
                this.graphAxis4 = new Telerik.Reporting.GraphAxis();
                this.sqlDataSourceRvGroupbyPais = new Telerik.Reporting.SqlDataSource();
                this.barSeries2 = new Telerik.Reporting.BarSeries();
                this.RvGroupbyEmpresa = new Telerik.Reporting.Graph();
                this.polarCoordinateSystem3 = new Telerik.Reporting.PolarCoordinateSystem();
                this.graphAxis7 = new Telerik.Reporting.GraphAxis();
                this.graphAxis8 = new Telerik.Reporting.GraphAxis();
                this.sqlDataSourceRvGroupbyEmpresa = new Telerik.Reporting.SqlDataSource();
                this.barSeries3 = new Telerik.Reporting.BarSeries();
                this.graph2 = new Telerik.Reporting.Graph();
                this.polarCoordinateSystem6 = new Telerik.Reporting.PolarCoordinateSystem();
                this.graphAxis14 = new Telerik.Reporting.GraphAxis();
                this.graphAxis13 = new Telerik.Reporting.GraphAxis();
                this.barSeries6 = new Telerik.Reporting.BarSeries();
                this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
                this.TextNumPaginaPie = new Telerik.Reporting.TextBox();
                this.graphAxis5 = new Telerik.Reporting.GraphAxis();
                this.graphAxis6 = new Telerik.Reporting.GraphAxis();
                this.reportHeaderSection1 = new Telerik.Reporting.ReportHeaderSection();
                ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
                //
                // pageHeaderSection1
                //
                this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Cm(1D);
                this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.LogoPortada});
                this.pageHeaderSection1.Name = "pageHeaderSection1";
                //
                // LogoPortada
                //
                this.LogoPortada.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(0.00010004233627114445D));
                this.LogoPortada.MimeType = "image/jpeg";
                this.LogoPortada.Name = "LogoPortada";
                this.LogoPortada.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(4.8000001907348633D), Telerik.Reporting.Drawing.Unit.Cm(1D));
                this.LogoPortada.Value = ((object)(resources.GetObject("LogoPortada.Value")));
                //
                // TituloReport
                //
                this.TituloReport.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.19999977946281433D), Telerik.Reporting.Drawing.Unit.Cm(0D));
                this.TituloReport.Name = "TituloReport";
                this.TituloReport.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(19.5D), Telerik.Reporting.Drawing.Unit.Cm(1.2000000476837158D));
                this.TituloReport.Style.Font.Bold = true;
                this.TituloReport.Style.Font.Name = "Tahoma";
                this.TituloReport.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(14D);
                this.TituloReport.Style.Font.Strikeout = false;
                this.TituloReport.Style.Font.Underline = false;
                this.TituloReport.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.TituloReport.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
                this.TituloReport.Value = "COMPOSICIÓN CARTERA RENTA VARIABLE";
                //
                // detail
                //
                this.detail.Height = Telerik.Reporting.Drawing.Unit.Cm(24.75990104675293D);
                this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.graph1,
                this.textBoxISIN,
                this.RvGroupbySector2,
                this.RvGroupbyDivisa,
                this.RvGroupbyPais,
                this.RvGroupbyEmpresa,
                this.graph2});
                this.detail.Name = "detail";
                //
                // graph1
                //
                graphGroup1.Name = "sectorGroup";
                graphGroup1.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.sector", Telerik.Reporting.SortDirection.Asc));
                graphGroup1.Visible = false;
                this.graph1.CategoryGroups.Add(graphGroup1);
                this.graph1.CoordinateSystems.Add(this.polarCoordinateSystem4);
                this.graph1.DataSource = this.sqlDataSourceRvGroupbySector;
                this.graph1.Legend.Position = Telerik.Reporting.GraphItemPosition.BottomCenter;
                this.graph1.Legend.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
                this.graph1.Legend.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.graph1.Legend.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(6D);
                this.graph1.Legend.Style.LineColor = System.Drawing.Color.Black;
                this.graph1.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Point(1D);
                this.graph1.Legend.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph1.Legend.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph1.Legend.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph1.Legend.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph1.Legend.Width = Telerik.Reporting.Drawing.Unit.Cm(9D);
                this.graph1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.20000001788139343D), Telerik.Reporting.Drawing.Unit.Cm(10.799999237060547D));
                this.graph1.Name = "graph1";
                this.graph1.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
                this.graph1.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.graph1.Series.Add(this.barSeries4);
                graphGroup4.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Categoria"));
                graphGroup4.Name = "categoriaGroup";
                graphGroup4.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.graph1.SeriesGroups.Add(graphGroup4);
                this.graph1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(9.70000171661377D), Telerik.Reporting.Drawing.Unit.Cm(6.3000016212463379D));
                this.graph1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                graphTitle1.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
                graphTitle1.Style.LineColor = System.Drawing.Color.LightGray;
                graphTitle1.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle1.Style.Visible = false;
                graphTitle1.Text = "graph1";
                this.graph1.Titles.Add(graphTitle1);
                //
                // polarCoordinateSystem4
                //
                this.polarCoordinateSystem4.AngularAxis = this.graphAxis9;
                this.polarCoordinateSystem4.Name = "polarCoordinateSystem4";
                this.polarCoordinateSystem4.RadialAxis = this.graphAxis10;
                //
                // graphAxis9
                //
                this.graphAxis9.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis9.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis9.MajorGridLineStyle.Visible = false;
                this.graphAxis9.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis9.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis9.MinorGridLineStyle.Visible = false;
                this.graphAxis9.Name = "graphAxis9";
                this.graphAxis9.Scale = numericalScale1;
                this.graphAxis9.Style.Visible = false;
                //
                // graphAxis10
                //
                this.graphAxis10.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis10.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis10.MajorGridLineStyle.Visible = false;
                this.graphAxis10.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis10.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis10.MinorGridLineStyle.Visible = false;
                this.graphAxis10.Name = "graphAxis10";
                categoryScale1.PositionMode = Telerik.Reporting.AxisPositionMode.OnTicks;
                categoryScale1.SpacingSlotCount = 0D;
                this.graphAxis10.Scale = categoryScale1;
                this.graphAxis10.Style.Visible = false;
                //
                // sqlDataSourceRvGroupbySector
                //
                this.sqlDataSourceRvGroupbySector.ConnectionString = "Reports_IICs.Properties.Settings.ReportsIICS_Reports";
                this.sqlDataSourceRvGroupbySector.Name = "sqlDataSourceRvGroupbySector";
                this.sqlDataSourceRvGroupbySector.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
                new Telerik.Reporting.SqlDataSourceParameter("@Isin", System.Data.DbType.String, "= Parameters.Isin.Value"),
                new Telerik.Reporting.SqlDataSourceParameter("@CodigoIC", System.Data.DbType.String, "= Parameters.CodigoIC.Value")});
                this.sqlDataSourceRvGroupbySector.SelectCommand = "dbo.RvGroupbySector";
                this.sqlDataSourceRvGroupbySector.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
                //
                // barSeries4
                //
                this.barSeries4.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked100;
                graphGroup2.Name = "sectorGroup";
                graphGroup2.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.sector", Telerik.Reporting.SortDirection.Asc));
                graphGroup2.Visible = false;
                this.barSeries4.CategoryGroup = graphGroup2;
                this.barSeries4.CoordinateSystem = this.polarCoordinateSystem4;
                this.barSeries4.DataPointLabel = "= Sum(Fields.Total) / CDbl(Exec(\'graph1\', Sum(Fields.Total)))";
                this.barSeries4.DataPointLabelAlignment = Telerik.Reporting.BarDataPointLabelAlignment.OutsideColumn;
                formattingRule1.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Like, "CÍCLICO"));
                formattingRule1.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(41)))), ((int)(((byte)(136)))), ((int)(((byte)(214)))));
                formattingRule2.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Like, "DEFENSIVO"));
                formattingRule2.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(56)))), ((int)(((byte)(199)))), ((int)(((byte)(74)))));
                formattingRule3.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Equal, "\'SIN CLASIFICACIÓN\'"));
                formattingRule3.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(80)))), ((int)(((byte)(77)))));
                this.barSeries4.DataPointLabelConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
                formattingRule1,
                formattingRule2,
                formattingRule3});
                this.barSeries4.DataPointLabelConnectorStyle.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries4.DataPointLabelConnectorStyle.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries4.DataPointLabelFormat = "{0:P1}";
                this.barSeries4.DataPointLabelOffset = Telerik.Reporting.Drawing.Unit.Mm(5D);
                this.barSeries4.DataPointLabelStyle.Visible = true;
                this.barSeries4.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.barSeries4.DataPointStyle.Visible = true;
                this.barSeries4.LegendItem.Format = "{0:P1}";
                formattingRule4.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Equal, "=\'CÍCLICO\'"));
                formattingRule4.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(41)))), ((int)(((byte)(136)))), ((int)(((byte)(214)))));
                formattingRule5.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Equal, "=\'DEFENSIVO\'"));
                formattingRule5.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(56)))), ((int)(((byte)(199)))), ((int)(((byte)(74)))));
                formattingRule6.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Equal, "=\'GENÉRICO\'"));
                formattingRule6.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(80)))), ((int)(((byte)(77)))));
                this.barSeries4.LegendItem.MarkConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
                formattingRule4,
                formattingRule5,
                formattingRule6});
                this.barSeries4.LegendItem.Value = "= Fields.Categoria + \' \' +  Format(\'{0:p1}\',CDbl(Exec(\'categoriaGroup\', Sum(Field" +
        "s.Total))) / CDbl(Exec(\'graph1\', Sum(Fields.Total))))";
                this.barSeries4.Name = "barSeries4";
                graphGroup3.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Categoria"));
                graphGroup3.Name = "categoriaGroup";
                graphGroup3.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.barSeries4.SeriesGroup = graphGroup3;
                this.barSeries4.X = "= Sum(Fields.Total)";
                //
                // textBoxISIN
                //
                this.textBoxISIN.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.20000012218952179D), Telerik.Reporting.Drawing.Unit.Cm(0.00020024616969749332D));
                this.textBoxISIN.Name = "textBoxISIN";
                this.textBoxISIN.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(19.499998092651367D), Telerik.Reporting.Drawing.Unit.Cm(0.7999998927116394D));
                this.textBoxISIN.Style.Font.Bold = true;
                this.textBoxISIN.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
                this.textBoxISIN.Style.Font.Underline = false;
                this.textBoxISIN.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.textBoxISIN.Value = "";
                //
                // RvGroupbySector2
                //
                graphGroup5.Name = "categoryGroup2";
                graphGroup5.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Sector", Telerik.Reporting.SortDirection.Asc));
                graphGroup6.Name = "sectorGroup";
                this.RvGroupbySector2.CategoryGroups.Add(graphGroup5);
                this.RvGroupbySector2.CategoryGroups.Add(graphGroup6);
                this.RvGroupbySector2.CoordinateSystems.Add(this.polarCoordinateSystem5);
                this.RvGroupbySector2.DataSource = this.sqlDataSourceRvGroupbySector;
                this.RvGroupbySector2.Legend.IsInsidePlotArea = false;
                this.RvGroupbySector2.Legend.Left = Telerik.Reporting.Drawing.Unit.Empty;
                this.RvGroupbySector2.Legend.Position = Telerik.Reporting.GraphItemPosition.BottomCenter;
                this.RvGroupbySector2.Legend.Style.LineColor = System.Drawing.Color.LightGray;
                this.RvGroupbySector2.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbySector2.Legend.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
                this.RvGroupbySector2.Legend.Top = Telerik.Reporting.Drawing.Unit.Empty;
                this.RvGroupbySector2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.19999976456165314D), Telerik.Reporting.Drawing.Unit.Cm(9.1999998092651367D));
                this.RvGroupbySector2.Name = "RvGroupbySector2";
                this.RvGroupbySector2.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
                this.RvGroupbySector2.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbySector2.Series.Add(this.barSeries5);
                graphGroup8.ChildGroups.Add(graphGroup7);
                graphGroup8.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Categoria"));
                graphGroup8.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Sector"));
                graphGroup8.Label = "= Fields.Sector";
                graphGroup8.Name = "categoriaGroup1";
                graphGroup8.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.RvGroupbySector2.SeriesGroups.Add(graphGroup8);
                this.RvGroupbySector2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(9.6999998092651367D), Telerik.Reporting.Drawing.Unit.Cm(6.9999995231628418D));
                this.RvGroupbySector2.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
                graphTitle2.Left = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle2.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
                graphTitle2.Style.Font.Bold = true;
                graphTitle2.Style.Font.Italic = true;
                graphTitle2.Style.Font.Underline = true;
                graphTitle2.Style.LineColor = System.Drawing.Color.LightGray;
                graphTitle2.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle2.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Cm(0.30000001192092896D);
                graphTitle2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                graphTitle2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
                graphTitle2.Text = "Sectorial";
                graphTitle2.Top = Telerik.Reporting.Drawing.Unit.Empty;
                this.RvGroupbySector2.Titles.Add(graphTitle2);
                //
                // polarCoordinateSystem5
                //
                this.polarCoordinateSystem5.AngularAxis = this.graphAxis11;
                this.polarCoordinateSystem5.Name = "polarCoordinateSystem5";
                this.polarCoordinateSystem5.RadialAxis = this.graphAxis12;
                //
                // graphAxis11
                //
                this.graphAxis11.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis11.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis11.MajorGridLineStyle.Visible = false;
                this.graphAxis11.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis11.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis11.MinorGridLineStyle.Visible = false;
                this.graphAxis11.Name = "graphAxis11";
                this.graphAxis11.Scale = numericalScale2;
                this.graphAxis11.Style.Visible = false;
                //
                // graphAxis12
                //
                this.graphAxis12.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis12.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis12.MajorGridLineStyle.Visible = false;
                this.graphAxis12.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis12.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis12.MinorGridLineStyle.Visible = false;
                this.graphAxis12.Name = "graphAxis12";
                categoryScale2.PositionMode = Telerik.Reporting.AxisPositionMode.OnTicks;
                categoryScale2.SpacingSlotCount = 0D;
                this.graphAxis12.Scale = categoryScale2;
                this.graphAxis12.Style.Visible = false;
                //
                // barSeries5
                //
                this.barSeries5.ArrangeByAxis = this.graphAxis12;
                this.barSeries5.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked100;
                this.barSeries5.CategoryGroup = graphGroup5;
                this.barSeries5.CoordinateSystem = this.polarCoordinateSystem5;
                formattingRule7.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Like, "=\'CÍCLICO\'"));
                formattingRule7.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(41)))), ((int)(((byte)(136)))), ((int)(((byte)(214)))));
                formattingRule8.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Like, "=\'DEFENSIVO\'"));
                formattingRule8.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(56)))), ((int)(((byte)(199)))), ((int)(((byte)(74)))));
                formattingRule9.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Equal, "=\'SIN CLASIFICACIÓN\'"));
                formattingRule9.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(80)))), ((int)(((byte)(77)))));
                this.barSeries5.DataPointConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
                formattingRule7,
                formattingRule8,
                formattingRule9});
                this.barSeries5.DataPointLabel = "= Format(\"{0} {1:P1}\", Fields.Sector, CDbl(Sum(Fields.Total) / CDbl(Exec(\'RvGroup" +
        "bySector2\', Sum(Fields.Total)))) )";
                this.barSeries5.DataPointLabelAlignment = Telerik.Reporting.BarDataPointLabelAlignment.OutsideColumn;
                this.barSeries5.DataPointLabelConnectorStyle.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries5.DataPointLabelConnectorStyle.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries5.DataPointLabelFormat = "{0:P}";
                this.barSeries5.DataPointLabelOffset = Telerik.Reporting.Drawing.Unit.Mm(1.2999999523162842D);
                this.barSeries5.DataPointLabelStyle.Font.Bold = true;
                this.barSeries5.DataPointLabelStyle.Font.Size = Telerik.Reporting.Drawing.Unit.Point(5D);
                this.barSeries5.DataPointLabelStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Point(0D);
                this.barSeries5.DataPointLabelStyle.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Cm(0.60000002384185791D);
                this.barSeries5.DataPointLabelStyle.Padding.Left = Telerik.Reporting.Drawing.Unit.Cm(0.60000002384185791D);
                this.barSeries5.DataPointLabelStyle.Padding.Right = Telerik.Reporting.Drawing.Unit.Cm(0.60000002384185791D);
                this.barSeries5.DataPointLabelStyle.Padding.Top = Telerik.Reporting.Drawing.Unit.Cm(0.60000002384185791D);
                this.barSeries5.DataPointLabelStyle.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.barSeries5.DataPointLabelStyle.Visible = true;
                this.barSeries5.DataPointStyle.LineColor = System.Drawing.Color.White;
                this.barSeries5.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0.0099999997764825821D);
                this.barSeries5.DataPointStyle.Visible = true;
                formattingRule10.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Equal, "=\'CÍCLICO\'"));
                formattingRule10.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(41)))), ((int)(((byte)(136)))), ((int)(((byte)(214)))));
                formattingRule11.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Equal, "=\'DEFENSIVO\'"));
                formattingRule11.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(56)))), ((int)(((byte)(199)))), ((int)(((byte)(74)))));
                formattingRule12.Filters.Add(new Telerik.Reporting.Filter("= Fields.Categoria", Telerik.Reporting.FilterOperator.Equal, "=\'SIN CLASIFICACIÓN\'"));
                formattingRule12.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(80)))), ((int)(((byte)(77)))));
                this.barSeries5.LegendItem.MarkConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
                formattingRule10,
                formattingRule11,
                formattingRule12});
                this.barSeries5.LegendItem.Style.Visible = false;
                this.barSeries5.LegendItem.Value = "= Fields.Categoria + \' \' +  Format(\'{0:p2}\',CDbl(Exec(\'categoriaGroup1\', Sum(Fiel" +
        "ds.Total))) / CDbl(Exec(\'RvGroupbySector2\', Sum(Fields.Total))))\r\n\r\n\r\n";
                this.barSeries5.Name = "barSeries5";
                graphGroup7.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.sector"));
                graphGroup7.Name = "sectorGroup1";
                graphGroup7.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Total", Telerik.Reporting.SortDirection.Desc));
                this.barSeries5.SeriesGroup = graphGroup7;
                this.barSeries5.X = "= Sum(Fields.Total)";
                //
                // RvGroupbyDivisa
                //
                graphGroup9.Name = "categoryGroup";
                this.RvGroupbyDivisa.CategoryGroups.Add(graphGroup9);
                this.RvGroupbyDivisa.CoordinateSystems.Add(this.polarCoordinateSystem1);
                this.RvGroupbyDivisa.DataSource = this.sqlDataSourceRvGroupbyDivisa;
                this.RvGroupbyDivisa.Legend.Height = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbyDivisa.Legend.IsInsidePlotArea = false;
                this.RvGroupbyDivisa.Legend.Style.LineColor = System.Drawing.Color.LightGray;
                this.RvGroupbyDivisa.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbyDivisa.Legend.Style.Visible = false;
                this.RvGroupbyDivisa.Legend.Width = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbyDivisa.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.20000013709068298D), Telerik.Reporting.Drawing.Unit.Cm(1.5000001192092896D));
                this.RvGroupbyDivisa.Name = "RvGroupbyDivisa";
                this.RvGroupbyDivisa.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
                this.RvGroupbyDivisa.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbyDivisa.Series.Add(this.barSeries1);
                this.RvGroupbyDivisa.SeriesGroups.Add(graphGroup10);
                this.RvGroupbyDivisa.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(9.7000007629394531D), Telerik.Reporting.Drawing.Unit.Cm(7.0000004768371582D));
                this.RvGroupbyDivisa.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
                graphTitle3.Height = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle3.IsInsidePlotArea = false;
                graphTitle3.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
                graphTitle3.Style.Font.Bold = true;
                graphTitle3.Style.Font.Italic = true;
                graphTitle3.Style.Font.Underline = true;
                graphTitle3.Style.LineColor = System.Drawing.Color.LightGray;
                graphTitle3.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle3.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                graphTitle3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
                graphTitle3.Text = "Divisa";
                graphTitle3.Width = Telerik.Reporting.Drawing.Unit.Cm(1D);
                this.RvGroupbyDivisa.Titles.Add(graphTitle3);
                //
                // polarCoordinateSystem1
                //
                this.polarCoordinateSystem1.AngularAxis = this.graphAxis1;
                this.polarCoordinateSystem1.Name = "polarCoordinateSystem1";
                this.polarCoordinateSystem1.RadialAxis = this.graphAxis2;
                //
                // graphAxis1
                //
                this.graphAxis1.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis1.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis1.MajorGridLineStyle.Visible = false;
                this.graphAxis1.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis1.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis1.MinorGridLineStyle.Visible = false;
                this.graphAxis1.Name = "graphAxis1";
                this.graphAxis1.Scale = numericalScale3;
                this.graphAxis1.Style.Visible = false;
                //
                // graphAxis2
                //
                this.graphAxis2.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis2.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis2.MajorGridLineStyle.Visible = false;
                this.graphAxis2.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis2.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis2.MinorGridLineStyle.Visible = false;
                this.graphAxis2.Name = "graphAxis2";
                categoryScale3.PositionMode = Telerik.Reporting.AxisPositionMode.OnTicks;
                categoryScale3.SpacingSlotCount = 0D;
                this.graphAxis2.Scale = categoryScale3;
                this.graphAxis2.Style.Visible = false;
                //
                // sqlDataSourceRvGroupbyDivisa
                //
                this.sqlDataSourceRvGroupbyDivisa.ConnectionString = "Reports_IICs.Properties.Settings.ReportsIICS_Reports";
                this.sqlDataSourceRvGroupbyDivisa.Name = "sqlDataSourceRvGroupbyDivisa";
                this.sqlDataSourceRvGroupbyDivisa.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
                new Telerik.Reporting.SqlDataSourceParameter("@Isin", System.Data.DbType.String, "= Parameters.Isin.Value"),
                new Telerik.Reporting.SqlDataSourceParameter("@CodigoIC", System.Data.DbType.String, "= Parameters.CodigoIC.Value")});
                this.sqlDataSourceRvGroupbyDivisa.SelectCommand = "dbo.RvGroupbyDivisa";
                this.sqlDataSourceRvGroupbyDivisa.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
                //
                // barSeries1
                //
                this.barSeries1.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked100;
                this.barSeries1.CategoryGroup = graphGroup9;
                this.barSeries1.CoordinateSystem = this.polarCoordinateSystem1;
                this.barSeries1.DataPointLabel = "= Format(\"{0} {1:P1}\", Fields.Divisa, CDbl(Sum(Fields.Total) / CDbl(Exec(\'RvGroup" +
        "byDivisa\', Sum(Fields.Total)))) )";
                this.barSeries1.DataPointLabelAlignment = Telerik.Reporting.BarDataPointLabelAlignment.OutsideColumn;
                this.barSeries1.DataPointLabelConnectorStyle.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries1.DataPointLabelConnectorStyle.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries1.DataPointLabelFormat = "{0:P0}";
                this.barSeries1.DataPointLabelOffset = Telerik.Reporting.Drawing.Unit.Mm(5D);
                this.barSeries1.DataPointLabelStyle.Font.Bold = true;
                this.barSeries1.DataPointLabelStyle.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
                this.barSeries1.DataPointLabelStyle.Visible = true;
                this.barSeries1.DataPointStyle.LineColor = System.Drawing.Color.White;
                this.barSeries1.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0.05000000074505806D);
                this.barSeries1.DataPointStyle.Visible = true;
                this.barSeries1.LegendItem.Value = "= Fields.Divisa";
                this.barSeries1.Name = "barSeries1";
                graphGroup10.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Divisa"));
                graphGroup10.Name = "divisaGroup";
                graphGroup10.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Total", Telerik.Reporting.SortDirection.Desc));
                this.barSeries1.SeriesGroup = graphGroup10;
                this.barSeries1.X = "= Sum(Fields.Total)";
                //
                // RvGroupbyPais
                //
                graphGroup11.Name = "categoryGroup1";
                this.RvGroupbyPais.CategoryGroups.Add(graphGroup11);
                this.RvGroupbyPais.CoordinateSystems.Add(this.polarCoordinateSystem2);
                this.RvGroupbyPais.DataSource = this.sqlDataSourceRvGroupbyPais;
                this.RvGroupbyPais.Legend.Style.LineColor = System.Drawing.Color.LightGray;
                this.RvGroupbyPais.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbyPais.Legend.Style.Visible = false;
                this.RvGroupbyPais.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(9.9999990463256836D), Telerik.Reporting.Drawing.Unit.Cm(1.5000001192092896D));
                this.RvGroupbyPais.Name = "RvGroupbyPais";
                this.RvGroupbyPais.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
                this.RvGroupbyPais.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbyPais.Series.Add(this.barSeries2);
                this.RvGroupbyPais.SeriesGroups.Add(graphGroup12);
                this.RvGroupbyPais.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(9.6999998092651367D), Telerik.Reporting.Drawing.Unit.Cm(7.0000004768371582D));
                this.RvGroupbyPais.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
                graphTitle4.Height = Telerik.Reporting.Drawing.Unit.Cm(1.5D);
                graphTitle4.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
                graphTitle4.Style.Font.Bold = true;
                graphTitle4.Style.Font.Italic = true;
                graphTitle4.Style.Font.Underline = true;
                graphTitle4.Style.LineColor = System.Drawing.Color.LightGray;
                graphTitle4.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle4.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                graphTitle4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
                graphTitle4.Text = "Zona geográfica";
                graphTitle4.Width = Telerik.Reporting.Drawing.Unit.Cm(5D);
                this.RvGroupbyPais.Titles.Add(graphTitle4);
                //
                // polarCoordinateSystem2
                //
                this.polarCoordinateSystem2.AngularAxis = this.graphAxis3;
                this.polarCoordinateSystem2.Name = "polarCoordinateSystem2";
                this.polarCoordinateSystem2.RadialAxis = this.graphAxis4;
                //
                // graphAxis3
                //
                this.graphAxis3.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis3.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis3.MajorGridLineStyle.Visible = false;
                this.graphAxis3.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis3.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis3.MinorGridLineStyle.Visible = false;
                this.graphAxis3.Name = "graphAxis3";
                this.graphAxis3.Scale = numericalScale4;
                this.graphAxis3.Style.Visible = false;
                //
                // graphAxis4
                //
                this.graphAxis4.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis4.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis4.MajorGridLineStyle.Visible = false;
                this.graphAxis4.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis4.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis4.MinorGridLineStyle.Visible = false;
                this.graphAxis4.Name = "graphAxis4";
                categoryScale4.PositionMode = Telerik.Reporting.AxisPositionMode.OnTicks;
                categoryScale4.SpacingSlotCount = 0D;
                this.graphAxis4.Scale = categoryScale4;
                this.graphAxis4.Style.Visible = false;
                //
                // sqlDataSourceRvGroupbyPais
                //
                this.sqlDataSourceRvGroupbyPais.ConnectionString = "Reports_IICs.Properties.Settings.ReportsIICS_Reports";
                this.sqlDataSourceRvGroupbyPais.Name = "sqlDataSourceRvGroupbyPais";
                this.sqlDataSourceRvGroupbyPais.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
                new Telerik.Reporting.SqlDataSourceParameter("@Isin", System.Data.DbType.String, "= Parameters.Isin.Value"),
                new Telerik.Reporting.SqlDataSourceParameter("@CodigoIC", System.Data.DbType.String, "= Parameters.CodigoIC.Value")});
                this.sqlDataSourceRvGroupbyPais.SelectCommand = "dbo.RvGroupbyPais";
                this.sqlDataSourceRvGroupbyPais.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
                //
                // barSeries2
                //
                this.barSeries2.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked100;
                this.barSeries2.CategoryGroup = graphGroup11;
                this.barSeries2.CoordinateSystem = this.polarCoordinateSystem2;
                this.barSeries2.DataPointLabel = "= Format(\"{0} {1:P1}\", Fields.Pais, CDbl(Sum(Fields.Total) / CDbl(Exec(\'RvGroupby" +
        "Pais\', Sum(Fields.Total)))) )";
                this.barSeries2.DataPointLabelAlignment = Telerik.Reporting.BarDataPointLabelAlignment.OutsideColumn;
                this.barSeries2.DataPointLabelConnectorStyle.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries2.DataPointLabelConnectorStyle.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries2.DataPointLabelConnectorStyle.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries2.DataPointLabelConnectorStyle.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries2.DataPointLabelFormat = "{0:P}";
                this.barSeries2.DataPointLabelOffset = Telerik.Reporting.Drawing.Unit.Mm(1.2999999523162842D);
                this.barSeries2.DataPointLabelStyle.Font.Bold = true;
                this.barSeries2.DataPointLabelStyle.Font.Size = Telerik.Reporting.Drawing.Unit.Point(6D);
                this.barSeries2.DataPointLabelStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Point(0D);
                this.barSeries2.DataPointLabelStyle.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Cm(0.60000002384185791D);
                this.barSeries2.DataPointLabelStyle.Padding.Left = Telerik.Reporting.Drawing.Unit.Cm(0.60000002384185791D);
                this.barSeries2.DataPointLabelStyle.Padding.Right = Telerik.Reporting.Drawing.Unit.Cm(0.60000002384185791D);
                this.barSeries2.DataPointLabelStyle.Padding.Top = Telerik.Reporting.Drawing.Unit.Cm(0.60000002384185791D);
                this.barSeries2.DataPointLabelStyle.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.barSeries2.DataPointLabelStyle.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
                this.barSeries2.DataPointLabelStyle.Visible = true;
                this.barSeries2.DataPointStyle.LineColor = System.Drawing.Color.White;
                this.barSeries2.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0.05000000074505806D);
                this.barSeries2.DataPointStyle.Visible = true;
                this.barSeries2.LegendItem.Value = "= Fields.Pais";
                this.barSeries2.Name = "barSeries2";
                graphGroup12.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Pais"));
                graphGroup12.Name = "paisGroup";
                graphGroup12.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Total", Telerik.Reporting.SortDirection.Desc));
                this.barSeries2.SeriesGroup = graphGroup12;
                this.barSeries2.X = "= Sum(Fields.Total)";
                //
                // RvGroupbyEmpresa
                //
                graphGroup13.Name = "categoryGroup3";
                this.RvGroupbyEmpresa.CategoryGroups.Add(graphGroup13);
                this.RvGroupbyEmpresa.CoordinateSystems.Add(this.polarCoordinateSystem3);
                this.RvGroupbyEmpresa.DataSource = this.sqlDataSourceRvGroupbyEmpresa;
                this.RvGroupbyEmpresa.Legend.Style.LineColor = System.Drawing.Color.LightGray;
                this.RvGroupbyEmpresa.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbyEmpresa.Legend.Style.Visible = false;
                this.RvGroupbyEmpresa.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(9.9999990463256836D), Telerik.Reporting.Drawing.Unit.Cm(9.1999998092651367D));
                this.RvGroupbyEmpresa.Name = "RvGroupbyEmpresa";
                this.RvGroupbyEmpresa.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
                this.RvGroupbyEmpresa.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.RvGroupbyEmpresa.Series.Add(this.barSeries3);
                this.RvGroupbyEmpresa.SeriesGroups.Add(graphGroup14);
                this.RvGroupbyEmpresa.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(9.6999998092651367D), Telerik.Reporting.Drawing.Unit.Cm(7D));
                this.RvGroupbyEmpresa.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
                graphTitle5.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
                graphTitle5.Style.Font.Bold = true;
                graphTitle5.Style.Font.Italic = true;
                graphTitle5.Style.Font.Underline = true;
                graphTitle5.Style.LineColor = System.Drawing.Color.LightGray;
                graphTitle5.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle5.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Cm(0.30000001192092896D);
                graphTitle5.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                graphTitle5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
                graphTitle5.Text = "Tamaño";
                this.RvGroupbyEmpresa.Titles.Add(graphTitle5);
                //
                // polarCoordinateSystem3
                //
                this.polarCoordinateSystem3.AngularAxis = this.graphAxis7;
                this.polarCoordinateSystem3.Name = "polarCoordinateSystem3";
                this.polarCoordinateSystem3.RadialAxis = this.graphAxis8;
                //
                // graphAxis7
                //
                this.graphAxis7.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis7.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis7.MajorGridLineStyle.Visible = false;
                this.graphAxis7.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis7.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis7.MinorGridLineStyle.Visible = false;
                this.graphAxis7.Name = "graphAxis7";
                this.graphAxis7.Scale = numericalScale5;
                this.graphAxis7.Style.Visible = false;
                //
                // graphAxis8
                //
                this.graphAxis8.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis8.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis8.MajorGridLineStyle.Visible = false;
                this.graphAxis8.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis8.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis8.MinorGridLineStyle.Visible = false;
                this.graphAxis8.Name = "graphAxis8";
                categoryScale5.PositionMode = Telerik.Reporting.AxisPositionMode.OnTicks;
                categoryScale5.SpacingSlotCount = 0D;
                this.graphAxis8.Scale = categoryScale5;
                this.graphAxis8.Style.Visible = false;
                //
                // sqlDataSourceRvGroupbyEmpresa
                //
                this.sqlDataSourceRvGroupbyEmpresa.ConnectionString = "Reports_IICs.Properties.Settings.ReportsIICS_Reports";
                this.sqlDataSourceRvGroupbyEmpresa.Name = "sqlDataSourceRvGroupbyEmpresa";
                this.sqlDataSourceRvGroupbyEmpresa.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
                new Telerik.Reporting.SqlDataSourceParameter("@Isin", System.Data.DbType.String, "= Parameters.Isin.Value"),
                new Telerik.Reporting.SqlDataSourceParameter("@CodigoIC", System.Data.DbType.String, "= Parameters.CodigoIC.Value")});
                this.sqlDataSourceRvGroupbyEmpresa.SelectCommand = "dbo.RvGroupbyEmpresa";
                this.sqlDataSourceRvGroupbyEmpresa.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
                //
                // barSeries3
                //
                this.barSeries3.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked100;
                this.barSeries3.CategoryGroup = graphGroup13;
                this.barSeries3.CoordinateSystem = this.polarCoordinateSystem3;
                this.barSeries3.DataPointLabel = "= Format(\"{0} {1:P1}\", Fields.Empresa, CDbl(Sum(Fields.Total) / CDbl(Exec(\'RvGrou" +
        "pbyEmpresa\', Sum(Fields.Total)))))";
                this.barSeries3.DataPointLabelAlignment = Telerik.Reporting.BarDataPointLabelAlignment.OutsideColumn;
                this.barSeries3.DataPointLabelConnectorStyle.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries3.DataPointLabelConnectorStyle.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.barSeries3.DataPointLabelConnectorStyle.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.barSeries3.DataPointLabelFormat = "{0:P}";
                this.barSeries3.DataPointLabelOffset = Telerik.Reporting.Drawing.Unit.Mm(5D);
                this.barSeries3.DataPointLabelStyle.Font.Bold = true;
                this.barSeries3.DataPointLabelStyle.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
                this.barSeries3.DataPointLabelStyle.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.barSeries3.DataPointLabelStyle.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
                this.barSeries3.DataPointLabelStyle.Visible = true;
                this.barSeries3.DataPointStyle.LineColor = System.Drawing.Color.White;
                this.barSeries3.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0.05000000074505806D);
                this.barSeries3.DataPointStyle.Visible = true;
                this.barSeries3.LegendItem.Value = "= Fields.Empresa";
                this.barSeries3.Name = "barSeries3";
                graphGroup14.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Empresa"));
                graphGroup14.Name = "empresaGroup";
                graphGroup14.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Total", Telerik.Reporting.SortDirection.Desc));
                this.barSeries3.SeriesGroup = graphGroup14;
                this.barSeries3.X = "= Sum(Fields.Total)";
                //
                // graph2
                //
                graphGroup15.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Sector"));
                graphGroup15.Name = "sectorGroup2";
                graphGroup15.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.graph2.CategoryGroups.Add(graphGroup15);
                this.graph2.CoordinateSystems.Add(this.polarCoordinateSystem6);
                this.graph2.DataSource = this.sqlDataSourceRvGroupbySector;
                this.graph2.Legend.Position = Telerik.Reporting.GraphItemPosition.BottomCenter;
                this.graph2.Legend.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
                this.graph2.Legend.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(6D);
                this.graph2.Legend.Style.LineColor = System.Drawing.Color.Black;
                this.graph2.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Point(1D);
                this.graph2.Legend.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph2.Legend.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph2.Legend.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph2.Legend.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(6.0999999046325684D), Telerik.Reporting.Drawing.Unit.Cm(17.299999237060547D));
                this.graph2.Name = "graph2";
                this.graph2.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
                this.graph2.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.graph2.Series.Add(this.barSeries6);
                graphGroup18.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Categoria"));
                graphGroup18.Name = "categoriaGroup2";
                graphGroup18.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.graph2.SeriesGroups.Add(graphGroup18);
                this.graph2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(9.7000007629394531D), Telerik.Reporting.Drawing.Unit.Cm(7D));
                this.graph2.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.graph2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(7D);
                this.graph2.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph2.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph2.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph2.Style.Visible = false;
                graphTitle6.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
                graphTitle6.Style.Font.Bold = true;
                graphTitle6.Style.Font.Italic = true;
                graphTitle6.Style.LineColor = System.Drawing.Color.LightGray;
                graphTitle6.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle6.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
                graphTitle6.Text = "Sectorial";
                this.graph2.Titles.Add(graphTitle6);
                //
                // polarCoordinateSystem6
                //
                this.polarCoordinateSystem6.AngularAxis = this.graphAxis14;
                this.polarCoordinateSystem6.Name = "polarCoordinateSystem6";
                this.polarCoordinateSystem6.RadialAxis = this.graphAxis13;
                //
                // graphAxis14
                //
                this.graphAxis14.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis14.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis14.MajorGridLineStyle.Visible = false;
                this.graphAxis14.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis14.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis14.MinorGridLineStyle.Visible = false;
                this.graphAxis14.Name = "graphAxis14";
                categoryScale6.PositionMode = Telerik.Reporting.AxisPositionMode.OnTicks;
                categoryScale6.SpacingSlotCount = 0D;
                this.graphAxis14.Scale = categoryScale6;
                this.graphAxis14.Style.Visible = false;
                //
                // graphAxis13
                //
                this.graphAxis13.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis13.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis13.MajorGridLineStyle.Visible = false;
                this.graphAxis13.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis13.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis13.MinorGridLineStyle.Visible = false;
                this.graphAxis13.Name = "graphAxis13";
                this.graphAxis13.Scale = numericalScale6;
                this.graphAxis13.Style.Visible = false;
                //
                // barSeries6
                //
                this.barSeries6.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked100;
                graphGroup16.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Sector"));
                graphGroup16.Name = "sectorGroup2";
                graphGroup16.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.barSeries6.CategoryGroup = graphGroup16;
                this.barSeries6.CoordinateSystem = this.polarCoordinateSystem6;
                this.barSeries6.DataPointLabel = "= Format(\"{0} {1:P1}\", Fields.Sector, CDbl(Sum(Fields.Total) / CDbl(Exec(\'graph2\'" +
        ", Sum(Fields.Total))) ))";
                this.barSeries6.DataPointLabelAlignment = Telerik.Reporting.BarDataPointLabelAlignment.OutsideColumn;
                this.barSeries6.DataPointLabelFormat = "{0:P}";
                this.barSeries6.DataPointLabelOffset = Telerik.Reporting.Drawing.Unit.Pixel(30D);
                this.barSeries6.DataPointLabelStyle.Font.Bold = true;
                this.barSeries6.DataPointLabelStyle.Font.Size = Telerik.Reporting.Drawing.Unit.Point(5D);
                this.barSeries6.DataPointLabelStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Point(0D);
                this.barSeries6.DataPointLabelStyle.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.barSeries6.DataPointLabelStyle.Visible = true;
                this.barSeries6.DataPointStyle.LineColor = System.Drawing.Color.White;
                this.barSeries6.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0.0099999997764825821D);
                this.barSeries6.DataPointStyle.Visible = true;
                this.barSeries6.LegendItem.Value = "= Fields.Categoria + \' \' +  Format(\'{0:p1}\',CDbl(Exec(\'categoriaGroup2\', Sum(Fiel" +
        "ds.Total))) / CDbl(Exec(\'graph2\', Sum(Fields.Total))))";
                this.barSeries6.Name = "barSeries6";
                graphGroup17.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Categoria"));
                graphGroup17.Name = "categoriaGroup2";
                graphGroup17.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.barSeries6.SeriesGroup = graphGroup17;
                this.barSeries6.ToolTip.Text = "= Format(\'{0:P}\', Sum(Fields.Total) / CDbl(Exec(\'graph2\', Sum(Fields.Total))))";
                this.barSeries6.ToolTip.Title = "= Fields.Categoria";
                this.barSeries6.Y = "= Sum(Fields.Total)";
                //
                // pageFooterSection1
                //
                this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Cm(0.56000000238418579D);
                this.pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.TextNumPaginaPie});
                this.pageFooterSection1.Name = "pageFooterSection1";
                //
                // TextNumPaginaPie
                //
                this.TextNumPaginaPie.Docking = Telerik.Reporting.DockingStyle.Right;
                this.TextNumPaginaPie.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(16.19999885559082D), Telerik.Reporting.Drawing.Unit.Cm(0D));
                this.TextNumPaginaPie.Name = "TextNumPaginaPie";
                this.TextNumPaginaPie.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(3.5999999046325684D), Telerik.Reporting.Drawing.Unit.Cm(0.56000000238418579D));
                this.TextNumPaginaPie.Style.Font.Name = "Tahoma";
                this.TextNumPaginaPie.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
                this.TextNumPaginaPie.Value = "= Format(\"{0} {1} {2} {3}\", Reports_IICs.Helpers.ReportFunctions.ReportPageText()" +
        ", PageNumber-1,Reports_IICs.Helpers.ReportFunctions.ReportFromText(), PageCount-" +
        "1-1 )  \r\n\r\n";
                //
                // graphAxis5
                //
                this.graphAxis5.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis5.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis5.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis5.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis5.MinorGridLineStyle.Visible = false;
                this.graphAxis5.Name = "graphAxis5";
                //
                // graphAxis6
                //
                this.graphAxis6.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis6.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis6.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis6.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis6.MinorGridLineStyle.Visible = false;
                this.graphAxis6.Name = "graphAxis6";
                //
                // reportHeaderSection1
                //
                this.reportHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Cm(1.2000000476837158D);
                this.reportHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.TituloReport});
                this.reportHeaderSection1.Name = "reportHeaderSection1";
                //
                // ReportCompCartRV
                //
                this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.pageHeaderSection1,
                this.detail,
                this.pageFooterSection1,
                this.reportHeaderSection1});
                this.Name = "ReportCompCartRV";
                this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Mm(5D), Telerik.Reporting.Drawing.Unit.Mm(5D), Telerik.Reporting.Drawing.Unit.Mm(5D), Telerik.Reporting.Drawing.Unit.Mm(5D));
                this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
                reportParameter1.AllowNull = true;
                reportParameter1.Name = "Isin";
                reportParameter1.Text = "Isin";
                reportParameter1.Value = "A25238833";
                reportParameter2.Name = "CodigoIC";
                reportParameter2.Text = "CodigoIC";
                reportParameter2.Value = "502";
                this.ReportParameters.Add(reportParameter1);
                this.ReportParameters.Add(reportParameter2);
                styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
                new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
                new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))});
                styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
                styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
                styleRule1});
                this.Width = Telerik.Reporting.Drawing.Unit.Cm(19.799999237060547D);
                this.NeedDataSource += new System.EventHandler(this.ReportCompCartRV_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.SqlDataSource sqlDataSourceRvGroupbyDivisa;
            private Telerik.Reporting.SqlDataSource sqlDataSourceRvGroupbyPais;
            private Telerik.Reporting.SqlDataSource sqlDataSourceRvGroupbySector;
            private Telerik.Reporting.SqlDataSource sqlDataSourceRvGroupbyEmpresa;
            private Telerik.Reporting.GraphAxis graphAxis5;
            private Telerik.Reporting.GraphAxis graphAxis6;
            private Telerik.Reporting.TextBox TituloReport;
            private Telerik.Reporting.TextBox textBoxISIN;
            private Telerik.Reporting.Graph RvGroupbySector2;
            private Telerik.Reporting.PolarCoordinateSystem polarCoordinateSystem5;
            private Telerik.Reporting.GraphAxis graphAxis11;
            private Telerik.Reporting.GraphAxis graphAxis12;
            private Telerik.Reporting.BarSeries barSeries5;
            private Telerik.Reporting.TextBox TextNumPaginaPie;
            private Telerik.Reporting.ReportHeaderSection reportHeaderSection1;
            private Telerik.Reporting.PictureBox LogoPortada;
            private Telerik.Reporting.Graph RvGroupbyDivisa;
            private Telerik.Reporting.PolarCoordinateSystem polarCoordinateSystem1;
            private Telerik.Reporting.GraphAxis graphAxis1;
            private Telerik.Reporting.GraphAxis graphAxis2;
            private Telerik.Reporting.BarSeries barSeries1;
            private Telerik.Reporting.Graph RvGroupbyPais;
            private Telerik.Reporting.PolarCoordinateSystem polarCoordinateSystem2;
            private Telerik.Reporting.GraphAxis graphAxis3;
            private Telerik.Reporting.GraphAxis graphAxis4;
            private Telerik.Reporting.BarSeries barSeries2;
            private Telerik.Reporting.Graph RvGroupbyEmpresa;
            private Telerik.Reporting.PolarCoordinateSystem polarCoordinateSystem3;
            private Telerik.Reporting.GraphAxis graphAxis7;
            private Telerik.Reporting.GraphAxis graphAxis8;
            private Telerik.Reporting.BarSeries barSeries3;
            private Telerik.Reporting.BarSeries barSeries4;
            private Telerik.Reporting.GraphAxis graphAxis10;
            private Telerik.Reporting.GraphAxis graphAxis9;
            private Telerik.Reporting.PolarCoordinateSystem polarCoordinateSystem4;
            private Telerik.Reporting.Graph graph1;
            private Telerik.Reporting.Graph graph2;
            private Telerik.Reporting.PolarCoordinateSystem polarCoordinateSystem6;
            private Telerik.Reporting.GraphAxis graphAxis14;
            private Telerik.Reporting.GraphAxis graphAxis13;
            private Telerik.Reporting.BarSeries barSeries6;
        }
    }

     

    Thanks.
  6. J
    J avatar
    18 posts
    Member since:
    Sep 2015

    Posted 26 Oct in reply to J Link to this post

    Sorry for sending multiple charts in the report definition. You might see it clearer now with just the chart we are treating:

    namespace mynamespace
    {
        partial class MyReport
        {
            #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(ReportCompCartRV));
                Telerik.Reporting.GraphGroup graphGroup1 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup4 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphTitle graphTitle1 = new Telerik.Reporting.GraphTitle();
                Telerik.Reporting.CategoryScale categoryScale1 = new Telerik.Reporting.CategoryScale();
                Telerik.Reporting.NumericalScale numericalScale1 = new Telerik.Reporting.NumericalScale();
                Telerik.Reporting.GraphGroup graphGroup2 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.GraphGroup graphGroup3 = new Telerik.Reporting.GraphGroup();
                Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
                Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
                Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
                this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
                this.LogoPortada = new Telerik.Reporting.PictureBox();
                this.TituloReport = new Telerik.Reporting.TextBox();
                this.detail = new Telerik.Reporting.DetailSection();
                this.sqlDataSourceRvGroupbySector = new Telerik.Reporting.SqlDataSource();
                this.textBoxISIN = new Telerik.Reporting.TextBox();
                this.sqlDataSourceRvGroupbyDivisa = new Telerik.Reporting.SqlDataSource();
                this.sqlDataSourceRvGroupbyPais = new Telerik.Reporting.SqlDataSource();
                this.sqlDataSourceRvGroupbyEmpresa = new Telerik.Reporting.SqlDataSource();
                this.graph2 = new Telerik.Reporting.Graph();
                this.polarCoordinateSystem6 = new Telerik.Reporting.PolarCoordinateSystem();
                this.graphAxis14 = new Telerik.Reporting.GraphAxis();
                this.graphAxis13 = new Telerik.Reporting.GraphAxis();
                this.barSeries6 = new Telerik.Reporting.BarSeries();
                this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
                this.TextNumPaginaPie = new Telerik.Reporting.TextBox();
                this.graphAxis5 = new Telerik.Reporting.GraphAxis();
                this.graphAxis6 = new Telerik.Reporting.GraphAxis();
                this.reportHeaderSection1 = new Telerik.Reporting.ReportHeaderSection();
                ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
                //
                // pageHeaderSection1
                //
                this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Cm(1D);
                this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.LogoPortada});
                this.pageHeaderSection1.Name = "pageHeaderSection1";
                //
                // LogoPortada
                //
                this.LogoPortada.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(0.00010004233627114445D));
                this.LogoPortada.MimeType = "image/jpeg";
                this.LogoPortada.Name = "LogoPortada";
                this.LogoPortada.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(4.8000001907348633D), Telerik.Reporting.Drawing.Unit.Cm(1D));
                this.LogoPortada.Value = ((object)(resources.GetObject("LogoPortada.Value")));
                //
                // TituloReport
                //
                this.TituloReport.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.19999977946281433D), Telerik.Reporting.Drawing.Unit.Cm(0D));
                this.TituloReport.Name = "TituloReport";
                this.TituloReport.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(19.5D), Telerik.Reporting.Drawing.Unit.Cm(1.2000000476837158D));
                this.TituloReport.Style.Font.Bold = true;
                this.TituloReport.Style.Font.Name = "Tahoma";
                this.TituloReport.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(14D);
                this.TituloReport.Style.Font.Strikeout = false;
                this.TituloReport.Style.Font.Underline = false;
                this.TituloReport.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.TituloReport.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
                this.TituloReport.Value = "COMPOSICIÓN CARTERA RENTA VARIABLE";
                //
                // detail
                //
                this.detail.Height = Telerik.Reporting.Drawing.Unit.Cm(24.75990104675293D);
                this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.textBoxISIN,
                this.graph2});
                this.detail.Name = "detail";
                //
                // sqlDataSourceRvGroupbySector
                //
                this.sqlDataSourceRvGroupbySector.ConnectionString = "Reports_IICs.Properties.Settings.ReportsIICS_Reports";
                this.sqlDataSourceRvGroupbySector.Name = "sqlDataSourceRvGroupbySector";
                this.sqlDataSourceRvGroupbySector.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
                new Telerik.Reporting.SqlDataSourceParameter("@Isin", System.Data.DbType.String, "= Parameters.Isin.Value"),
                new Telerik.Reporting.SqlDataSourceParameter("@CodigoIC", System.Data.DbType.String, "= Parameters.CodigoIC.Value")});
                this.sqlDataSourceRvGroupbySector.SelectCommand = "dbo.RvGroupbySector";
                this.sqlDataSourceRvGroupbySector.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
                //
                // textBoxISIN
                //
                this.textBoxISIN.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.20000012218952179D), Telerik.Reporting.Drawing.Unit.Cm(0.00020024616969749332D));
                this.textBoxISIN.Name = "textBoxISIN";
                this.textBoxISIN.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(19.499998092651367D), Telerik.Reporting.Drawing.Unit.Cm(0.7999998927116394D));
                this.textBoxISIN.Style.Font.Bold = true;
                this.textBoxISIN.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
                this.textBoxISIN.Style.Font.Underline = false;
                this.textBoxISIN.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.textBoxISIN.Value = "";
                //
                // sqlDataSourceRvGroupbyDivisa
                //
                this.sqlDataSourceRvGroupbyDivisa.ConnectionString = "Reports_IICs.Properties.Settings.ReportsIICS_Reports";
                this.sqlDataSourceRvGroupbyDivisa.Name = "sqlDataSourceRvGroupbyDivisa";
                this.sqlDataSourceRvGroupbyDivisa.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
                new Telerik.Reporting.SqlDataSourceParameter("@Isin", System.Data.DbType.String, "= Parameters.Isin.Value"),
                new Telerik.Reporting.SqlDataSourceParameter("@CodigoIC", System.Data.DbType.String, "= Parameters.CodigoIC.Value")});
                this.sqlDataSourceRvGroupbyDivisa.SelectCommand = "dbo.RvGroupbyDivisa";
                this.sqlDataSourceRvGroupbyDivisa.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
                //
                // sqlDataSourceRvGroupbyPais
                //
                this.sqlDataSourceRvGroupbyPais.ConnectionString = "Reports_IICs.Properties.Settings.ReportsIICS_Reports";
                this.sqlDataSourceRvGroupbyPais.Name = "sqlDataSourceRvGroupbyPais";
                this.sqlDataSourceRvGroupbyPais.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
                new Telerik.Reporting.SqlDataSourceParameter("@Isin", System.Data.DbType.String, "= Parameters.Isin.Value"),
                new Telerik.Reporting.SqlDataSourceParameter("@CodigoIC", System.Data.DbType.String, "= Parameters.CodigoIC.Value")});
                this.sqlDataSourceRvGroupbyPais.SelectCommand = "dbo.RvGroupbyPais";
                this.sqlDataSourceRvGroupbyPais.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
                //
                // sqlDataSourceRvGroupbyEmpresa
                //
                this.sqlDataSourceRvGroupbyEmpresa.ConnectionString = "Reports_IICs.Properties.Settings.ReportsIICS_Reports";
                this.sqlDataSourceRvGroupbyEmpresa.Name = "sqlDataSourceRvGroupbyEmpresa";
                this.sqlDataSourceRvGroupbyEmpresa.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
                new Telerik.Reporting.SqlDataSourceParameter("@Isin", System.Data.DbType.String, "= Parameters.Isin.Value"),
                new Telerik.Reporting.SqlDataSourceParameter("@CodigoIC", System.Data.DbType.String, "= Parameters.CodigoIC.Value")});
                this.sqlDataSourceRvGroupbyEmpresa.SelectCommand = "dbo.RvGroupbyEmpresa";
                this.sqlDataSourceRvGroupbyEmpresa.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
                //
                // graph2
                //
                graphGroup1.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Sector"));
                graphGroup1.Name = "sectorGroup2";
                graphGroup1.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.graph2.CategoryGroups.Add(graphGroup1);
                this.graph2.CoordinateSystems.Add(this.polarCoordinateSystem6);
                this.graph2.DataSource = this.sqlDataSourceRvGroupbySector;
                this.graph2.Legend.Position = Telerik.Reporting.GraphItemPosition.BottomCenter;
                this.graph2.Legend.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
                this.graph2.Legend.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(6D);
                this.graph2.Legend.Style.LineColor = System.Drawing.Color.Black;
                this.graph2.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Point(1D);
                this.graph2.Legend.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph2.Legend.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph2.Legend.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph2.Legend.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
                this.graph2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(6.0999999046325684D), Telerik.Reporting.Drawing.Unit.Cm(17.299999237060547D));
                this.graph2.Name = "graph2";
                this.graph2.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
                this.graph2.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.graph2.Series.Add(this.barSeries6);
                graphGroup4.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Categoria"));
                graphGroup4.Name = "categoriaGroup2";
                graphGroup4.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.graph2.SeriesGroups.Add(graphGroup4);
                this.graph2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(9.7000007629394531D), Telerik.Reporting.Drawing.Unit.Cm(7D));
                this.graph2.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.graph2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(7D);
                this.graph2.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph2.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph2.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(10D);
                this.graph2.Style.Visible = false;
                graphTitle1.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
                graphTitle1.Style.Font.Bold = true;
                graphTitle1.Style.Font.Italic = true;
                graphTitle1.Style.LineColor = System.Drawing.Color.LightGray;
                graphTitle1.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle1.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
                graphTitle1.Text = "Sectorial";
                this.graph2.Titles.Add(graphTitle1);
                //
                // polarCoordinateSystem6
                //
                this.polarCoordinateSystem6.AngularAxis = this.graphAxis14;
                this.polarCoordinateSystem6.Name = "polarCoordinateSystem6";
                this.polarCoordinateSystem6.RadialAxis = this.graphAxis13;
                //
                // graphAxis14
                //
                this.graphAxis14.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis14.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis14.MajorGridLineStyle.Visible = false;
                this.graphAxis14.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis14.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis14.MinorGridLineStyle.Visible = false;
                this.graphAxis14.Name = "graphAxis14";
                categoryScale1.PositionMode = Telerik.Reporting.AxisPositionMode.OnTicks;
                categoryScale1.SpacingSlotCount = 0D;
                this.graphAxis14.Scale = categoryScale1;
                this.graphAxis14.Style.Visible = false;
                //
                // graphAxis13
                //
                this.graphAxis13.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis13.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis13.MajorGridLineStyle.Visible = false;
                this.graphAxis13.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis13.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis13.MinorGridLineStyle.Visible = false;
                this.graphAxis13.Name = "graphAxis13";
                this.graphAxis13.Scale = numericalScale1;
                this.graphAxis13.Style.Visible = false;
                //
                // barSeries6
                //
                this.barSeries6.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked100;
                graphGroup2.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Sector"));
                graphGroup2.Name = "sectorGroup2";
                graphGroup2.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.barSeries6.CategoryGroup = graphGroup2;
                this.barSeries6.CoordinateSystem = this.polarCoordinateSystem6;
                this.barSeries6.DataPointLabel = "= Format(\"{0} {1:P1}\", Fields.Sector, CDbl(Sum(Fields.Total) / CDbl(Exec(\'graph2\'" +
        ", Sum(Fields.Total))) ))";
                this.barSeries6.DataPointLabelAlignment = Telerik.Reporting.BarDataPointLabelAlignment.OutsideColumn;
                this.barSeries6.DataPointLabelFormat = "{0:P}";
                this.barSeries6.DataPointLabelOffset = Telerik.Reporting.Drawing.Unit.Pixel(30D);
                this.barSeries6.DataPointLabelStyle.Font.Bold = true;
                this.barSeries6.DataPointLabelStyle.Font.Size = Telerik.Reporting.Drawing.Unit.Point(5D);
                this.barSeries6.DataPointLabelStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Point(0D);
                this.barSeries6.DataPointLabelStyle.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
                this.barSeries6.DataPointLabelStyle.Visible = true;
                this.barSeries6.DataPointStyle.LineColor = System.Drawing.Color.White;
                this.barSeries6.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0.0099999997764825821D);
                this.barSeries6.DataPointStyle.Visible = true;
                this.barSeries6.LegendItem.Value = "= Fields.Categoria + \' \' +  Format(\'{0:p1}\',CDbl(Exec(\'categoriaGroup2\', Sum(Fiel" +
        "ds.Total))) / CDbl(Exec(\'graph2\', Sum(Fields.Total))))";
                this.barSeries6.Name = "barSeries6";
                graphGroup3.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Categoria"));
                graphGroup3.Name = "categoriaGroup2";
                graphGroup3.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Categoria", Telerik.Reporting.SortDirection.Asc));
                this.barSeries6.SeriesGroup = graphGroup3;
                this.barSeries6.ToolTip.Text = "= Format(\'{0:P}\', Sum(Fields.Total) / CDbl(Exec(\'graph2\', Sum(Fields.Total))))";
                this.barSeries6.ToolTip.Title = "= Fields.Categoria";
                this.barSeries6.Y = "= Sum(Fields.Total)";
                //
                // pageFooterSection1
                //
                this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Cm(0.56000000238418579D);
                this.pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.TextNumPaginaPie});
                this.pageFooterSection1.Name = "pageFooterSection1";
                //
                // TextNumPaginaPie
                //
                this.TextNumPaginaPie.Docking = Telerik.Reporting.DockingStyle.Right;
                this.TextNumPaginaPie.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(16.19999885559082D), Telerik.Reporting.Drawing.Unit.Cm(0D));
                this.TextNumPaginaPie.Name = "TextNumPaginaPie";
                this.TextNumPaginaPie.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(3.5999999046325684D), Telerik.Reporting.Drawing.Unit.Cm(0.56000000238418579D));
                this.TextNumPaginaPie.Style.Font.Name = "Tahoma";
                this.TextNumPaginaPie.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
                this.TextNumPaginaPie.Value = "= Format(\"{0} {1} {2} {3}\", Reports_IICs.Helpers.ReportFunctions.ReportPageText()" +
        ", PageNumber-1,Reports_IICs.Helpers.ReportFunctions.ReportFromText(), PageCount-" +
        "1-1 )  \r\n\r\n";
                //
                // graphAxis5
                //
                this.graphAxis5.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis5.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis5.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis5.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis5.MinorGridLineStyle.Visible = false;
                this.graphAxis5.Name = "graphAxis5";
                //
                // graphAxis6
                //
                this.graphAxis6.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis6.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis6.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
                this.graphAxis6.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
                this.graphAxis6.MinorGridLineStyle.Visible = false;
                this.graphAxis6.Name = "graphAxis6";
                //
                // reportHeaderSection1
                //
                this.reportHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Cm(1.2000000476837158D);
                this.reportHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.TituloReport});
                this.reportHeaderSection1.Name = "reportHeaderSection1";
                //
                // ReportCompCartRV
                //
                this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.pageHeaderSection1,
                this.detail,
                this.pageFooterSection1,
                this.reportHeaderSection1});
                this.Name = "ReportCompCartRV";
                this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Mm(5D), Telerik.Reporting.Drawing.Unit.Mm(5D), Telerik.Reporting.Drawing.Unit.Mm(5D), Telerik.Reporting.Drawing.Unit.Mm(5D));
                this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
                reportParameter1.AllowNull = true;
                reportParameter1.Name = "Isin";
                reportParameter1.Text = "Isin";
                reportParameter1.Value = "A25238833";
                reportParameter2.Name = "CodigoIC";
                reportParameter2.Text = "CodigoIC";
                reportParameter2.Value = "502";
                this.ReportParameters.Add(reportParameter1);
                this.ReportParameters.Add(reportParameter2);
                styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
                new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
                new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))});
                styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
                styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
                this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
                styleRule1});
                this.Width = Telerik.Reporting.Drawing.Unit.Cm(19.799999237060547D);
                this.NeedDataSource += new System.EventHandler(this.ReportCompCartRV_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.SqlDataSource sqlDataSourceRvGroupbyDivisa;
            private Telerik.Reporting.SqlDataSource sqlDataSourceRvGroupbyPais;
            private Telerik.Reporting.SqlDataSource sqlDataSourceRvGroupbySector;
            private Telerik.Reporting.SqlDataSource sqlDataSourceRvGroupbyEmpresa;
            private Telerik.Reporting.GraphAxis graphAxis5;
            private Telerik.Reporting.GraphAxis graphAxis6;
            private Telerik.Reporting.TextBox TituloReport;
            private Telerik.Reporting.TextBox textBoxISIN;
            private Telerik.Reporting.TextBox TextNumPaginaPie;
            private Telerik.Reporting.ReportHeaderSection reportHeaderSection1;
            private Telerik.Reporting.PictureBox LogoPortada;
            private Telerik.Reporting.Graph graph2;
            private Telerik.Reporting.PolarCoordinateSystem polarCoordinateSystem6;
            private Telerik.Reporting.GraphAxis graphAxis14;
            private Telerik.Reporting.GraphAxis graphAxis13;
            private Telerik.Reporting.BarSeries barSeries6;
        }
    }

     

  7. Ivan Hristov
    Admin
    Ivan Hristov avatar
    123 posts

    Posted 26 Oct Link to this post

    Hello,

    I examined the report definition and noticed a few strange issues. Two GraphGroup instances: graphGroup1 and graphGroup4 are added to the graph's groups collection, but are not used in its series, which uses graphGroup2 and graphGroup3. This might happen if the designer.cs file has been modified manually. I deleted the first group instances and now the graph uses only graphGroup2 and graphGroup3.

    More, your pie chart setup seems incorrect, since it has a category grouping defined, and, as mentioned earlier, you don't need that for such simple scenarios, so I deleted the category group's grouping and changed the series group to Sector.

    Finally, the graph's CoordinateSystem has its angular axis set to CategoryScale, which was causing the incorrect display of the "pie slices" - all the slices were the same size, regardless the Total value they represent. In your scenario I guess the angular axis represents the value, so it should use a Numerical Scale and the radial axis should use a Category Scale. The axes switch can be done by right-clicking on the graph and choosing "Swap Axes" from the context menu.

    And finally, your graph item had its Visible property set to false, which would naturally prevent its rendering.

    We strongly recommend using the Graph Wizard to create complex graphs in order to avoid such mistakes. Using the wizard, you only have to select the data source, drag the Sector field into Series box and Total field to Values box and your pie chart will be done, saving the effort of setting it up manually.

    I have attached the fixed report definition, which uses a CSV data source for the graph data. Please examine it and apply the changes, described above, to your report.

    Regards,
    Ivan Hristov
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  8. J
    J avatar
    18 posts
    Member since:
    Sep 2015

    Posted 27 Oct in reply to Ivan Hristov Link to this post

    Thanks again for your help.

    Is the result that you got the same as the image that I attached to the first post? I want to group the pie by sector and the legend at the bottom by categoria. I am not sure if we are trying to achieve the same or if I got you wrong.

  9. Ivan Hristov
    Admin
    Ivan Hristov avatar
    123 posts

    Posted 30 Oct Link to this post

    Hello,

    The pie chart I attached earlier differs than the one in your original post, because I thought your chart was incorrect - all of its slices have the same size, which is unexpected for a pie chart, where the data's most significant value is represented by the size of the sector and the user can judge about the value ratios by visually comparing the pie slices.

    However, the legend represents the series groups, so there is no straightforward way of having different number of series in the graph and in the legend. You can control a legend item visibility by its ConditionalFormatting property and this way you can make some legend entries invisible.

    You can also apply coloring to the pie series using Graph's ColorPalette or ConditionalFormatting so your pie slices will be colored according to their Category and not Sector they belong to.

    Regards,
    Ivan Hristov
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  10. J
    J avatar
    18 posts
    Member since:
    Sep 2015

    Posted 02 Nov in reply to Ivan Hristov Link to this post

    I have finally created two different graphs (with different groupings), one for the pie chart and the other one for the legend. I also set same conditional formatting for both graphs.

    Thanks for your help!
Back to Top