/// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     DevExpress.DataAccess.EntityFramework.EFConnectionParameters efConnectionParameters1 = new DevExpress.DataAccess.EntityFramework.EFConnectionParameters();
     DevExpress.DashboardCommon.Dimension               dimension1               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure                 measure1                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Dimension               dimension2               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure                 measure2                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Dimension               dimension3               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Dimension               dimension4               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure                 measure3                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Dimension               dimension5               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Dimension               dimension6               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Dimension               dimension7               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod1          = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit1 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit2 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod2          = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit3 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit4 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod3          = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit5 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit6 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod4          = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit7 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit8 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.Dimension               dimension8               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure                 measure4                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure5                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure6                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Measure                 measure7                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.Card card1 = new DevExpress.DashboardCommon.Card();
     DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate1 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate();
     DevExpress.DashboardCommon.Dimension            dimension9            = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Dimension            dimension10           = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Dimension            dimension11           = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure              measure8              = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.ChartPane            chartPane1            = new DevExpress.DashboardCommon.ChartPane();
     DevExpress.DashboardCommon.SimpleSeries         simpleSeries1         = new DevExpress.DashboardCommon.SimpleSeries();
     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.DashboardLayoutItem  dashboardLayoutItem3  = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup4 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutItem  dashboardLayoutItem4  = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutItem  dashboardLayoutItem5  = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup5 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutItem  dashboardLayoutItem6  = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutItem  dashboardLayoutItem7  = new DevExpress.DashboardCommon.DashboardLayoutItem();
     this.dashboardEFDataSource1     = new DevExpress.DashboardCommon.DashboardEFDataSource();
     this.pieDashboardItem2          = new DevExpress.DashboardCommon.PieDashboardItem();
     this.pieDashboardItem3          = new DevExpress.DashboardCommon.PieDashboardItem();
     this.pivotDashboardItem1        = new DevExpress.DashboardCommon.PivotDashboardItem();
     this.dateFilterDashboardItem1   = new DevExpress.DashboardCommon.DateFilterDashboardItem();
     this.scatterChartDashboardItem1 = new DevExpress.DashboardCommon.ScatterChartDashboardItem();
     this.cardDashboardItem1         = new DevExpress.DashboardCommon.CardDashboardItem();
     this.chartDashboardItem1        = new DevExpress.DashboardCommon.ChartDashboardItem();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardEFDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dateFilterDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension7)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.scatterChartDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension8)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure6)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure7)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension9)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension10)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension11)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure8)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // dashboardEFDataSource1
     //
     this.dashboardEFDataSource1.ComponentName    = "dashboardEFDataSource1";
     efConnectionParameters1.ConnectionString     = "";
     efConnectionParameters1.ConnectionStringName = "EntitiesDataModel";
     efConnectionParameters1.Source = typeof(TypicalSouthernFoods.Web.Persistence.EntitiesDataModel);
     this.dashboardEFDataSource1.ConnectionParameters = efConnectionParameters1;
     this.dashboardEFDataSource1.Name = "EF Data Source 1";
     //
     // pieDashboardItem2
     //
     dimension1.DataMember = "INVOICE.WAITER.NAMES";
     this.pieDashboardItem2.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension1
     });
     this.pieDashboardItem2.ComponentName = "pieDashboardItem2";
     measure1.DataMember  = "INVOICE.ID";
     measure1.Name        = "Invoices (Count)";
     measure1.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
     this.pieDashboardItem2.DataItemRepository.Clear();
     this.pieDashboardItem2.DataItemRepository.Add(dimension1, "DataItem0");
     this.pieDashboardItem2.DataItemRepository.Add(measure1, "DataItem1");
     this.pieDashboardItem2.DataMember = "INVOICES_DET";
     this.pieDashboardItem2.DataSource = this.dashboardEFDataSource1;
     this.pieDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false;
     this.pieDashboardItem2.Name        = "% Orders by Waiter";
     this.pieDashboardItem2.ShowCaption = true;
     this.pieDashboardItem2.Values.AddRange(new DevExpress.DashboardCommon.Measure[] {
         measure1
     });
     //
     // pieDashboardItem3
     //
     dimension2.DataMember = "RECIPE_NAME";
     this.pieDashboardItem3.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension2
     });
     this.pieDashboardItem3.ComponentName = "pieDashboardItem3";
     measure2.DataMember  = "ID";
     measure2.Name        = "Recipes (Count)";
     measure2.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
     this.pieDashboardItem3.DataItemRepository.Clear();
     this.pieDashboardItem3.DataItemRepository.Add(measure2, "DataItem1");
     this.pieDashboardItem3.DataItemRepository.Add(dimension2, "DataItem0");
     this.pieDashboardItem3.DataMember = "INVOICES_DET";
     this.pieDashboardItem3.DataSource = this.dashboardEFDataSource1;
     this.pieDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false;
     this.pieDashboardItem3.Name        = "% Recipes Served";
     this.pieDashboardItem3.ShowCaption = true;
     this.pieDashboardItem3.Values.AddRange(new DevExpress.DashboardCommon.Measure[] {
         measure2
     });
     //
     // pivotDashboardItem1
     //
     dimension3.DataMember            = "INVOICE.INVOICE_DATE";
     dimension4.DataMember            = "INVOICE.INVOICE_DATE";
     dimension4.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.Month;
     this.pivotDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension3,
         dimension4
     });
     this.pivotDashboardItem1.ComponentName = "pivotDashboardItem1";
     measure3.DataMember   = "PRICE";
     measure3.Name         = "Sales (Sum)";
     dimension5.DataMember = "RECIPE_NAME";
     dimension6.DataMember = "INVOICE.CLIENT.NAMES";
     this.pivotDashboardItem1.DataItemRepository.Clear();
     this.pivotDashboardItem1.DataItemRepository.Add(dimension3, "DataItem0");
     this.pivotDashboardItem1.DataItemRepository.Add(measure3, "DataItem1");
     this.pivotDashboardItem1.DataItemRepository.Add(dimension4, "DataItem2");
     this.pivotDashboardItem1.DataItemRepository.Add(dimension5, "DataItem3");
     this.pivotDashboardItem1.DataItemRepository.Add(dimension6, "DataItem4");
     this.pivotDashboardItem1.DataMember = "INVOICES_DET";
     this.pivotDashboardItem1.DataSource = this.dashboardEFDataSource1;
     this.pivotDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.pivotDashboardItem1.Name = "Pivot Sales and Clients";
     this.pivotDashboardItem1.Rows.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension5,
         dimension6
     });
     this.pivotDashboardItem1.ShowCaption = true;
     this.pivotDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] {
         measure3
     });
     //
     // dateFilterDashboardItem1
     //
     this.dateFilterDashboardItem1.ComponentName = "dateFilterDashboardItem1";
     dimension7.DataMember = "INVOICE.INVOICE_DATE";
     this.dateFilterDashboardItem1.DataItemRepository.Clear();
     this.dateFilterDashboardItem1.DataItemRepository.Add(dimension7, "DataItem0");
     this.dateFilterDashboardItem1.DataMember = "INVOICES_DET";
     this.dateFilterDashboardItem1.DataSource = this.dashboardEFDataSource1;
     flowDateTimePeriodLimit1.Offset          = 1;
     dateTimePeriod1.End             = flowDateTimePeriodLimit1;
     dateTimePeriod1.Name            = "This Year";
     dateTimePeriod1.Start           = flowDateTimePeriodLimit2;
     dateTimePeriod2.End             = flowDateTimePeriodLimit3;
     dateTimePeriod2.Name            = "Last Year";
     flowDateTimePeriodLimit4.Offset = -1;
     dateTimePeriod2.Start           = flowDateTimePeriodLimit4;
     dateTimePeriod3.End             = flowDateTimePeriodLimit5;
     dateTimePeriod3.Name            = "Last 2 Years";
     flowDateTimePeriodLimit6.Offset = -2;
     dateTimePeriod3.Start           = flowDateTimePeriodLimit6;
     dateTimePeriod4.End             = flowDateTimePeriodLimit7;
     dateTimePeriod4.Name            = "Last 3 Years";
     flowDateTimePeriodLimit8.Offset = -3;
     dateTimePeriod4.Start           = flowDateTimePeriodLimit8;
     this.dateFilterDashboardItem1.DateTimePeriods.AddRange(new DevExpress.DashboardCommon.DateTimePeriod[] {
         dateTimePeriod1,
         dateTimePeriod2,
         dateTimePeriod3,
         dateTimePeriod4
     });
     this.dateFilterDashboardItem1.DefaultDateTimePeriodName = "This Year";
     this.dateFilterDashboardItem1.Dimension = dimension7;
     this.dateFilterDashboardItem1.IsMasterFilterCrossDataSource = true;
     this.dateFilterDashboardItem1.Name        = "Date Filter";
     this.dateFilterDashboardItem1.ShowCaption = true;
     //
     // scatterChartDashboardItem1
     //
     dimension8.DataMember = "INVOICE.TABLE.NAME";
     this.scatterChartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension8
     });
     this.scatterChartDashboardItem1.AxisX.AlwaysShowZeroLevel = false;
     this.scatterChartDashboardItem1.AxisX.ShowGridLines       = true;
     this.scatterChartDashboardItem1.AxisX.TitleVisible        = true;
     measure4.DataMember  = "INVOICE.ID_TABLE";
     measure4.Name        = "TABLE (Count)";
     measure4.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
     this.scatterChartDashboardItem1.AxisXMeasure = measure4;
     this.scatterChartDashboardItem1.AxisY.AlwaysShowZeroLevel = false;
     this.scatterChartDashboardItem1.AxisY.ShowGridLines       = true;
     this.scatterChartDashboardItem1.AxisY.TitleVisible        = true;
     measure5.DataMember  = "INVOICE.INVOICE_DATE";
     measure5.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
     this.scatterChartDashboardItem1.AxisYMeasure  = measure5;
     this.scatterChartDashboardItem1.ComponentName = "scatterChartDashboardItem1";
     measure6.DataMember = "PRICE";
     this.scatterChartDashboardItem1.DataItemRepository.Clear();
     this.scatterChartDashboardItem1.DataItemRepository.Add(dimension8, "DataItem0");
     this.scatterChartDashboardItem1.DataItemRepository.Add(measure6, "DataItem1");
     this.scatterChartDashboardItem1.DataItemRepository.Add(measure5, "DataItem2");
     this.scatterChartDashboardItem1.DataItemRepository.Add(measure4, "DataItem3");
     this.scatterChartDashboardItem1.DataMember = "INVOICES_DET";
     this.scatterChartDashboardItem1.DataSource = this.dashboardEFDataSource1;
     this.scatterChartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.scatterChartDashboardItem1.Name        = "Scatter Chart Sales by Table";
     this.scatterChartDashboardItem1.ShowCaption = true;
     this.scatterChartDashboardItem1.Weight      = measure6;
     //
     // cardDashboardItem1
     //
     measure7.DataMember  = "ID";
     measure7.Name        = "Recipe (Count)";
     measure7.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
     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);
     this.cardDashboardItem1.Cards.AddRange(new DevExpress.DashboardCommon.Card[] {
         card1
     });
     this.cardDashboardItem1.ComponentName = "cardDashboardItem1";
     dimension9.DataMember  = "RECIPE_NAME";
     dimension10.DataMember = "INVOICE.WAITER.NAMES";
     this.cardDashboardItem1.DataItemRepository.Clear();
     this.cardDashboardItem1.DataItemRepository.Add(dimension9, "DataItem0");
     this.cardDashboardItem1.DataItemRepository.Add(measure7, "DataItem1");
     this.cardDashboardItem1.DataItemRepository.Add(dimension10, "DataItem2");
     this.cardDashboardItem1.DataMember = "INVOICES_DET";
     this.cardDashboardItem1.DataSource = this.dashboardEFDataSource1;
     this.cardDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.cardDashboardItem1.Name = "Top Recipes Sold";
     this.cardDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension9,
         dimension10
     });
     this.cardDashboardItem1.ShowCaption = true;
     //
     // chartDashboardItem1
     //
     dimension11.DataMember = "INVOICE.WAITER.NAMES";
     this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension11
     });
     this.chartDashboardItem1.AxisX.TitleVisible = false;
     this.chartDashboardItem1.ComponentName      = "chartDashboardItem1";
     measure8.DataMember = "PRICE";
     measure8.Name       = "Sales (Sum)";
     this.chartDashboardItem1.DataItemRepository.Clear();
     this.chartDashboardItem1.DataItemRepository.Add(dimension11, "DataItem0");
     this.chartDashboardItem1.DataItemRepository.Add(measure8, "DataItem1");
     this.chartDashboardItem1.DataMember = "INVOICES_DET";
     this.chartDashboardItem1.DataSource = this.dashboardEFDataSource1;
     this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.chartDashboardItem1.Name = "Sales by Waiter  ";
     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.PlotOnSecondaryAxis                 = true;
     simpleSeries1.PointLabelOptions.ContentType       = DevExpress.DashboardCommon.PointLabelContentTypeEx.Value;
     simpleSeries1.PointLabelOptions.Orientation       = DevExpress.DashboardCommon.PointLabelOrientation.RotateLeft;
     simpleSeries1.PointLabelOptions.OverlappingMode   = DevExpress.DashboardCommon.PointLabelOverlappingMode.Reposition;
     simpleSeries1.PointLabelOptions.Position          = DevExpress.DashboardCommon.PointLabelPosition.Inside;
     simpleSeries1.PointLabelOptions.ShowForZeroValues = true;
     simpleSeries1.AddDataItem("Value", measure8);
     chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] {
         simpleSeries1
     });
     this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] {
         chartPane1
     });
     this.chartDashboardItem1.ShowCaption = true;
     //
     // DashboardMain
     //
     this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
         this.dashboardEFDataSource1
     });
     this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
         this.dateFilterDashboardItem1,
         this.pivotDashboardItem1,
         this.chartDashboardItem1,
         this.pieDashboardItem2,
         this.pieDashboardItem3,
         this.cardDashboardItem1,
         this.scatterChartDashboardItem1
     });
     dashboardLayoutItem1.DashboardItem = this.chartDashboardItem1;
     dashboardLayoutItem1.Weight        = 32.604562737642588D;
     dashboardLayoutItem2.DashboardItem = this.pieDashboardItem2;
     dashboardLayoutItem2.Weight        = 32.224334600760457D;
     dashboardLayoutItem3.DashboardItem = this.pieDashboardItem3;
     dashboardLayoutItem3.Weight        = 35.171102661596962D;
     dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem1,
         dashboardLayoutItem2,
         dashboardLayoutItem3
     });
     dashboardLayoutGroup2.DashboardItem = null;
     dashboardLayoutGroup2.Weight        = 29.553679131483715D;
     dashboardLayoutItem4.DashboardItem  = this.cardDashboardItem1;
     dashboardLayoutItem4.Weight         = 52.376425855513311D;
     dashboardLayoutItem5.DashboardItem  = this.scatterChartDashboardItem1;
     dashboardLayoutItem5.Weight         = 47.623574144486689D;
     dashboardLayoutGroup4.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem4,
         dashboardLayoutItem5
     });
     dashboardLayoutGroup4.DashboardItem = null;
     dashboardLayoutGroup4.Weight        = 39.897260273972606D;
     dashboardLayoutItem6.DashboardItem  = this.pivotDashboardItem1;
     dashboardLayoutItem6.Weight         = 76.638176638176631D;
     dashboardLayoutItem7.DashboardItem  = this.dateFilterDashboardItem1;
     dashboardLayoutItem7.Weight         = 23.361823361823362D;
     dashboardLayoutGroup5.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem6,
         dashboardLayoutItem7
     });
     dashboardLayoutGroup5.DashboardItem = null;
     dashboardLayoutGroup5.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup5.Weight        = 60.102739726027394D;
     dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutGroup4,
         dashboardLayoutGroup5
     });
     dashboardLayoutGroup3.DashboardItem = null;
     dashboardLayoutGroup3.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup3.Weight        = 70.446320868516281D;
     dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutGroup2,
         dashboardLayoutGroup3
     });
     dashboardLayoutGroup1.DashboardItem = null;
     dashboardLayoutGroup1.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup1.Weight        = 100D;
     this.LayoutRoot = dashboardLayoutGroup1;
     this.Title.Text = "Dashboard";
     ((System.ComponentModel.ISupportInitialize)(this.dashboardEFDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension7)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dateFilterDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension8)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure6)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.scatterChartDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure7)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension9)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension10)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension11)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure8)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).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.DateTimePeriod          dateTimePeriod1           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit1  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit2  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod2           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit3  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit4  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod3           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit5  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit6  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod4           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit7  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit8  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod5           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit9  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit10 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod6           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit11 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit12 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod7           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit13 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit14 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.SimpleSeries            simpleSeries1             = new DevExpress.DashboardCommon.SimpleSeries();
     DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters msSqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters();
     DevExpress.DataAccess.Sql.SelectQuery              selectQuery1       = new DevExpress.DataAccess.Sql.SelectQuery();
     DevExpress.DataAccess.Sql.Column                   column1            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression1  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                    table1             = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column                   column2            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression2  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                    table2             = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column                   column3            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression3  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column4            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression4  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column5            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression5  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column6            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression6  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column7            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression7  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column8            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression8  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                    table3             = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column                   column9            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression9  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column10           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Join                     join1 = new DevExpress.DataAccess.Sql.Join();
     DevExpress.DataAccess.Sql.RelationColumnInfo       relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
     DevExpress.DataAccess.Sql.Join                     join2 = new DevExpress.DataAccess.Sql.Join();
     DevExpress.DataAccess.Sql.RelationColumnInfo       relationColumnInfo2      = new DevExpress.DataAccess.Sql.RelationColumnInfo();
     System.ComponentModel.ComponentResourceManager     resources                = new System.ComponentModel.ComponentResourceManager(typeof(Report_TienConLaiCC));
     DevExpress.DashboardCommon.Dimension               dimension2               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn1     = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.GridColumnTotal         gridColumnTotal1         = new DevExpress.DashboardCommon.GridColumnTotal();
     DevExpress.DashboardCommon.Dimension               dimension3               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn2     = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.Measure                 measure2                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.GridMeasureColumn       gridMeasureColumn1       = new DevExpress.DashboardCommon.GridMeasureColumn();
     DevExpress.DashboardCommon.GridItemFormatRule      gridItemFormatRule1      = new DevExpress.DashboardCommon.GridItemFormatRule();
     DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet1 = new DevExpress.DashboardCommon.FormatConditionRangeSet();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo1               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings1            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo2               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings2            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo3               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings3            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo4               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings4            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.Dimension               dimension4               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn3     = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.GridColumnTotal         gridColumnTotal2         = new DevExpress.DashboardCommon.GridColumnTotal();
     DevExpress.DashboardCommon.Dimension               dimension5               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn4     = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.Measure                 measure3                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.GridMeasureColumn       gridMeasureColumn2       = new DevExpress.DashboardCommon.GridMeasureColumn();
     DevExpress.DashboardCommon.GridItemFormatRule      gridItemFormatRule2      = new DevExpress.DashboardCommon.GridItemFormatRule();
     DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet2 = new DevExpress.DashboardCommon.FormatConditionRangeSet();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo5               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings5            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo6               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings6            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo7               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings7            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.Dimension               dimension6               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn5     = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.Measure                 measure4                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.GridMeasureColumn       gridMeasureColumn3       = new DevExpress.DashboardCommon.GridMeasureColumn();
     DevExpress.DashboardCommon.GridItemFormatRule      gridItemFormatRule3      = new DevExpress.DashboardCommon.GridItemFormatRule();
     DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet3 = new DevExpress.DashboardCommon.FormatConditionRangeSet();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo8               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings8            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo9               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings9            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo10              = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings10           = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo11              = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings11           = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.DashboardLayoutGroup    dashboardLayoutGroup1    = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutItem     dashboardLayoutItem1     = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutGroup    dashboardLayoutGroup2    = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     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.rangeFilterDashboardItem1 = new DevExpress.DashboardCommon.RangeFilterDashboardItem();
     this.dashboardSqlDataSource1   = new DevExpress.DashboardCommon.DashboardSqlDataSource();
     this.gridDashboardItem1        = new DevExpress.DashboardCommon.GridDashboardItem();
     this.gridDashboardItem2        = new DevExpress.DashboardCommon.GridDashboardItem();
     this.gridDashboardItem3        = new DevExpress.DashboardCommon.GridDashboardItem();
     ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // rangeFilterDashboardItem1
     //
     dimension1.DataMember = "ngaytaodt";
     dimension1.DateTimeFormat.ExactDateFormat = DevExpress.DashboardCommon.ExactDateFormat.Month;
     dimension1.DateTimeGroupInterval          = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
     measure1.DataMember                          = "tienconlaitheoca";
     dimension1.TopNOptions.Measure               = measure1;
     this.rangeFilterDashboardItem1.Argument      = dimension1;
     this.rangeFilterDashboardItem1.ComponentName = "rangeFilterDashboardItem1";
     this.rangeFilterDashboardItem1.DataItemRepository.Clear();
     this.rangeFilterDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2");
     this.rangeFilterDashboardItem1.DataItemRepository.Add(measure1, "DataItem0");
     this.rangeFilterDashboardItem1.DataMember = "DoanhThu";
     this.rangeFilterDashboardItem1.DataSource = this.dashboardSqlDataSource1;
     flowDateTimePeriodLimit1.Interval         = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit1.Offset           = 1;
     dateTimePeriod1.End  = flowDateTimePeriodLimit1;
     dateTimePeriod1.Name = "This Month";
     flowDateTimePeriodLimit2.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod1.Start             = flowDateTimePeriodLimit2;
     flowDateTimePeriodLimit3.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod2.End  = flowDateTimePeriodLimit3;
     dateTimePeriod2.Name = "Last Month";
     flowDateTimePeriodLimit4.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit4.Offset   = -1;
     dateTimePeriod2.Start             = flowDateTimePeriodLimit4;
     flowDateTimePeriodLimit5.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod3.End  = flowDateTimePeriodLimit5;
     dateTimePeriod3.Name = "Last 3 Months";
     flowDateTimePeriodLimit6.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit6.Offset   = -3;
     dateTimePeriod3.Start             = flowDateTimePeriodLimit6;
     flowDateTimePeriodLimit7.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod4.End  = flowDateTimePeriodLimit7;
     dateTimePeriod4.Name = "Last 6 Months";
     flowDateTimePeriodLimit8.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit8.Offset   = -6;
     dateTimePeriod4.Start             = flowDateTimePeriodLimit8;
     flowDateTimePeriodLimit9.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod5.End  = flowDateTimePeriodLimit9;
     dateTimePeriod5.Name = "Last 12 Months";
     flowDateTimePeriodLimit10.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit10.Offset   = -12;
     dateTimePeriod5.Start            = flowDateTimePeriodLimit10;
     dateTimePeriod6.End              = flowDateTimePeriodLimit11;
     dateTimePeriod6.Name             = "Last Year";
     flowDateTimePeriodLimit12.Offset = -1;
     dateTimePeriod6.Start            = flowDateTimePeriodLimit12;
     dateTimePeriod7.End              = flowDateTimePeriodLimit13;
     dateTimePeriod7.Name             = "Last 2 Years";
     flowDateTimePeriodLimit14.Offset = -2;
     dateTimePeriod7.Start            = flowDateTimePeriodLimit14;
     this.rangeFilterDashboardItem1.DateTimePeriods.AddRange(new DevExpress.DashboardCommon.DateTimePeriod[] {
         dateTimePeriod1,
         dateTimePeriod2,
         dateTimePeriod3,
         dateTimePeriod4,
         dateTimePeriod5,
         dateTimePeriod6,
         dateTimePeriod7
     });
     this.rangeFilterDashboardItem1.DefaultDateTimePeriodName = "This Month";
     this.rangeFilterDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true;
     this.rangeFilterDashboardItem1.Name = "Filter theo tháng năm";
     simpleSeries1.SeriesType            = DevExpress.DashboardCommon.SimpleSeriesType.StackedBar;
     simpleSeries1.AddDataItem("Value", measure1);
     this.rangeFilterDashboardItem1.Series.AddRange(new DevExpress.DashboardCommon.SimpleSeries[] {
         simpleSeries1
     });
     this.rangeFilterDashboardItem1.ShowCaption = true;
     //
     // dashboardSqlDataSource1
     //
     this.dashboardSqlDataSource1.ComponentName        = "dashboardSqlDataSource1";
     this.dashboardSqlDataSource1.ConnectionName       = "localhost_BaoCaoThuChi_Connection";
     msSqlConnectionParameters1.AuthorizationType      = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.Windows;
     msSqlConnectionParameters1.DatabaseName           = "BaoCaoThuChi";
     msSqlConnectionParameters1.ServerName             = ".";
     this.dashboardSqlDataSource1.ConnectionParameters = msSqlConnectionParameters1;
     this.dashboardSqlDataSource1.Name = "SQL Data Source 1";
     columnExpression1.ColumnName      = "ngaytaodt";
     table1.MetaSerializable           = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"110\" />";
     table1.Name                   = "DoanhThu";
     columnExpression1.Table       = table1;
     column1.Expression            = columnExpression1;
     columnExpression2.ColumnName  = "caID";
     table2.MetaSerializable       = "<Meta X=\"185\" Y=\"30\" Width=\"125\" Height=\"194\" />";
     table2.Name                   = "DoanhThuTheoCa";
     columnExpression2.Table       = table2;
     column2.Expression            = columnExpression2;
     columnExpression3.ColumnName  = "tenCa";
     columnExpression3.Table       = table2;
     column3.Expression            = columnExpression3;
     columnExpression4.ColumnName  = "tiendelai";
     columnExpression4.Table       = table2;
     column4.Expression            = columnExpression4;
     columnExpression5.ColumnName  = "doanhthutheoca";
     columnExpression5.Table       = table2;
     column5.Expression            = columnExpression5;
     columnExpression6.ColumnName  = "doanhthukhac";
     columnExpression6.Table       = table2;
     column6.Expression            = columnExpression6;
     columnExpression7.ColumnName  = "doanhthuID";
     columnExpression7.Table       = table1;
     column7.Expression            = columnExpression7;
     columnExpression8.ColumnName  = "tienconlaitheoca";
     table3.MetaSerializable       = "<Meta X=\"340\" Y=\"30\" Width=\"125\" Height=\"131\" />";
     table3.Name                   = "TienConLaiTheoCa";
     columnExpression8.Table       = table3;
     column8.Expression            = columnExpression8;
     column9.Alias                 = "TienConLaiTheoCa_caID";
     columnExpression9.ColumnName  = "caID";
     columnExpression9.Table       = table3;
     column9.Expression            = columnExpression9;
     columnExpression10.ColumnName = "tlID";
     columnExpression10.Table      = table3;
     column10.Expression           = columnExpression10;
     selectQuery1.Columns.Add(column1);
     selectQuery1.Columns.Add(column2);
     selectQuery1.Columns.Add(column3);
     selectQuery1.Columns.Add(column4);
     selectQuery1.Columns.Add(column5);
     selectQuery1.Columns.Add(column6);
     selectQuery1.Columns.Add(column7);
     selectQuery1.Columns.Add(column8);
     selectQuery1.Columns.Add(column9);
     selectQuery1.Columns.Add(column10);
     selectQuery1.Name = "DoanhThu";
     relationColumnInfo1.NestedKeyColumn = "doanhthuID";
     relationColumnInfo1.ParentKeyColumn = "doanhthuID";
     join1.KeyColumns.Add(relationColumnInfo1);
     join1.Nested = table2;
     join1.Parent = table1;
     relationColumnInfo2.NestedKeyColumn = "caID";
     relationColumnInfo2.ParentKeyColumn = "caID";
     join2.KeyColumns.Add(relationColumnInfo2);
     join2.Nested = table3;
     join2.Parent = table2;
     selectQuery1.Relations.Add(join1);
     selectQuery1.Relations.Add(join2);
     selectQuery1.Tables.Add(table1);
     selectQuery1.Tables.Add(table2);
     selectQuery1.Tables.Add(table3);
     this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         selectQuery1
     });
     this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable");
     //
     // gridDashboardItem1
     //
     dimension2.DataMember            = "ngaytaodt";
     dimension2.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
     dimension2.SortOrder             = DevExpress.DashboardCommon.DimensionSortOrder.Descending;
     gridDimensionColumn1.Name        = "Ngày";
     gridDimensionColumn1.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] {
         gridColumnTotal1
     });
     gridDimensionColumn1.Weight    = 51.772793053545584D;
     gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn1.AddDataItem("Dimension", dimension2);
     dimension3.DataMember          = "tenCa";
     gridDimensionColumn2.Name      = "Tên Ca";
     gridDimensionColumn2.Weight    = 59.261939218523878D;
     gridDimensionColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn2.AddDataItem("Dimension", dimension3);
     measure2.DataMember = "tienconlaitheoca";
     measure2.NumericFormat.CurrencyCultureName = "vi-VN";
     measure2.NumericFormat.FormatType          = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency;
     gridMeasureColumn1.Name      = "Số Tiền Cuối Ca";
     gridMeasureColumn1.Weight    = 113.96526772793054D;
     gridMeasureColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridMeasureColumn1.AddDataItem("Measure", measure2);
     this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
         gridDimensionColumn1,
         gridDimensionColumn2,
         gridMeasureColumn1
     });
     this.gridDashboardItem1.ComponentName = "gridDashboardItem1";
     this.gridDashboardItem1.DataItemRepository.Clear();
     this.gridDashboardItem1.DataItemRepository.Add(dimension3, "DataItem1");
     this.gridDashboardItem1.DataItemRepository.Add(measure2, "DataItem2");
     this.gridDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0");
     this.gridDashboardItem1.DataMember = "DoanhThu";
     this.gridDashboardItem1.DataSource = this.dashboardSqlDataSource1;
     iconSettings1.IconType             = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow;
     rangeInfo1.StyleSettings           = iconSettings1;
     rangeInfo1.Value         = 0D;
     iconSettings2.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow;
     rangeInfo2.StyleSettings = iconSettings2;
     rangeInfo2.Value         = 25D;
     iconSettings3.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow;
     rangeInfo3.StyleSettings = iconSettings3;
     rangeInfo3.Value         = 50D;
     iconSettings4.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp;
     rangeInfo4.StyleSettings = iconSettings4;
     rangeInfo4.Value         = 75D;
     formatConditionRangeSet1.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] {
         rangeInfo1,
         rangeInfo2,
         rangeInfo3,
         rangeInfo4
     });
     formatConditionRangeSet1.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent;
     gridItemFormatRule1.Condition      = formatConditionRangeSet1;
     gridItemFormatRule1.DataItem       = measure2;
     gridItemFormatRule1.Name           = "FormatRule 1";
     this.gridDashboardItem1.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] {
         gridItemFormatRule1
     });
     this.gridDashboardItem1.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual;
     this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.gridDashboardItem1.Name        = "Chi tiết theo ngày";
     this.gridDashboardItem1.ShowCaption = true;
     //
     // gridDashboardItem2
     //
     dimension4.DataMember            = "ngaytaodt";
     dimension4.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.MonthYear;
     gridDimensionColumn3.Name        = "Tháng Năm";
     gridDimensionColumn3.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] {
         gridColumnTotal2
     });
     gridDimensionColumn3.Weight    = 60.910404624277454D;
     gridDimensionColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn3.AddDataItem("Dimension", dimension4);
     dimension5.DataMember          = "tenCa";
     gridDimensionColumn4.Name      = "Tên Ca";
     gridDimensionColumn4.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn4.AddDataItem("Dimension", dimension5);
     measure3.DataMember = "tienconlaitheoca";
     measure3.NumericFormat.CurrencyCultureName = "vi-VN";
     measure3.NumericFormat.FormatType          = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency;
     gridMeasureColumn2.Name      = "Tổng";
     gridMeasureColumn2.Weight    = 89.089595375722539D;
     gridMeasureColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridMeasureColumn2.AddDataItem("Measure", measure3);
     this.gridDashboardItem2.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
         gridDimensionColumn3,
         gridDimensionColumn4,
         gridMeasureColumn2
     });
     this.gridDashboardItem2.ComponentName = "gridDashboardItem2";
     this.gridDashboardItem2.DataItemRepository.Clear();
     this.gridDashboardItem2.DataItemRepository.Add(dimension4, "DataItem0");
     this.gridDashboardItem2.DataItemRepository.Add(measure3, "DataItem1");
     this.gridDashboardItem2.DataItemRepository.Add(dimension5, "DataItem2");
     this.gridDashboardItem2.DataMember = "DoanhThu";
     this.gridDashboardItem2.DataSource = this.dashboardSqlDataSource1;
     iconSettings5.IconType             = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow;
     rangeInfo5.StyleSettings           = iconSettings5;
     rangeInfo5.Value         = 0D;
     iconSettings6.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowSideArrow;
     rangeInfo6.StyleSettings = iconSettings6;
     rangeInfo6.Value         = 33D;
     iconSettings7.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp;
     rangeInfo7.StyleSettings = iconSettings7;
     rangeInfo7.Value         = 67D;
     formatConditionRangeSet2.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] {
         rangeInfo5,
         rangeInfo6,
         rangeInfo7
     });
     formatConditionRangeSet2.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent;
     gridItemFormatRule2.Condition      = formatConditionRangeSet2;
     gridItemFormatRule2.DataItem       = measure3;
     gridItemFormatRule2.Name           = "FormatRule 1";
     this.gridDashboardItem2.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] {
         gridItemFormatRule2
     });
     this.gridDashboardItem2.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual;
     this.gridDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false;
     this.gridDashboardItem2.Name        = "Tổng theo tháng";
     this.gridDashboardItem2.ShowCaption = true;
     //
     // gridDashboardItem3
     //
     dimension6.DataMember          = "ngaytaodt";
     gridDimensionColumn5.Name      = "Năm";
     gridDimensionColumn5.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn5.AddDataItem("Dimension", dimension6);
     measure4.DataMember = "tienconlaitheoca";
     measure4.NumericFormat.CurrencyCultureName = "vi-VN";
     measure4.NumericFormat.FormatType          = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency;
     gridMeasureColumn3.Name      = "Tổng";
     gridMeasureColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridMeasureColumn3.AddDataItem("Measure", measure4);
     this.gridDashboardItem3.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
         gridDimensionColumn5,
         gridMeasureColumn3
     });
     this.gridDashboardItem3.ComponentName = "gridDashboardItem3";
     this.gridDashboardItem3.DataItemRepository.Clear();
     this.gridDashboardItem3.DataItemRepository.Add(dimension6, "DataItem0");
     this.gridDashboardItem3.DataItemRepository.Add(measure4, "DataItem1");
     this.gridDashboardItem3.DataMember = "DoanhThu";
     this.gridDashboardItem3.DataSource = this.dashboardSqlDataSource1;
     iconSettings8.IconType             = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow;
     rangeInfo8.StyleSettings           = iconSettings8;
     rangeInfo8.Value          = 0D;
     iconSettings9.IconType    = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow;
     rangeInfo9.StyleSettings  = iconSettings9;
     rangeInfo9.Value          = 25D;
     iconSettings10.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow;
     rangeInfo10.StyleSettings = iconSettings10;
     rangeInfo10.Value         = 50D;
     iconSettings11.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp;
     rangeInfo11.StyleSettings = iconSettings11;
     rangeInfo11.Value         = 75D;
     formatConditionRangeSet3.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] {
         rangeInfo8,
         rangeInfo9,
         rangeInfo10,
         rangeInfo11
     });
     formatConditionRangeSet3.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent;
     gridItemFormatRule3.Condition      = formatConditionRangeSet3;
     gridItemFormatRule3.DataItem       = measure4;
     gridItemFormatRule3.Name           = "FormatRule 1";
     this.gridDashboardItem3.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] {
         gridItemFormatRule3
     });
     this.gridDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false;
     this.gridDashboardItem3.Name        = "Tổng theo Năm";
     this.gridDashboardItem3.ShowCaption = true;
     //
     // Report_TienConLaiCC
     //
     this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
         this.dashboardSqlDataSource1
     });
     this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
         this.gridDashboardItem1,
         this.rangeFilterDashboardItem1,
         this.gridDashboardItem2,
         this.gridDashboardItem3
     });
     dashboardLayoutItem1.DashboardItem = this.rangeFilterDashboardItem1;
     dashboardLayoutItem1.Weight        = 29.154929577464788D;
     dashboardLayoutItem2.DashboardItem = this.gridDashboardItem1;
     dashboardLayoutItem2.Weight        = 59.3727726300784D;
     dashboardLayoutItem3.DashboardItem = this.gridDashboardItem2;
     dashboardLayoutItem3.Weight        = 50.099403578528829D;
     dashboardLayoutItem4.DashboardItem = this.gridDashboardItem3;
     dashboardLayoutItem4.Weight        = 49.900596421471171D;
     dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem3,
         dashboardLayoutItem4
     });
     dashboardLayoutGroup3.DashboardItem = null;
     dashboardLayoutGroup3.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup3.Weight        = 40.6272273699216D;
     dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem2,
         dashboardLayoutGroup3
     });
     dashboardLayoutGroup2.DashboardItem = null;
     dashboardLayoutGroup2.Weight        = 70.845070422535215D;
     dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem1,
         dashboardLayoutGroup2
     });
     dashboardLayoutGroup1.DashboardItem = null;
     dashboardLayoutGroup1.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup1.Weight        = 100D;
     this.LayoutRoot = dashboardLayoutGroup1;
     this.Title.Text = "Báo Cáo Tiền Còn Lại Cuối Ca";
     ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).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.DateTimePeriod          dateTimePeriod1           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit1  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit2  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod2           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit3  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit4  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod3           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit5  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit6  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod4           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit7  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit8  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod5           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit9  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit10 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod6           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit11 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit12 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod          dateTimePeriod7           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit13 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit14 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.SimpleSeries            simpleSeries1             = new DevExpress.DashboardCommon.SimpleSeries();
     DevExpress.DashboardCommon.SimpleSeries            simpleSeries2             = new DevExpress.DashboardCommon.SimpleSeries();
     DevExpress.DashboardCommon.CalculatedField         calculatedField1          = new DevExpress.DashboardCommon.CalculatedField();
     DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters msSqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters();
     DevExpress.DataAccess.Sql.SelectQuery              selectQuery1             = new DevExpress.DataAccess.Sql.SelectQuery();
     DevExpress.DataAccess.Sql.Column                   column1                  = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression1        = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                    table1                   = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column                   column2                  = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression2        = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                    table2                   = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column                   column3                  = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression3        = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column4                  = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression4        = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column5                  = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression5        = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column6                  = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression6        = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column7                  = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression7        = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column                   column8                  = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression         columnExpression8        = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.AllColumns               allColumns1              = new DevExpress.DataAccess.Sql.AllColumns();
     DevExpress.DataAccess.Sql.AllColumns               allColumns2              = new DevExpress.DataAccess.Sql.AllColumns();
     DevExpress.DataAccess.Sql.Join                     join1                    = new DevExpress.DataAccess.Sql.Join();
     DevExpress.DataAccess.Sql.RelationColumnInfo       relationColumnInfo1      = new DevExpress.DataAccess.Sql.RelationColumnInfo();
     System.ComponentModel.ComponentResourceManager     resources                = new System.ComponentModel.ComponentResourceManager(typeof(Report_DTBanHang));
     DevExpress.DashboardCommon.Dimension               dimension2               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn1     = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.GridColumnTotal         gridColumnTotal1         = new DevExpress.DashboardCommon.GridColumnTotal();
     DevExpress.DashboardCommon.Dimension               dimension3               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn2     = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.Measure                 measure3                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.GridMeasureColumn       gridMeasureColumn1       = new DevExpress.DashboardCommon.GridMeasureColumn();
     DevExpress.DashboardCommon.GridColumnTotal         gridColumnTotal2         = new DevExpress.DashboardCommon.GridColumnTotal();
     DevExpress.DashboardCommon.GridItemFormatRule      gridItemFormatRule1      = new DevExpress.DashboardCommon.GridItemFormatRule();
     DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet1 = new DevExpress.DashboardCommon.FormatConditionRangeSet();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo1               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings1            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo2               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings2            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo3               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings3            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo4               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings4            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.Dimension               dimension4               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn3     = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.GridColumnTotal         gridColumnTotal3         = new DevExpress.DashboardCommon.GridColumnTotal();
     DevExpress.DashboardCommon.Measure                 measure4                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.GridMeasureColumn       gridMeasureColumn2       = new DevExpress.DashboardCommon.GridMeasureColumn();
     DevExpress.DashboardCommon.GridItemFormatRule      gridItemFormatRule2      = new DevExpress.DashboardCommon.GridItemFormatRule();
     DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet2 = new DevExpress.DashboardCommon.FormatConditionRangeSet();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo5               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings5            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo6               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings6            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo7               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings7            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo8               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings8            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.Dimension               dimension5               = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.GridDimensionColumn     gridDimensionColumn4     = new DevExpress.DashboardCommon.GridDimensionColumn();
     DevExpress.DashboardCommon.Measure                 measure5                 = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.GridMeasureColumn       gridMeasureColumn3       = new DevExpress.DashboardCommon.GridMeasureColumn();
     DevExpress.DashboardCommon.GridItemFormatRule      gridItemFormatRule3      = new DevExpress.DashboardCommon.GridItemFormatRule();
     DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet3 = new DevExpress.DashboardCommon.FormatConditionRangeSet();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo9               = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings9            = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo10              = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings10           = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo11              = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings11           = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.RangeInfo               rangeInfo12              = new DevExpress.DashboardCommon.RangeInfo();
     DevExpress.DashboardCommon.IconSettings            iconSettings12           = new DevExpress.DashboardCommon.IconSettings();
     DevExpress.DashboardCommon.DashboardLayoutGroup    dashboardLayoutGroup1    = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutItem     dashboardLayoutItem1     = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutGroup    dashboardLayoutGroup2    = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     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.rangeFilterDashboardItem1 = new DevExpress.DashboardCommon.RangeFilterDashboardItem();
     this.dashboardSqlDataSource1   = new DevExpress.DashboardCommon.DashboardSqlDataSource();
     this.gridDashboardItem1        = new DevExpress.DashboardCommon.GridDashboardItem();
     this.gridDashboardItem2        = new DevExpress.DashboardCommon.GridDashboardItem();
     this.gridDashboardItem3        = new DevExpress.DashboardCommon.GridDashboardItem();
     ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // rangeFilterDashboardItem1
     //
     dimension1.DataMember                        = "DoanhThu_ngaytaodt";
     dimension1.DateTimeGroupInterval             = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
     this.rangeFilterDashboardItem1.Argument      = dimension1;
     this.rangeFilterDashboardItem1.ComponentName = "rangeFilterDashboardItem1";
     measure1.DataMember  = "tong dt";
     measure2.DataMember  = "DoanhThuTheoCa_tenCa";
     measure2.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
     this.rangeFilterDashboardItem1.DataItemRepository.Clear();
     this.rangeFilterDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2");
     this.rangeFilterDashboardItem1.DataItemRepository.Add(measure1, "DataItem1");
     this.rangeFilterDashboardItem1.DataItemRepository.Add(measure2, "DataItem0");
     this.rangeFilterDashboardItem1.DataMember = "DoanhThu";
     this.rangeFilterDashboardItem1.DataSource = this.dashboardSqlDataSource1;
     flowDateTimePeriodLimit1.Offset           = 1;
     dateTimePeriod1.End                = flowDateTimePeriodLimit1;
     dateTimePeriod1.Name               = "Năm Hiện Tại";
     dateTimePeriod1.Start              = flowDateTimePeriodLimit2;
     flowDateTimePeriodLimit3.Interval  = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit3.Offset    = 1;
     dateTimePeriod2.End                = flowDateTimePeriodLimit3;
     dateTimePeriod2.Name               = "Tháng Hiện Tại";
     flowDateTimePeriodLimit4.Interval  = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod2.Start              = flowDateTimePeriodLimit4;
     dateTimePeriod3.End                = flowDateTimePeriodLimit5;
     dateTimePeriod3.Name               = "Năm Trước";
     flowDateTimePeriodLimit6.Offset    = -1;
     dateTimePeriod3.Start              = flowDateTimePeriodLimit6;
     flowDateTimePeriodLimit7.Interval  = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod4.End                = flowDateTimePeriodLimit7;
     dateTimePeriod4.Name               = "Tháng trước";
     flowDateTimePeriodLimit8.Interval  = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit8.Offset    = -1;
     dateTimePeriod4.Start              = flowDateTimePeriodLimit8;
     flowDateTimePeriodLimit9.Interval  = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod5.End                = flowDateTimePeriodLimit9;
     dateTimePeriod5.Name               = "3 tháng trước";
     flowDateTimePeriodLimit10.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit10.Offset   = -3;
     dateTimePeriod5.Start              = flowDateTimePeriodLimit10;
     flowDateTimePeriodLimit11.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod6.End                = flowDateTimePeriodLimit11;
     dateTimePeriod6.Name               = "6 tháng trước";
     flowDateTimePeriodLimit12.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit12.Offset   = -6;
     dateTimePeriod6.Start              = flowDateTimePeriodLimit12;
     flowDateTimePeriodLimit13.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod7.End                = flowDateTimePeriodLimit13;
     dateTimePeriod7.Name               = "12 tháng trước";
     flowDateTimePeriodLimit14.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     flowDateTimePeriodLimit14.Offset   = -12;
     dateTimePeriod7.Start              = flowDateTimePeriodLimit14;
     this.rangeFilterDashboardItem1.DateTimePeriods.AddRange(new DevExpress.DashboardCommon.DateTimePeriod[] {
         dateTimePeriod1,
         dateTimePeriod2,
         dateTimePeriod3,
         dateTimePeriod4,
         dateTimePeriod5,
         dateTimePeriod6,
         dateTimePeriod7
     });
     this.rangeFilterDashboardItem1.DefaultDateTimePeriodName = "Năm Hiện Tại";
     this.rangeFilterDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true;
     this.rangeFilterDashboardItem1.Name = "Bộ Lọc Doanh Thu theo năm tháng";
     simpleSeries1.SeriesType            = DevExpress.DashboardCommon.SimpleSeriesType.StackedBar;
     simpleSeries1.AddDataItem("Value", measure2);
     simpleSeries2.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.StackedBar;
     simpleSeries2.AddDataItem("Value", measure1);
     this.rangeFilterDashboardItem1.Series.AddRange(new DevExpress.DashboardCommon.SimpleSeries[] {
         simpleSeries1,
         simpleSeries2
     });
     this.rangeFilterDashboardItem1.ShowCaption = true;
     //
     // dashboardSqlDataSource1
     //
     calculatedField1.DataMember = "DoanhThu";
     calculatedField1.Expression = "[DoanhThuTheoCa_tiendelai] + [DoanhThuTheoCa_doanhthutheoca] + [DoanhThuTheoCa_do" +
                                   "anhthukhac]";
     calculatedField1.Name = "tong dt";
     this.dashboardSqlDataSource1.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] {
         calculatedField1
     });
     this.dashboardSqlDataSource1.ComponentName        = "dashboardSqlDataSource1";
     this.dashboardSqlDataSource1.ConnectionName       = "localhost_BaoCaoThuChi_Connection";
     msSqlConnectionParameters1.AuthorizationType      = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.Windows;
     msSqlConnectionParameters1.DatabaseName           = "BaoCaoThuChi";
     msSqlConnectionParameters1.ServerName             = "localhost";
     this.dashboardSqlDataSource1.ConnectionParameters = msSqlConnectionParameters1;
     this.dashboardSqlDataSource1.Name = "SQL Data Source 1";
     columnExpression1.ColumnName      = "ngaytaodt";
     table1.MetaSerializable           = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"110\" />";
     table1.Name                  = "DoanhThu";
     columnExpression1.Table      = table1;
     column1.Expression           = columnExpression1;
     columnExpression2.ColumnName = "tenCa";
     table2.MetaSerializable      = "<Meta X=\"185\" Y=\"30\" Width=\"125\" Height=\"194\" />";
     table2.Name                  = "DoanhThuTheoCa";
     columnExpression2.Table      = table2;
     column2.Expression           = columnExpression2;
     column3.Alias                = "DoanhThuTheoCa_doanhthuID";
     columnExpression3.ColumnName = "doanhthuID";
     columnExpression3.Table      = table2;
     column3.Expression           = columnExpression3;
     columnExpression4.ColumnName = "tiendelai";
     columnExpression4.Table      = table2;
     column4.Expression           = columnExpression4;
     columnExpression5.ColumnName = "doanhthutheoca";
     columnExpression5.Table      = table2;
     column5.Expression           = columnExpression5;
     columnExpression6.ColumnName = "doanhthukhac";
     columnExpression6.Table      = table2;
     column6.Expression           = columnExpression6;
     columnExpression7.ColumnName = "doanhthuID";
     columnExpression7.Table      = table1;
     column7.Expression           = columnExpression7;
     columnExpression8.ColumnName = "caID";
     columnExpression8.Table      = table2;
     column8.Expression           = columnExpression8;
     allColumns1.Table            = table2;
     allColumns2.Table            = table1;
     selectQuery1.Columns.Add(column1);
     selectQuery1.Columns.Add(column2);
     selectQuery1.Columns.Add(column3);
     selectQuery1.Columns.Add(column4);
     selectQuery1.Columns.Add(column5);
     selectQuery1.Columns.Add(column6);
     selectQuery1.Columns.Add(column7);
     selectQuery1.Columns.Add(column8);
     selectQuery1.Columns.Add(allColumns1);
     selectQuery1.Columns.Add(allColumns2);
     selectQuery1.Name = "DoanhThu";
     relationColumnInfo1.NestedKeyColumn = "doanhthuID";
     relationColumnInfo1.ParentKeyColumn = "doanhthuID";
     join1.KeyColumns.Add(relationColumnInfo1);
     join1.Nested = table2;
     join1.Parent = table1;
     selectQuery1.Relations.Add(join1);
     selectQuery1.Tables.Add(table1);
     selectQuery1.Tables.Add(table2);
     this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         selectQuery1
     });
     this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable");
     //
     // gridDashboardItem1
     //
     dimension2.DataMember            = "DoanhThu_ngaytaodt";
     dimension2.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
     dimension2.Name                 = "Ngày tạo Doanh Thu";
     dimension2.SortOrder            = DevExpress.DashboardCommon.DimensionSortOrder.Descending;
     gridDimensionColumn1.FixedWidth = 57.491674693821388D;
     gridDimensionColumn1.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] {
         gridColumnTotal1
     });
     gridDimensionColumn1.Weight    = 97.358900144717822D;
     gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn1.AddDataItem("Dimension", dimension2);
     dimension3.DataMember          = "tenCa";
     dimension3.Name                = "Tên Ca";
     gridDimensionColumn2.Weight    = 26.049204052098414D;
     gridDimensionColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.FitToContent;
     gridDimensionColumn2.AddDataItem("Dimension", dimension3);
     measure3.DataMember = "tong dt";
     measure3.NumericFormat.CurrencyCultureName = "vi-VN";
     measure3.NumericFormat.FormatType          = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency;
     gridMeasureColumn1.Name    = "Tổng";
     gridColumnTotal2.TotalType = DevExpress.DashboardCommon.GridColumnTotalType.Sum;
     gridMeasureColumn1.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] {
         gridColumnTotal2
     });
     gridMeasureColumn1.Weight    = 101.59189580318382D;
     gridMeasureColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridMeasureColumn1.AddDataItem("Measure", measure3);
     this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
         gridDimensionColumn1,
         gridDimensionColumn2,
         gridMeasureColumn1
     });
     this.gridDashboardItem1.ComponentName = "gridDashboardItem1";
     this.gridDashboardItem1.DataItemRepository.Clear();
     this.gridDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0");
     this.gridDashboardItem1.DataItemRepository.Add(dimension3, "DataItem1");
     this.gridDashboardItem1.DataItemRepository.Add(measure3, "DataItem2");
     this.gridDashboardItem1.DataMember = "DoanhThu";
     this.gridDashboardItem1.DataSource = this.dashboardSqlDataSource1;
     iconSettings1.IconType             = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow;
     rangeInfo1.StyleSettings           = iconSettings1;
     rangeInfo1.Value         = 0D;
     iconSettings2.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow;
     rangeInfo2.StyleSettings = iconSettings2;
     rangeInfo2.Value         = 25D;
     iconSettings3.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow;
     rangeInfo3.StyleSettings = iconSettings3;
     rangeInfo3.Value         = 50D;
     iconSettings4.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp;
     rangeInfo4.StyleSettings = iconSettings4;
     rangeInfo4.Value         = 75D;
     formatConditionRangeSet1.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] {
         rangeInfo1,
         rangeInfo2,
         rangeInfo3,
         rangeInfo4
     });
     formatConditionRangeSet1.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent;
     gridItemFormatRule1.Condition      = formatConditionRangeSet1;
     gridItemFormatRule1.DataItem       = measure3;
     gridItemFormatRule1.Name           = "FormatRule 1";
     this.gridDashboardItem1.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] {
         gridItemFormatRule1
     });
     this.gridDashboardItem1.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual;
     this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.gridDashboardItem1.Name        = "Chi tiết theo ngày";
     this.gridDashboardItem1.ShowCaption = true;
     //
     // gridDashboardItem2
     //
     dimension4.DataMember            = "DoanhThu_ngaytaodt";
     dimension4.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.MonthYear;
     dimension4.Name           = "Ngày tạo Doanh Thu (Month-Year)";
     dimension4.SortOrder      = DevExpress.DashboardCommon.DimensionSortOrder.Descending;
     gridDimensionColumn3.Name = "Tháng Năm";
     gridDimensionColumn3.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] {
         gridColumnTotal3
     });
     gridDimensionColumn3.Weight    = 78.468208092485554D;
     gridDimensionColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn3.AddDataItem("Dimension", dimension4);
     measure4.DataMember = "tong dt";
     measure4.Name       = "Tổng";
     measure4.NumericFormat.CurrencyCultureName = "vi-VN";
     measure4.NumericFormat.FormatType          = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency;
     gridMeasureColumn2.Weight    = 71.531791907514446D;
     gridMeasureColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridMeasureColumn2.AddDataItem("Measure", measure4);
     this.gridDashboardItem2.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
         gridDimensionColumn3,
         gridMeasureColumn2
     });
     this.gridDashboardItem2.ComponentName = "gridDashboardItem2";
     this.gridDashboardItem2.DataItemRepository.Clear();
     this.gridDashboardItem2.DataItemRepository.Add(dimension4, "DataItem0");
     this.gridDashboardItem2.DataItemRepository.Add(measure4, "DataItem1");
     this.gridDashboardItem2.DataMember = "DoanhThu";
     this.gridDashboardItem2.DataSource = this.dashboardSqlDataSource1;
     iconSettings5.IconType             = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow;
     rangeInfo5.StyleSettings           = iconSettings5;
     rangeInfo5.Value         = 0D;
     iconSettings6.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow;
     rangeInfo6.StyleSettings = iconSettings6;
     rangeInfo6.Value         = 25D;
     iconSettings7.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow;
     rangeInfo7.StyleSettings = iconSettings7;
     rangeInfo7.Value         = 50D;
     iconSettings8.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp;
     rangeInfo8.StyleSettings = iconSettings8;
     rangeInfo8.Value         = 75D;
     formatConditionRangeSet2.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] {
         rangeInfo5,
         rangeInfo6,
         rangeInfo7,
         rangeInfo8
     });
     formatConditionRangeSet2.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent;
     gridItemFormatRule2.Condition      = formatConditionRangeSet2;
     gridItemFormatRule2.DataItem       = measure4;
     gridItemFormatRule2.Name           = "FormatRule 1";
     this.gridDashboardItem2.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] {
         gridItemFormatRule2
     });
     this.gridDashboardItem2.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual;
     this.gridDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false;
     this.gridDashboardItem2.Name        = "Tổng theo Tháng";
     this.gridDashboardItem2.ShowCaption = true;
     //
     // gridDashboardItem3
     //
     dimension5.DataMember          = "DoanhThu_ngaytaodt";
     gridDimensionColumn4.Name      = "Năm";
     gridDimensionColumn4.Weight    = 95.717344753747327D;
     gridDimensionColumn4.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridDimensionColumn4.AddDataItem("Dimension", dimension5);
     measure5.DataMember = "tong dt";
     measure5.NumericFormat.CurrencyCultureName = "vi-VN";
     measure5.NumericFormat.FormatType          = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency;
     gridMeasureColumn3.Name      = "Tổng";
     gridMeasureColumn3.Weight    = 54.282655246252673D;
     gridMeasureColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
     gridMeasureColumn3.AddDataItem("Measure", measure5);
     this.gridDashboardItem3.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
         gridDimensionColumn4,
         gridMeasureColumn3
     });
     this.gridDashboardItem3.ComponentName = "gridDashboardItem3";
     this.gridDashboardItem3.DataItemRepository.Clear();
     this.gridDashboardItem3.DataItemRepository.Add(dimension5, "DataItem0");
     this.gridDashboardItem3.DataItemRepository.Add(measure5, "DataItem1");
     this.gridDashboardItem3.DataMember = "DoanhThu";
     this.gridDashboardItem3.DataSource = this.dashboardSqlDataSource1;
     iconSettings9.IconType             = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow;
     rangeInfo9.StyleSettings           = iconSettings9;
     rangeInfo9.Value          = 0D;
     iconSettings10.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow;
     rangeInfo10.StyleSettings = iconSettings10;
     rangeInfo10.Value         = 25D;
     iconSettings11.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow;
     rangeInfo11.StyleSettings = iconSettings11;
     rangeInfo11.Value         = 50D;
     iconSettings12.IconType   = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp;
     rangeInfo12.StyleSettings = iconSettings12;
     rangeInfo12.Value         = 75D;
     formatConditionRangeSet3.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] {
         rangeInfo9,
         rangeInfo10,
         rangeInfo11,
         rangeInfo12
     });
     formatConditionRangeSet3.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent;
     gridItemFormatRule3.Condition      = formatConditionRangeSet3;
     gridItemFormatRule3.DataItem       = measure5;
     gridItemFormatRule3.Name           = "FormatRule 1";
     this.gridDashboardItem3.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] {
         gridItemFormatRule3
     });
     this.gridDashboardItem3.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual;
     this.gridDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false;
     this.gridDashboardItem3.Name        = "Tổng theo Năm";
     this.gridDashboardItem3.ShowCaption = true;
     //
     // Report_DTBanHang
     //
     this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
         this.dashboardSqlDataSource1
     });
     this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
         this.gridDashboardItem1,
         this.rangeFilterDashboardItem1,
         this.gridDashboardItem2,
         this.gridDashboardItem3
     });
     dashboardLayoutItem1.DashboardItem = this.rangeFilterDashboardItem1;
     dashboardLayoutItem1.Weight        = 40.465116279069768D;
     dashboardLayoutItem2.DashboardItem = this.gridDashboardItem1;
     dashboardLayoutItem2.Weight        = 65.9963436928702D;
     dashboardLayoutItem3.DashboardItem = this.gridDashboardItem2;
     dashboardLayoutItem3.Weight        = 50.520833333333336D;
     dashboardLayoutItem4.DashboardItem = this.gridDashboardItem3;
     dashboardLayoutItem4.Weight        = 49.479166666666664D;
     dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem3,
         dashboardLayoutItem4
     });
     dashboardLayoutGroup3.DashboardItem = null;
     dashboardLayoutGroup3.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup3.Weight        = 34.0036563071298D;
     dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem2,
         dashboardLayoutGroup3
     });
     dashboardLayoutGroup2.DashboardItem = null;
     dashboardLayoutGroup2.Weight        = 59.534883720930232D;
     dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem1,
         dashboardLayoutGroup2
     });
     dashboardLayoutGroup1.DashboardItem = null;
     dashboardLayoutGroup1.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup1.Weight        = 100D;
     this.LayoutRoot = dashboardLayoutGroup1;
     this.Title.Text = "Dashboard";
     ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure5)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).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.ChartPane                chartPane1                = new DevExpress.DashboardCommon.ChartPane();
     DevExpress.DashboardCommon.SimpleSeries             simpleSeries1             = new DevExpress.DashboardCommon.SimpleSeries();
     DevExpress.DashboardCommon.Dimension                dimension2                = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.DateTimePeriod           dateTimePeriod1           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit  flowDateTimePeriodLimit1  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit  flowDateTimePeriodLimit2  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod           dateTimePeriod2           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit  flowDateTimePeriodLimit3  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit  flowDateTimePeriodLimit4  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod           dateTimePeriod3           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit  flowDateTimePeriodLimit5  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.FlowDateTimePeriodLimit  flowDateTimePeriodLimit6  = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
     DevExpress.DashboardCommon.DateTimePeriod           dateTimePeriod4           = new DevExpress.DashboardCommon.DateTimePeriod();
     DevExpress.DashboardCommon.FixedDateTimePeriodLimit fixedDateTimePeriodLimit1 = new DevExpress.DashboardCommon.FixedDateTimePeriodLimit();
     DevExpress.DashboardCommon.FixedDateTimePeriodLimit fixedDateTimePeriodLimit2 = new DevExpress.DashboardCommon.FixedDateTimePeriodLimit();
     System.ComponentModel.ComponentResourceManager      resources                 = new System.ComponentModel.ComponentResourceManager(typeof(Dashboard1));
     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.DashboardLayoutGroup     dashboardLayoutGroup2     = new DevExpress.DashboardCommon.DashboardLayoutGroup();
     DevExpress.DashboardCommon.DashboardLayoutItem      dashboardLayoutItem1      = new DevExpress.DashboardCommon.DashboardLayoutItem();
     DevExpress.DashboardCommon.DashboardLayoutItem      dashboardLayoutItem2      = new DevExpress.DashboardCommon.DashboardLayoutItem();
     this.chartDashboardItem1       = new DevExpress.DashboardCommon.ChartDashboardItem();
     this.dateFilterDashboardItem1  = new DevExpress.DashboardCommon.DateFilterDashboardItem();
     this.dashboardItemGroup1       = new DevExpress.DashboardCommon.DashboardItemGroup();
     this.dashboardExcelDataSource1 = new DevExpress.DashboardCommon.DashboardExcelDataSource();
     ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dateFilterDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardItemGroup1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // chartDashboardItem1
     //
     dimension1.DataMember            = "OrderDate";
     dimension1.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
     this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension1
     });
     this.chartDashboardItem1.AxisX.TitleVisible = false;
     this.chartDashboardItem1.ComponentName      = "chartDashboardItem1";
     measure1.DataMember = "Extended Price";
     this.chartDashboardItem1.DataItemRepository.Clear();
     this.chartDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0");
     this.chartDashboardItem1.DataItemRepository.Add(measure1, "DataItem1");
     this.chartDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.chartDashboardItem1.Name = "";
     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.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.Line;
     simpleSeries1.AddDataItem("Value", measure1);
     chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] {
         simpleSeries1
     });
     this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] {
         chartPane1
     });
     this.chartDashboardItem1.ParentContainer = this.dashboardItemGroup1;
     this.chartDashboardItem1.ShowCaption     = false;
     //
     // dateFilterDashboardItem1
     //
     this.dateFilterDashboardItem1.ArrangementMode = DevExpress.DashboardCommon.DateFilterArrangementMode.Vertical;
     this.dateFilterDashboardItem1.ComponentName   = "dateFilterDashboardItem1";
     dimension2.DataMember            = "OrderDate";
     dimension2.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
     dimension2.UniqueId = "orderDateId";
     this.dateFilterDashboardItem1.DataItemRepository.Clear();
     this.dateFilterDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0");
     this.dateFilterDashboardItem1.DataSource = this.dashboardExcelDataSource1;
     dateTimePeriod1.End               = flowDateTimePeriodLimit1;
     dateTimePeriod1.Name              = "Last Year";
     flowDateTimePeriodLimit2.Offset   = -1;
     dateTimePeriod1.Start             = flowDateTimePeriodLimit2;
     flowDateTimePeriodLimit3.Interval = DevExpress.DashboardCommon.DateTimeInterval.Day;
     flowDateTimePeriodLimit3.Offset   = 8;
     dateTimePeriod2.End               = flowDateTimePeriodLimit3;
     dateTimePeriod2.Name              = "Next Seven Days";
     flowDateTimePeriodLimit4.Interval = DevExpress.DashboardCommon.DateTimeInterval.Day;
     flowDateTimePeriodLimit4.Offset   = 1;
     dateTimePeriod2.Start             = flowDateTimePeriodLimit4;
     flowDateTimePeriodLimit5.Interval = DevExpress.DashboardCommon.DateTimeInterval.Day;
     flowDateTimePeriodLimit5.Offset   = 1;
     dateTimePeriod3.End               = flowDateTimePeriodLimit5;
     dateTimePeriod3.Name              = "Month-to-Date";
     flowDateTimePeriodLimit6.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
     dateTimePeriod3.Start             = flowDateTimePeriodLimit6;
     fixedDateTimePeriodLimit1.Date    = new System.DateTime(2019, 1, 18, 0, 0, 0, 0);
     dateTimePeriod4.End               = fixedDateTimePeriodLimit1;
     dateTimePeriod4.Name              = "Jul 18, 2018 - Jan 18, 2019";
     fixedDateTimePeriodLimit2.Date    = new System.DateTime(2018, 7, 18, 0, 0, 0, 0);
     dateTimePeriod4.Start             = fixedDateTimePeriodLimit2;
     this.dateFilterDashboardItem1.DateTimePeriods.AddRange(new DevExpress.DashboardCommon.DateTimePeriod[] {
         dateTimePeriod1,
         dateTimePeriod2,
         dateTimePeriod3,
         dateTimePeriod4
     });
     this.dateFilterDashboardItem1.Dimension       = dimension2;
     this.dateFilterDashboardItem1.Name            = "";
     this.dateFilterDashboardItem1.ParentContainer = this.dashboardItemGroup1;
     this.dateFilterDashboardItem1.ShowCaption     = false;
     //
     // dashboardItemGroup1
     //
     this.dashboardItemGroup1.ComponentName = "dashboardItemGroup1";
     this.dashboardItemGroup1.InteractivityOptions.IgnoreMasterFilters = true;
     this.dashboardItemGroup1.InteractivityOptions.IsMasterFilter      = false;
     this.dashboardItemGroup1.Name        = "Sales by Date";
     this.dashboardItemGroup1.ShowCaption = true;
     //
     // dashboardExcelDataSource1
     //
     this.dashboardExcelDataSource1.ComponentName            = "dashboardExcelDataSource1";
     this.dashboardExcelDataSource1.FileName                 = "SalesPerson.xlsx";
     this.dashboardExcelDataSource1.Name                     = "Excel Data Source 1";
     this.dashboardExcelDataSource1.ResultSchemaSerializable = resources.GetString("dashboardExcelDataSource1.ResultSchemaSerializable");
     excelWorksheetSettings1.CellRange            = null;
     excelWorksheetSettings1.WorksheetName        = "Data";
     excelSourceOptions1.ImportSettings           = excelWorksheetSettings1;
     this.dashboardExcelDataSource1.SourceOptions = excelSourceOptions1;
     //
     // Dashboard1
     //
     this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
         this.dashboardExcelDataSource1
     });
     this.Groups.AddRange(new DevExpress.DashboardCommon.DashboardItemGroup[] {
         this.dashboardItemGroup1
     });
     this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
         this.chartDashboardItem1,
         this.dateFilterDashboardItem1
     });
     dashboardLayoutItem1.DashboardItem = this.dateFilterDashboardItem1;
     dashboardLayoutItem1.Weight        = 30D;
     dashboardLayoutItem2.DashboardItem = this.chartDashboardItem1;
     dashboardLayoutItem2.Weight        = 70D;
     dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem1,
         dashboardLayoutItem2
     });
     dashboardLayoutGroup2.DashboardItem = this.dashboardItemGroup1;
     dashboardLayoutGroup2.Weight        = 100D;
     dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutGroup2
     });
     dashboardLayoutGroup1.DashboardItem = null;
     dashboardLayoutGroup1.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     dashboardLayoutGroup1.Weight        = 100D;
     this.LayoutRoot = dashboardLayoutGroup1;
     this.Title.Text = "Dashboard";
     ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dateFilterDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardItemGroup1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }