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
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
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)"
;
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
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.
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;
}
}
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
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.
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
Thanks for your help!