/// <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(); }
/// <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(); }