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