/// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     DevExpress.DashboardCommon.Dimension               dimension1              = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure                 measure1                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure2                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure3                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.ValueMap                valueMap1               = new DevExpress.DashboardCommon.ValueMap();
     DevExpress.DashboardCommon.UniformScale            uniformScale1           = new DevExpress.DashboardCommon.UniformScale();
     DevExpress.DashboardCommon.DeltaMap                deltaMap1               = new DevExpress.DashboardCommon.DeltaMap();
     System.ComponentModel.ComponentResourceManager     resources               = new System.ComponentModel.ComponentResourceManager(typeof(SampleDashboard));
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo1              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo2              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo3              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo4              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo5              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo6              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo7              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo8              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo9              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.ExcelWorksheetSettings excelWorksheetSettings1 = new DevExpress.DataAccess.Excel.ExcelWorksheetSettings();
     DevExpress.DataAccess.Excel.ExcelSourceOptions     excelSourceOptions1     = new DevExpress.DataAccess.Excel.ExcelSourceOptions(excelWorksheetSettings1);
     DevExpress.DashboardCommon.Dimension               dimension2              = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn1    = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.Measure                 measure4                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure5                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.GridDeltaColumn         gridDeltaColumn1        = new DevExpress.DashboardCommon.GridDeltaColumn();
     DevExpress.DashboardCommon.Dimension               dimension3              = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure                 measure6                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.ChartPane               chartPane1              = new DevExpress.DashboardCommon.ChartPane();
     DevExpress.DashboardCommon.SimpleSeries            simpleSeries1           = new DevExpress.DashboardCommon.SimpleSeries();
     DevExpress.DashboardCommon.Measure                 measure7                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure8                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Card card1 = new DevExpress.DashboardCommon.Card();
     DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate1 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate();
     DevExpress.DashboardCommon.Measure measure9  = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure measure10 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Card    card2     = new DevExpress.DashboardCommon.Card();
     DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate2 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate();
     DevExpress.DashboardCommon.Measure measure11 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure measure12 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Card    card3     = new DevExpress.DashboardCommon.Card();
     DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate3 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate();
     DevExpress.DashboardCommon.DashboardLayoutGroup        dashboardLayoutGroup1        = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutGroup        dashboardLayoutGroup2        = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutItem         dashboardLayoutItem1         = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutItem         dashboardLayoutItem2         = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutGroup        dashboardLayoutGroup3        = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutItem         dashboardLayoutItem3         = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutItem         dashboardLayoutItem4         = new DevExpress.DashboardCommon.DashboardLayoutItem();
     this.choroplethMapDashboardItem1 = new DevExpress.DashboardCommon.ChoroplethMapDashboardItem();
     this.dashboardExcelDataSource1   = new DevExpress.DashboardCommon.DashboardExcelDataSource();
     this.gridDashboardItem1          = new DevExpress.DashboardCommon.GridDashboardItem();
     this.chartDashboardItem1         = new DevExpress.DashboardCommon.ChartDashboardItem();
     this.cardDashboardItem1          = new DevExpress.DashboardCommon.CardDashboardItem();
     ((System.ComponentModel.ISupportInitialize)(this.choroplethMapDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure6)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure7)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure8)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure9)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure10)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure11)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure12)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // choroplethMapDashboardItem1
     //
     this.choroplethMapDashboardItem1.Area = DevExpress.DashboardCommon.ShapefileArea.USA;
     dimension1.DataMember = "State";
     this.choroplethMapDashboardItem1.AttributeDimension = dimension1;
     this.choroplethMapDashboardItem1.AttributeName      = "NAME";
     this.choroplethMapDashboardItem1.ComponentName      = "choroplethMapDashboardItem1";
     measure1.DataMember = "RevenueYTD (Sum)";
     measure2.DataMember = "RevenueYTD (Sum)";
     measure3.DataMember = "RevenueYTDTarget (Sum)";
     this.choroplethMapDashboardItem1.DataItemRepository.Clear();
     this.choroplethMapDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0");
     this.choroplethMapDashboardItem1.DataItemRepository.Add(measure1, "DataItem1");
     this.choroplethMapDashboardItem1.DataItemRepository.Add(measure2, "DataItem2");
     this.choroplethMapDashboardItem1.DataItemRepository.Add(measure3, "DataItem3");
     this.choroplethMapDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     this.choroplethMapDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.choroplethMapDashboardItem1.InteractivityOptions.MasterFilterMode    = DevExpress.DashboardCommon.DashboardItemMasterFilterMode.Multiple;
     valueMap1.Name      = "Revenue YTD";
     valueMap1.Scale     = uniformScale1;
     valueMap1.ValueName = "Revenue";
     valueMap1.AddDataItem("Value", measure1);
     deltaMap1.ActualValueName = "Revenue";
     deltaMap1.DeltaName       = "vs Target";
     deltaMap1.Name            = "Revenue YTD vs Target";
     deltaMap1.AddDataItem("ActualValue", measure2);
     deltaMap1.AddDataItem("TargetValue", measure3);
     this.choroplethMapDashboardItem1.Maps.AddRange(new DevExpress.DashboardCommon.ChoroplethMap[] {
         valueMap1,
         deltaMap1
     });
     this.choroplethMapDashboardItem1.Name = "Sales by State";
     this.choroplethMapDashboardItem1.ShapeTitleAttributeName       = "ABBREV";
     this.choroplethMapDashboardItem1.ShowCaption                   = true;
     this.choroplethMapDashboardItem1.Viewport.BottomLatitude       = 22.722765208057595D;
     this.choroplethMapDashboardItem1.Viewport.CenterPointLatitude  = 37.208247632673633D;
     this.choroplethMapDashboardItem1.Viewport.CenterPointLongitude = -95.848499902568008D;
     this.choroplethMapDashboardItem1.Viewport.LeftLongitude        = -124.70997774915153D;
     this.choroplethMapDashboardItem1.Viewport.RightLongitude       = -66.987022055984482D;
     this.choroplethMapDashboardItem1.Viewport.TopLatitude          = 49.369672064487254D;
     //
     // dashboardExcelDataSource1
     //
     this.dashboardExcelDataSource1.ComponentName            = "dashboardExcelDataSource1";
     this.dashboardExcelDataSource1.FileName                 = "|DataDirectory|\\Data\\Sales.xlsx";
     this.dashboardExcelDataSource1.Name                     = "Excel Data Source 1";
     this.dashboardExcelDataSource1.ResultSchemaSerializable = resources.GetString("dashboardExcelDataSource1.ResultSchemaSerializable");
     fieldInfo1.Name = "Category";
     fieldInfo1.Type = typeof(string);
     fieldInfo2.Name = "Product";
     fieldInfo2.Type = typeof(string);
     fieldInfo3.Name = "State";
     fieldInfo3.Type = typeof(string);
     fieldInfo4.Name = "UnitsSoldYTD (Sum)";
     fieldInfo4.Type = typeof(double);
     fieldInfo5.Name = "UnitsSoldYTDTarget (Sum)";
     fieldInfo5.Type = typeof(double);
     fieldInfo6.Name = "RevenueQTD (Sum)";
     fieldInfo6.Type = typeof(double);
     fieldInfo7.Name = "RevenueQTDTarget (Sum)";
     fieldInfo7.Type = typeof(double);
     fieldInfo8.Name = "RevenueYTD (Sum)";
     fieldInfo8.Type = typeof(double);
     fieldInfo9.Name = "RevenueYTDTarget (Sum)";
     fieldInfo9.Type = typeof(double);
     this.dashboardExcelDataSource1.Schema.AddRange(new DevExpress.DataAccess.Excel.FieldInfo[] {
         fieldInfo1,
         fieldInfo2,
         fieldInfo3,
         fieldInfo4,
         fieldInfo5,
         fieldInfo6,
         fieldInfo7,
         fieldInfo8,
         fieldInfo9
     });
     excelWorksheetSettings1.CellRange            = null;
     excelWorksheetSettings1.WorksheetName        = "Sheet1";
     excelSourceOptions1.ImportSettings           = excelWorksheetSettings1;
     this.dashboardExcelDataSource1.SourceOptions = excelSourceOptions1;
     //
     // gridDashboardItem1
     //
     dimension2.DataMember          = "Product";
     gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn1.AddDataItem("Dimension", dimension2);
     measure4.DataMember        = "UnitsSoldYTD (Sum)";
     measure5.DataMember        = "UnitsSoldYTDTarget (Sum)";
     gridDeltaColumn1.Name      = "UnitsSold YTD vs Target";
     gridDeltaColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDeltaColumn1.AddDataItem("ActualValue", measure4);
     gridDeltaColumn1.AddDataItem("TargetValue", measure5);
     this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
         gridDimensionColumn1,
         gridDeltaColumn1
     });
     this.gridDashboardItem1.ComponentName = "gridDashboardItem1";
     this.gridDashboardItem1.DataItemRepository.Clear();
     this.gridDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0");
     this.gridDashboardItem1.DataItemRepository.Add(measure4, "DataItem1");
     this.gridDashboardItem1.DataItemRepository.Add(measure5, "DataItem2");
     this.gridDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.gridDashboardItem1.Name        = "Product Units Sold";
     this.gridDashboardItem1.ShowCaption = true;
     //
     // chartDashboardItem1
     //
     dimension3.DataMember = "Category";
     this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension3
     });
     this.chartDashboardItem1.AxisX.TitleVisible = false;
     this.chartDashboardItem1.ComponentName      = "chartDashboardItem1";
     measure6.DataMember = "UnitsSoldYTD (Sum)";
     this.chartDashboardItem1.DataItemRepository.Clear();
     this.chartDashboardItem1.DataItemRepository.Add(dimension3, "DataItem0");
     this.chartDashboardItem1.DataItemRepository.Add(measure6, "DataItem1");
     this.chartDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.chartDashboardItem1.Name = "Chart 1";
     chartPane1.Name = "Pane 1";
     chartPane1.PrimaryAxisY.AlwaysShowZeroLevel   = true;
     chartPane1.PrimaryAxisY.ShowGridLines         = true;
     chartPane1.PrimaryAxisY.TitleVisible          = true;
     chartPane1.SecondaryAxisY.AlwaysShowZeroLevel = true;
     chartPane1.SecondaryAxisY.ShowGridLines       = false;
     chartPane1.SecondaryAxisY.TitleVisible        = true;
     simpleSeries1.AddDataItem("Value", measure6);
     chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] {
         simpleSeries1
     });
     this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] {
         chartPane1
     });
     this.chartDashboardItem1.Rotated     = true;
     this.chartDashboardItem1.ShowCaption = true;
     //
     // cardDashboardItem1
     //
     measure7.DataMember = "RevenueQTD (Sum)";
     measure8.DataMember = "RevenueQTDTarget (Sum)";
     cardStretchedLayoutTemplate1.BottomValue1.DimensionIndex = 0;
     cardStretchedLayoutTemplate1.BottomValue1.ValueType      = DevExpress.DashboardCommon.CardRowDataElementType.PercentVariation;
     cardStretchedLayoutTemplate1.BottomValue1.Visible        = true;
     cardStretchedLayoutTemplate1.BottomValue2.DimensionIndex = 0;
     cardStretchedLayoutTemplate1.BottomValue2.ValueType      = DevExpress.DashboardCommon.CardRowDataElementType.AbsoluteVariation;
     cardStretchedLayoutTemplate1.BottomValue2.Visible        = true;
     cardStretchedLayoutTemplate1.DeltaIndicator.Visible      = true;
     cardStretchedLayoutTemplate1.MainValue.DimensionIndex    = 0;
     cardStretchedLayoutTemplate1.MainValue.ValueType         = DevExpress.DashboardCommon.CardRowDataElementType.Title;
     cardStretchedLayoutTemplate1.MainValue.Visible           = true;
     cardStretchedLayoutTemplate1.Sparkline.Visible           = true;
     cardStretchedLayoutTemplate1.SubValue.DimensionIndex     = 0;
     cardStretchedLayoutTemplate1.SubValue.ValueType          = DevExpress.DashboardCommon.CardRowDataElementType.Subtitle;
     cardStretchedLayoutTemplate1.SubValue.Visible            = true;
     cardStretchedLayoutTemplate1.TopValue.DimensionIndex     = 0;
     cardStretchedLayoutTemplate1.TopValue.ValueType          = DevExpress.DashboardCommon.CardRowDataElementType.ActualValue;
     cardStretchedLayoutTemplate1.TopValue.Visible            = true;
     card1.LayoutTemplate = cardStretchedLayoutTemplate1;
     card1.AddDataItem("ActualValue", measure7);
     card1.AddDataItem("TargetValue", measure8);
     measure9.DataMember  = "RevenueYTD (Sum)";
     measure10.DataMember = "RevenueYTDTarget (Sum)";
     cardStretchedLayoutTemplate2.BottomValue1.DimensionIndex = 0;
     cardStretchedLayoutTemplate2.BottomValue1.ValueType      = DevExpress.DashboardCommon.CardRowDataElementType.PercentVariation;
     cardStretchedLayoutTemplate2.BottomValue1.Visible        = true;
     cardStretchedLayoutTemplate2.BottomValue2.DimensionIndex = 0;
     cardStretchedLayoutTemplate2.BottomValue2.ValueType      = DevExpress.DashboardCommon.CardRowDataElementType.AbsoluteVariation;
     cardStretchedLayoutTemplate2.BottomValue2.Visible        = true;
     cardStretchedLayoutTemplate2.DeltaIndicator.Visible      = true;
     cardStretchedLayoutTemplate2.MainValue.DimensionIndex    = 0;
     cardStretchedLayoutTemplate2.MainValue.ValueType         = DevExpress.DashboardCommon.CardRowDataElementType.Title;
     cardStretchedLayoutTemplate2.MainValue.Visible           = true;
     cardStretchedLayoutTemplate2.Sparkline.Visible           = true;
     cardStretchedLayoutTemplate2.SubValue.DimensionIndex     = 0;
     cardStretchedLayoutTemplate2.SubValue.ValueType          = DevExpress.DashboardCommon.CardRowDataElementType.Subtitle;
     cardStretchedLayoutTemplate2.SubValue.Visible            = true;
     cardStretchedLayoutTemplate2.TopValue.DimensionIndex     = 0;
     cardStretchedLayoutTemplate2.TopValue.ValueType          = DevExpress.DashboardCommon.CardRowDataElementType.ActualValue;
     cardStretchedLayoutTemplate2.TopValue.Visible            = true;
     card2.LayoutTemplate = cardStretchedLayoutTemplate2;
     card2.AddDataItem("ActualValue", measure9);
     card2.AddDataItem("TargetValue", measure10);
     measure11.DataMember = "UnitsSoldYTD (Sum)";
     measure12.DataMember = "UnitsSoldYTDTarget (Sum)";
     cardStretchedLayoutTemplate3.BottomValue1.DimensionIndex = 0;
     cardStretchedLayoutTemplate3.BottomValue1.ValueType      = DevExpress.DashboardCommon.CardRowDataElementType.PercentVariation;
     cardStretchedLayoutTemplate3.BottomValue1.Visible        = true;
     cardStretchedLayoutTemplate3.BottomValue2.DimensionIndex = 0;
     cardStretchedLayoutTemplate3.BottomValue2.ValueType      = DevExpress.DashboardCommon.CardRowDataElementType.AbsoluteVariation;
     cardStretchedLayoutTemplate3.BottomValue2.Visible        = true;
     cardStretchedLayoutTemplate3.DeltaIndicator.Visible      = true;
     cardStretchedLayoutTemplate3.MainValue.DimensionIndex    = 0;
     cardStretchedLayoutTemplate3.MainValue.ValueType         = DevExpress.DashboardCommon.CardRowDataElementType.Title;
     cardStretchedLayoutTemplate3.MainValue.Visible           = true;
     cardStretchedLayoutTemplate3.Sparkline.Visible           = true;
     cardStretchedLayoutTemplate3.SubValue.DimensionIndex     = 0;
     cardStretchedLayoutTemplate3.SubValue.ValueType          = DevExpress.DashboardCommon.CardRowDataElementType.Subtitle;
     cardStretchedLayoutTemplate3.SubValue.Visible            = true;
     cardStretchedLayoutTemplate3.TopValue.DimensionIndex     = 0;
     cardStretchedLayoutTemplate3.TopValue.ValueType          = DevExpress.DashboardCommon.CardRowDataElementType.ActualValue;
     cardStretchedLayoutTemplate3.TopValue.Visible            = true;
     card3.LayoutTemplate = cardStretchedLayoutTemplate3;
     card3.AddDataItem("ActualValue", measure11);
     card3.AddDataItem("TargetValue", measure12);
     this.cardDashboardItem1.Cards.AddRange(new DevExpress.DashboardCommon.Card[] {
         card1,
         card2,
         card3
     });
     this.cardDashboardItem1.ComponentName = "cardDashboardItem1";
     this.cardDashboardItem1.DataItemRepository.Clear();
     this.cardDashboardItem1.DataItemRepository.Add(measure7, "DataItem0");
     this.cardDashboardItem1.DataItemRepository.Add(measure8, "DataItem1");
     this.cardDashboardItem1.DataItemRepository.Add(measure9, "DataItem2");
     this.cardDashboardItem1.DataItemRepository.Add(measure10, "DataItem3");
     this.cardDashboardItem1.DataItemRepository.Add(measure11, "DataItem4");
     this.cardDashboardItem1.DataItemRepository.Add(measure12, "DataItem5");
     this.cardDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     this.cardDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.cardDashboardItem1.Name        = "Cards 1";
     this.cardDashboardItem1.ShowCaption = false;
     //
     // SampleDashboard
     //
     this.CurrencyCultureName = null;
     this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
         this.dashboardExcelDataSource1
     });
     this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
         this.choroplethMapDashboardItem1,
         this.gridDashboardItem1,
         this.chartDashboardItem1,
         this.cardDashboardItem1
     });
     dashboardLayoutItem1.DashboardItem = this.choroplethMapDashboardItem1;
     dashboardLayoutItem1.Weight        = 73.395721925133685D;
     dashboardLayoutItem2.DashboardItem = this.cardDashboardItem1;
     dashboardLayoutItem2.Weight        = 26.604278074866311D;
     dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem1,
         dashboardLayoutItem2
     });
     dashboardLayoutGroup2.DashboardItem = null;
     dashboardLayoutGroup2.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup2.Weight        = 62.684365781710916D;
     dashboardLayoutItem3.DashboardItem  = this.gridDashboardItem1;
     dashboardLayoutItem3.Weight         = 48.1283422459893D;
     dashboardLayoutItem4.DashboardItem  = this.chartDashboardItem1;
     dashboardLayoutItem4.Weight         = 51.8716577540107D;
     dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem3,
         dashboardLayoutItem4
     });
     dashboardLayoutGroup3.DashboardItem = null;
     dashboardLayoutGroup3.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup3.Weight        = 37.315634218289084D;
     dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutGroup2,
         dashboardLayoutGroup3
     });
     dashboardLayoutGroup1.DashboardItem = null;
     dashboardLayoutGroup1.Weight        = 100D;
     this.LayoutRoot = dashboardLayoutGroup1;
     this.Title.Text = "Sample Dashboard";
     ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.choroplethMapDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure6)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure7)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure8)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure9)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure10)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure11)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure12)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
