This is a migrated thread and some comments may be shown as answers.

Pie chart not displaying label connector line

9 Answers 247 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
J
Top achievements
Rank 1
J asked on 24 Oct 2017, 11:10 AM

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.

9 Answers, 1 is accepted

Sort by
0
Ivan Hristov
Telerik team
answered on 25 Oct 2017, 08:25 AM
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
0
J
Top achievements
Rank 1
answered on 25 Oct 2017, 01:36 PM
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)";
0
Ivan Hristov
Telerik team
answered on 25 Oct 2017, 02:59 PM
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
0
J
Top achievements
Rank 1
answered on 26 Oct 2017, 08:01 AM

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.
0
J
Top achievements
Rank 1
answered on 26 Oct 2017, 08:09 AM

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;
    }
}

 

0
Ivan Hristov
Telerik team
answered on 26 Oct 2017, 03:11 PM
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
0
J
Top achievements
Rank 1
answered on 27 Oct 2017, 09:48 AM

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.

0
Ivan Hristov
Telerik team
answered on 30 Oct 2017, 01:00 PM
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
0
J
Top achievements
Rank 1
answered on 02 Nov 2017, 11:23 AM
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!
Tags
General Discussions
Asked by
J
Top achievements
Rank 1
Answers by
Ivan Hristov
Telerik team
J
Top achievements
Rank 1
Share this question
or