Ejemplo n.º 2
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     DevExpress.DashboardCommon.Dimension               dimension1              = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure                 measure1                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure2                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure3                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.ValueMap                valueMap1               = new DevExpress.DashboardCommon.ValueMap();
     DevExpress.DashboardCommon.UniformScale            uniformScale1           = new DevExpress.DashboardCommon.UniformScale();
     DevExpress.DashboardCommon.DeltaMap                deltaMap1               = new DevExpress.DashboardCommon.DeltaMap();
     DevExpress.DashboardCommon.Dimension               dimension2              = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn1    = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.Measure                 measure4                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure5                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.GridDeltaColumn         gridDeltaColumn1        = new DevExpress.DashboardCommon.GridDeltaColumn();
     System.ComponentModel.ComponentResourceManager     resources               = new System.ComponentModel.ComponentResourceManager(typeof(SampleDashboard));
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo1              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo2              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo3              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo4              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo5              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo6              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo7              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo8              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo9              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.ExcelWorksheetSettings excelWorksheetSettings1 = new DevExpress.DataAccess.Excel.ExcelWorksheetSettings();
     DevExpress.DataAccess.Excel.ExcelSourceOptions     excelSourceOptions1     = new DevExpress.DataAccess.Excel.ExcelSourceOptions(excelWorksheetSettings1);
     DevExpress.DashboardCommon.DashboardLayoutGroup    dashboardLayoutGroup1   = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutItem     dashboardLayoutItem1    = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutItem     dashboardLayoutItem2    = new DevExpress.DashboardCommon.DashboardLayoutItem();
     this.choroplethMapDashboardItem1 = new DevExpress.DashboardCommon.ChoroplethMapDashboardItem();
     this.gridDashboardItem1          = new DevExpress.DashboardCommon.GridDashboardItem();
     this.dashboardExcelDataSource1   = new DevExpress.DashboardCommon.DashboardExcelDataSource();
     ((System.ComponentModel.ISupportInitialize)(this.choroplethMapDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // choroplethMapDashboardItem1
     //
     this.choroplethMapDashboardItem1.Area = DevExpress.DashboardCommon.ShapefileArea.USA;
     dimension1.DataMember = "State";
     this.choroplethMapDashboardItem1.AttributeDimension = dimension1;
     this.choroplethMapDashboardItem1.AttributeName      = "NAME";
     this.choroplethMapDashboardItem1.ComponentName      = "choroplethMapDashboardItem1";
     measure1.DataMember = "RevenueYTD (Sum)";
     measure2.DataMember = "RevenueYTD (Sum)";
     measure3.DataMember = "RevenueYTDTarget (Sum)";
     this.choroplethMapDashboardItem1.DataItemRepository.Clear();
     this.choroplethMapDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0");
     this.choroplethMapDashboardItem1.DataItemRepository.Add(measure1, "DataItem1");
     this.choroplethMapDashboardItem1.DataItemRepository.Add(measure2, "DataItem2");
     this.choroplethMapDashboardItem1.DataItemRepository.Add(measure3, "DataItem3");
     this.choroplethMapDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     this.choroplethMapDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.choroplethMapDashboardItem1.InteractivityOptions.MasterFilterMode    = DevExpress.DashboardCommon.DashboardItemMasterFilterMode.Multiple;
     valueMap1.Name      = "Revenue YTD";
     valueMap1.Scale     = uniformScale1;
     valueMap1.ValueName = "Revenue";
     valueMap1.AddDataItem("Value", measure1);
     deltaMap1.AbsoluteVariationNumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number;
     deltaMap1.AbsoluteVariationNumericFormat.Precision  = 0;
     deltaMap1.ActualValueName = "Revenue";
     deltaMap1.DeltaName       = "vs Target";
     deltaMap1.Name            = "Revenue YTD vs Target";
     deltaMap1.PercentOfTargetNumericFormat.FormatType  = DevExpress.DashboardCommon.DataItemNumericFormatType.Percent;
     deltaMap1.PercentVariationNumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Percent;
     deltaMap1.AddDataItem("ActualValue", measure2);
     deltaMap1.AddDataItem("TargetValue", measure3);
     this.choroplethMapDashboardItem1.Maps.AddRange(new DevExpress.DashboardCommon.ChoroplethMap[] {
         valueMap1,
         deltaMap1
     });
     this.choroplethMapDashboardItem1.Name = "Sales by State";
     this.choroplethMapDashboardItem1.ShapeTitleAttributeName       = "ABBREV";
     this.choroplethMapDashboardItem1.ShowCaption                   = true;
     this.choroplethMapDashboardItem1.Viewport.BottomLatitude       = 22.722765208057595D;
     this.choroplethMapDashboardItem1.Viewport.CenterPointLatitude  = 37.208247632673633D;
     this.choroplethMapDashboardItem1.Viewport.CenterPointLongitude = -95.848499902568008D;
     this.choroplethMapDashboardItem1.Viewport.LeftLongitude        = -124.70997774915153D;
     this.choroplethMapDashboardItem1.Viewport.RightLongitude       = -66.987022055984482D;
     this.choroplethMapDashboardItem1.Viewport.TopLatitude          = 49.369672064487254D;
     //
     // gridDashboardItem1
     //
     dimension2.DataMember          = "Product";
     gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn1.AddDataItem("Dimension", dimension2);
     measure4.DataMember = "UnitsSoldYTD (Sum)";
     measure5.DataMember = "UnitsSoldYTDTarget (Sum)";
     gridDeltaColumn1.AbsoluteVariationNumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number;
     gridDeltaColumn1.AbsoluteVariationNumericFormat.Precision  = 0;
     gridDeltaColumn1.Name = "UnitsSold YTD vs Target";
     gridDeltaColumn1.PercentOfTargetNumericFormat.FormatType  = DevExpress.DashboardCommon.DataItemNumericFormatType.Percent;
     gridDeltaColumn1.PercentVariationNumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Percent;
     gridDeltaColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDeltaColumn1.AddDataItem("ActualValue", measure4);
     gridDeltaColumn1.AddDataItem("TargetValue", measure5);
     this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
         gridDimensionColumn1,
         gridDeltaColumn1
     });
     this.gridDashboardItem1.ComponentName = "gridDashboardItem1";
     this.gridDashboardItem1.DataItemRepository.Clear();
     this.gridDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0");
     this.gridDashboardItem1.DataItemRepository.Add(measure4, "DataItem1");
     this.gridDashboardItem1.DataItemRepository.Add(measure5, "DataItem2");
     this.gridDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.gridDashboardItem1.Name        = "Product Units Sold";
     this.gridDashboardItem1.ShowCaption = true;
     //
     // dashboardExcelDataSource1
     //
     this.dashboardExcelDataSource1.ComponentName            = "dashboardExcelDataSource1";
     this.dashboardExcelDataSource1.FileName                 = "|DataDirectory|\\Data\\Sales.xlsx";
     this.dashboardExcelDataSource1.Name                     = "Excel Data Source 1";
     this.dashboardExcelDataSource1.ResultSchemaSerializable = resources.GetString("dashboardExcelDataSource1.ResultSchemaSerializable");
     fieldInfo1.Name = "Category";
     fieldInfo1.Type = typeof(string);
     fieldInfo2.Name = "Product";
     fieldInfo2.Type = typeof(string);
     fieldInfo3.Name = "State";
     fieldInfo3.Type = typeof(string);
     fieldInfo4.Name = "UnitsSoldYTD (Sum)";
     fieldInfo4.Type = typeof(double);
     fieldInfo5.Name = "UnitsSoldYTDTarget (Sum)";
     fieldInfo5.Type = typeof(double);
     fieldInfo6.Name = "RevenueQTD (Sum)";
     fieldInfo6.Type = typeof(double);
     fieldInfo7.Name = "RevenueQTDTarget (Sum)";
     fieldInfo7.Type = typeof(double);
     fieldInfo8.Name = "RevenueYTD (Sum)";
     fieldInfo8.Type = typeof(double);
     fieldInfo9.Name = "RevenueYTDTarget (Sum)";
     fieldInfo9.Type = typeof(double);
     this.dashboardExcelDataSource1.Schema.AddRange(new DevExpress.DataAccess.Excel.FieldInfo[] {
         fieldInfo1,
         fieldInfo2,
         fieldInfo3,
         fieldInfo4,
         fieldInfo5,
         fieldInfo6,
         fieldInfo7,
         fieldInfo8,
         fieldInfo9
     });
     excelWorksheetSettings1.CellRange            = null;
     excelWorksheetSettings1.WorksheetName        = "Sheet1";
     excelSourceOptions1.ImportSettings           = excelWorksheetSettings1;
     this.dashboardExcelDataSource1.SourceOptions = excelSourceOptions1;
     //
     // SampleDashboard
     //
     this.CurrencyCultureName = null;
     this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
         this.dashboardExcelDataSource1
     });
     this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
         this.choroplethMapDashboardItem1,
         this.gridDashboardItem1
     });
     dashboardLayoutItem1.DashboardItem = this.choroplethMapDashboardItem1;
     dashboardLayoutItem1.Weight        = 62.659846547314579D;
     dashboardLayoutItem2.DashboardItem = this.gridDashboardItem1;
     dashboardLayoutItem2.Weight        = 37.340153452685421D;
     dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem1,
         dashboardLayoutItem2
     });
     dashboardLayoutGroup1.DashboardItem = null;
     this.LayoutRoot = dashboardLayoutGroup1;
     this.Title.Text = "Sample Dashboard";
     ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.choroplethMapDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     DevExpress.DashboardCommon.Dimension               dimension1              = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure                 measure1                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure2                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure3                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.ValueMap                valueMap1               = new DevExpress.DashboardCommon.ValueMap();
     DevExpress.DashboardCommon.UniformScale            uniformScale1           = new DevExpress.DashboardCommon.UniformScale();
     DevExpress.DashboardCommon.DeltaMap                deltaMap1               = new DevExpress.DashboardCommon.DeltaMap();
     System.ComponentModel.ComponentResourceManager     resources               = new System.ComponentModel.ComponentResourceManager(typeof(SampleDashboard));
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo1              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo2              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo3              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo4              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo5              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo6              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo7              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo8              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.FieldInfo              fieldInfo9              = new DevExpress.DataAccess.Excel.FieldInfo();
     DevExpress.DataAccess.Excel.ExcelWorksheetSettings excelWorksheetSettings1 = new DevExpress.DataAccess.Excel.ExcelWorksheetSettings();
     DevExpress.DataAccess.Excel.ExcelSourceOptions     excelSourceOptions1     = new DevExpress.DataAccess.Excel.ExcelSourceOptions(excelWorksheetSettings1);
     DevExpress.DashboardCommon.Dimension               dimension2              = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn1    = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.Dimension               dimension3              = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn2    = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.Measure                 measure4                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure5                = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.GridDeltaColumn         gridDeltaColumn1        = new DevExpress.DashboardCommon.GridDeltaColumn();
     DevExpress.DashboardCommon.DashboardLayoutGroup    dashboardLayoutGroup1   = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutItem     dashboardLayoutItem1    = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutItem     dashboardLayoutItem2    = new DevExpress.DashboardCommon.DashboardLayoutItem();
     this.choroplethMapDashboardItem1 = new DevExpress.DashboardCommon.ChoroplethMapDashboardItem();
     this.dashboardExcelDataSource1   = new DevExpress.DashboardCommon.DashboardExcelDataSource();
     this.gridDashboardItem1          = new DevExpress.DashboardCommon.GridDashboardItem();
     ((System.ComponentModel.ISupportInitialize)(this.choroplethMapDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // choroplethMapDashboardItem1
     //
     this.choroplethMapDashboardItem1.Area = DevExpress.DashboardCommon.ShapefileArea.USA;
     dimension1.DataMember = "State";
     this.choroplethMapDashboardItem1.AttributeDimension = dimension1;
     this.choroplethMapDashboardItem1.AttributeName      = "NAME";
     this.choroplethMapDashboardItem1.ComponentName      = "choroplethMapDashboardItem1";
     measure1.DataMember = "RevenueYTD (Sum)";
     measure2.DataMember = "RevenueYTD (Sum)";
     measure3.DataMember = "RevenueYTDTarget (Sum)";
     this.choroplethMapDashboardItem1.DataItemRepository.Clear();
     this.choroplethMapDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0");
     this.choroplethMapDashboardItem1.DataItemRepository.Add(measure1, "DataItem1");
     this.choroplethMapDashboardItem1.DataItemRepository.Add(measure2, "DataItem2");
     this.choroplethMapDashboardItem1.DataItemRepository.Add(measure3, "DataItem3");
     this.choroplethMapDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     this.choroplethMapDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.choroplethMapDashboardItem1.InteractivityOptions.MasterFilterMode    = DevExpress.DashboardCommon.DashboardItemMasterFilterMode.Multiple;
     valueMap1.Name      = "Revenue YTD";
     valueMap1.Scale     = uniformScale1;
     valueMap1.ValueName = "Revenue";
     valueMap1.AddDataItem("Value", measure1);
     deltaMap1.ActualValueName = "Revenue";
     deltaMap1.DeltaName       = "vs Target";
     deltaMap1.Name            = "Revenue YTD vs Target";
     deltaMap1.AddDataItem("ActualValue", measure2);
     deltaMap1.AddDataItem("TargetValue", measure3);
     this.choroplethMapDashboardItem1.Maps.AddRange(new DevExpress.DashboardCommon.ChoroplethMap[] {
         valueMap1,
         deltaMap1
     });
     this.choroplethMapDashboardItem1.Name = "Sales by State";
     this.choroplethMapDashboardItem1.ShapeTitleAttributeName       = "ABBREV";
     this.choroplethMapDashboardItem1.ShowCaption                   = true;
     this.choroplethMapDashboardItem1.Viewport.BottomLatitude       = 25.31399686804809D;
     this.choroplethMapDashboardItem1.Viewport.CenterPointLatitude  = 37.298652216525717D;
     this.choroplethMapDashboardItem1.Viewport.CenterPointLongitude = -99.1736207753099D;
     this.choroplethMapDashboardItem1.Viewport.CreateViewerPaddings = false;
     this.choroplethMapDashboardItem1.Viewport.LeftLongitude        = -114.64010379808356D;
     this.choroplethMapDashboardItem1.Viewport.RightLongitude       = -83.707137752536212D;
     this.choroplethMapDashboardItem1.Viewport.TopLatitude          = 47.640614567674412D;
     //
     // dashboardExcelDataSource1
     //
     this.dashboardExcelDataSource1.ComponentName            = "dashboardExcelDataSource1";
     this.dashboardExcelDataSource1.FileName                 = "|DataDirectory|\\Data\\Sales.xlsx";
     this.dashboardExcelDataSource1.Name                     = "Excel Data Source 1";
     this.dashboardExcelDataSource1.ResultSchemaSerializable = resources.GetString("dashboardExcelDataSource1.ResultSchemaSerializable");
     fieldInfo1.Name = "Category";
     fieldInfo1.Type = typeof(string);
     fieldInfo2.Name = "Product";
     fieldInfo2.Type = typeof(string);
     fieldInfo3.Name = "State";
     fieldInfo3.Type = typeof(string);
     fieldInfo4.Name = "UnitsSoldYTD (Sum)";
     fieldInfo4.Type = typeof(double);
     fieldInfo5.Name = "UnitsSoldYTDTarget (Sum)";
     fieldInfo5.Type = typeof(double);
     fieldInfo6.Name = "RevenueQTD (Sum)";
     fieldInfo6.Type = typeof(double);
     fieldInfo7.Name = "RevenueQTDTarget (Sum)";
     fieldInfo7.Type = typeof(double);
     fieldInfo8.Name = "RevenueYTD (Sum)";
     fieldInfo8.Type = typeof(double);
     fieldInfo9.Name = "RevenueYTDTarget (Sum)";
     fieldInfo9.Type = typeof(double);
     this.dashboardExcelDataSource1.Schema.AddRange(new DevExpress.DataAccess.Excel.FieldInfo[] {
         fieldInfo1,
         fieldInfo2,
         fieldInfo3,
         fieldInfo4,
         fieldInfo5,
         fieldInfo6,
         fieldInfo7,
         fieldInfo8,
         fieldInfo9
     });
     excelWorksheetSettings1.CellRange            = null;
     excelWorksheetSettings1.WorksheetName        = "Sheet1";
     excelSourceOptions1.ImportSettings           = excelWorksheetSettings1;
     this.dashboardExcelDataSource1.SourceOptions = excelSourceOptions1;
     //
     // gridDashboardItem1
     //
     dimension2.DataMember          = "Category";
     gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn1.AddDataItem("Dimension", dimension2);
     dimension3.DataMember          = "Product";
     gridDimensionColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn2.AddDataItem("Dimension", dimension3);
     measure4.DataMember        = "UnitsSoldYTD (Sum)";
     measure5.DataMember        = "UnitsSoldYTDTarget (Sum)";
     gridDeltaColumn1.Name      = "UnitsSold YTD vs Target";
     gridDeltaColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDeltaColumn1.AddDataItem("ActualValue", measure4);
     gridDeltaColumn1.AddDataItem("TargetValue", measure5);
     this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
         gridDimensionColumn1,
         gridDimensionColumn2,
         gridDeltaColumn1
     });
     this.gridDashboardItem1.ComponentName = "gridDashboardItem1";
     this.gridDashboardItem1.DataItemRepository.Clear();
     this.gridDashboardItem1.DataItemRepository.Add(dimension3, "DataItem0");
     this.gridDashboardItem1.DataItemRepository.Add(measure4, "DataItem1");
     this.gridDashboardItem1.DataItemRepository.Add(measure5, "DataItem2");
     this.gridDashboardItem1.DataItemRepository.Add(dimension2, "DataItem3");
     this.gridDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.gridDashboardItem1.Name        = "Product Units Sold";
     this.gridDashboardItem1.ShowCaption = true;
     //
     // SampleDashboard
     //
     this.CurrencyCultureName = null;
     this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
         this.dashboardExcelDataSource1
     });
     this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
         this.choroplethMapDashboardItem1,
         this.gridDashboardItem1
     });
     dashboardLayoutItem1.DashboardItem = this.choroplethMapDashboardItem1;
     dashboardLayoutItem1.Weight        = 53.152039555006183D;
     dashboardLayoutItem2.DashboardItem = this.gridDashboardItem1;
     dashboardLayoutItem2.Weight        = 46.847960444993817D;
     dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem1,
         dashboardLayoutItem2
     });
     dashboardLayoutGroup1.DashboardItem = null;
     dashboardLayoutGroup1.Weight        = 100D;
     this.LayoutRoot = dashboardLayoutGroup1;
     this.Title.Text = "Sample Dashboard";
     ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.choroplethMapDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }