/// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition5 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition6 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition7 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition8 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     this.calcCases = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcNPS = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcVolume = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcPPL = new DevExpress.XtraPivotGrid.PivotGridField();
     this.repositoryItemTextEditf2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
     this.repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
     this.popupMenuMain = new DevExpress.XtraBars.PopupMenu(this.components);
     this.barManagerMain = new DevExpress.XtraBars.BarManager(this.components);
     this.bar1 = new DevExpress.XtraBars.Bar();
     this.barHeaderItem1 = new DevExpress.XtraBars.BarHeaderItem();
     this.bbiStartDate = new DevExpress.XtraBars.BarEditItem();
     this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
     this.barHeaderItem2 = new DevExpress.XtraBars.BarHeaderItem();
     this.bbiEndDate = new DevExpress.XtraBars.BarEditItem();
     this.repositoryItemDateEdit3 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
     this.bbiGetData = new DevExpress.XtraBars.BarLargeButtonItem();
     this.bbiExport = new DevExpress.XtraBars.BarButtonItem();
     this.barDockControlTop = new DevExpress.XtraBars.BarDockControl();
     this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl();
     this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl();
     this.barDockControlRight = new DevExpress.XtraBars.BarDockControl();
     this.repositoryItemDateEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
     this.dxValidationProviderMain = new DevExpress.XtraEditors.DXErrorProvider.DXValidationProvider(this.components);
     this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.pro0004BindingSource = new System.Windows.Forms.BindingSource(this.components);
     this.dsNMQry = new NestleICSales.DataSources.dsQry();
     this.fieldMaterialNumber1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTypeName1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldDistributionChannel1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldMaterialName1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldProductBase1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldBrand1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldProductGroup31 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldProductGroup21 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldProductGroup11 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPriceChanges1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPricePointRang1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldMaterialType1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldFlavor1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldNPDS1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPricePoint1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldCases1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldNPS1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldVolume1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPPL1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldYearNo = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldCustHierLevel3Name = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldCustomerGroup = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldCustomerType = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldCustomerType2 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldRouteNumber = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldSubchannelName = new DevExpress.XtraPivotGrid.PivotGridField();
     this.repositoryItemTextEditPer = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
     this.pro_0004TableAdapter = new NestleICSales.DataSources.dsQryTableAdapters.Pro_0004TableAdapter();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.pro0004BindingSource)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPer)).BeginInit();
     this.SuspendLayout();
     //
     // calcCases
     //
     this.calcCases.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcCases.AreaIndex = 1;
     this.calcCases.Caption = "Cases%";
     this.calcCases.CellFormat.FormatString = "p2";
     this.calcCases.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcCases.DisplayFolder = "0.0%";
     this.calcCases.EmptyCellText = "0.0%";
     this.calcCases.FieldName = "Cases";
     this.calcCases.GrandTotalCellFormat.FormatString = "p2";
     this.calcCases.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcCases.Name = "calcCases";
     this.calcCases.Options.ShowGrandTotal = false;
     this.calcCases.Options.ShowUnboundExpressionMenu = true;
     this.calcCases.TotalCellFormat.FormatString = "p2";
     this.calcCases.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcCases.TotalValueFormat.FormatString = "p2";
     this.calcCases.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcCases.ValueFormat.FormatString = "p2";
     this.calcCases.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     //
     // calcNPS
     //
     this.calcNPS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcNPS.AreaIndex = 3;
     this.calcNPS.Caption = "NPS%";
     this.calcNPS.CellFormat.FormatString = "p2";
     this.calcNPS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcNPS.DisplayFolder = "0.0%";
     this.calcNPS.EmptyCellText = "0.0%";
     this.calcNPS.FieldName = "NPS";
     this.calcNPS.GrandTotalCellFormat.FormatString = "p2";
     this.calcNPS.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcNPS.Name = "calcNPS";
     this.calcNPS.Options.ShowGrandTotal = false;
     this.calcNPS.Options.ShowUnboundExpressionMenu = true;
     this.calcNPS.TotalCellFormat.FormatString = "p2";
     this.calcNPS.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcNPS.TotalValueFormat.FormatString = "p2";
     this.calcNPS.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcNPS.ValueFormat.FormatString = "p2";
     this.calcNPS.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     //
     // calcVolume
     //
     this.calcVolume.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcVolume.AreaIndex = 5;
     this.calcVolume.Caption = "Volume%";
     this.calcVolume.CellFormat.FormatString = "p2";
     this.calcVolume.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcVolume.DisplayFolder = "0.0%";
     this.calcVolume.EmptyCellText = "0.0%";
     this.calcVolume.FieldName = "Volume";
     this.calcVolume.GrandTotalCellFormat.FormatString = "p2";
     this.calcVolume.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcVolume.Name = "calcVolume";
     this.calcVolume.Options.ShowGrandTotal = false;
     this.calcVolume.Options.ShowUnboundExpressionMenu = true;
     this.calcVolume.TotalCellFormat.FormatString = "p2";
     this.calcVolume.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcVolume.TotalValueFormat.FormatString = "p2";
     this.calcVolume.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcVolume.ValueFormat.FormatString = "p2";
     this.calcVolume.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     //
     // calcPPL
     //
     this.calcPPL.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcPPL.AreaIndex = 7;
     this.calcPPL.Caption = "PPL%";
     this.calcPPL.CellFormat.FormatString = "p2";
     this.calcPPL.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcPPL.DisplayFolder = "0.0%";
     this.calcPPL.EmptyCellText = "0.0%";
     this.calcPPL.FieldName = "PPL";
     this.calcPPL.GrandTotalCellFormat.FormatString = "p2";
     this.calcPPL.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcPPL.Name = "calcPPL";
     this.calcPPL.Options.ShowGrandTotal = false;
     this.calcPPL.Options.ShowUnboundExpressionMenu = true;
     this.calcPPL.TotalCellFormat.FormatString = "p2";
     this.calcPPL.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcPPL.TotalValueFormat.FormatString = "p2";
     this.calcPPL.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcPPL.ValueFormat.FormatString = "p2";
     this.calcPPL.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     //
     // repositoryItemTextEditf2
     //
     this.repositoryItemTextEditf2.AutoHeight = false;
     this.repositoryItemTextEditf2.DisplayFormat.FormatString = "f2";
     this.repositoryItemTextEditf2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.repositoryItemTextEditf2.Mask.EditMask = "f2";
     this.repositoryItemTextEditf2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
     this.repositoryItemTextEditf2.Name = "repositoryItemTextEditf2";
     //
     // repositoryItemTextEdit1
     //
     this.repositoryItemTextEdit1.AutoHeight = false;
     this.repositoryItemTextEdit1.Name = "repositoryItemTextEdit1";
     //
     // popupMenuMain
     //
     this.popupMenuMain.Manager = this.barManagerMain;
     this.popupMenuMain.Name = "popupMenuMain";
     //
     // barManagerMain
     //
     this.barManagerMain.Bars.AddRange(new DevExpress.XtraBars.Bar[] {
     this.bar1});
     this.barManagerMain.DockControls.Add(this.barDockControlTop);
     this.barManagerMain.DockControls.Add(this.barDockControlBottom);
     this.barManagerMain.DockControls.Add(this.barDockControlLeft);
     this.barManagerMain.DockControls.Add(this.barDockControlRight);
     this.barManagerMain.Form = this;
     this.barManagerMain.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
     this.bbiExport,
     this.bbiStartDate,
     this.barHeaderItem1,
     this.bbiGetData,
     this.barHeaderItem2,
     this.bbiEndDate});
     this.barManagerMain.MaxItemId = 13;
     this.barManagerMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
     this.repositoryItemDateEdit1,
     this.repositoryItemDateEdit2,
     this.repositoryItemDateEdit3});
     //
     // bar1
     //
     this.bar1.BarName = "Main";
     this.bar1.DockCol = 0;
     this.bar1.DockRow = 0;
     this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top;
     this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
     new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem1),
     new DevExpress.XtraBars.LinkPersistInfo(this.bbiStartDate),
     new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem2),
     new DevExpress.XtraBars.LinkPersistInfo(this.bbiEndDate),
     new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.bbiGetData, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph),
     new DevExpress.XtraBars.LinkPersistInfo(this.bbiExport)});
     this.bar1.Text = "Custom 2";
     //
     // barHeaderItem1
     //
     this.barHeaderItem1.Caption = "Select Date";
     this.barHeaderItem1.Id = 3;
     this.barHeaderItem1.Name = "barHeaderItem1";
     //
     // bbiStartDate
     //
     this.bbiStartDate.Caption = "Date Start";
     this.bbiStartDate.Edit = this.repositoryItemDateEdit1;
     this.bbiStartDate.Id = 2;
     this.bbiStartDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D1));
     this.bbiStartDate.Name = "bbiStartDate";
     this.bbiStartDate.Width = 120;
     //
     // repositoryItemDateEdit1
     //
     this.repositoryItemDateEdit1.AutoHeight = false;
     this.repositoryItemDateEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit1.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit1.Name = "repositoryItemDateEdit1";
     //
     // barHeaderItem2
     //
     this.barHeaderItem2.Caption = "End Date";
     this.barHeaderItem2.Id = 11;
     this.barHeaderItem2.Name = "barHeaderItem2";
     //
     // bbiEndDate
     //
     this.bbiEndDate.Caption = "Date End";
     this.bbiEndDate.Edit = this.repositoryItemDateEdit3;
     this.bbiEndDate.Id = 12;
     this.bbiEndDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D2));
     this.bbiEndDate.Name = "bbiEndDate";
     this.bbiEndDate.Width = 120;
     //
     // repositoryItemDateEdit3
     //
     this.repositoryItemDateEdit3.AutoHeight = false;
     this.repositoryItemDateEdit3.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit3.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit3.Name = "repositoryItemDateEdit3";
     //
     // bbiGetData
     //
     this.bbiGetData.Caption = "Get Data";
     this.bbiGetData.CaptionAlignment = DevExpress.XtraBars.BarItemCaptionAlignment.Right;
     this.bbiGetData.Glyph = global::NestleICSales.Properties.Resources.apply_16x16;
     this.bbiGetData.Id = 9;
     this.bbiGetData.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.G));
     this.bbiGetData.Name = "bbiGetData";
     this.bbiGetData.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiGetData_ItemClick);
     //
     // bbiExport
     //
     this.bbiExport.Caption = "Export";
     this.bbiExport.Glyph = global::NestleICSales.Properties.Resources.Export;
     this.bbiExport.Id = 1;
     this.bbiExport.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.E));
     this.bbiExport.Name = "bbiExport";
     this.bbiExport.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExport_ItemClick);
     //
     // barDockControlTop
     //
     this.barDockControlTop.CausesValidation = false;
     this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top;
     this.barDockControlTop.Location = new System.Drawing.Point(0, 0);
     this.barDockControlTop.Size = new System.Drawing.Size(1132, 31);
     //
     // barDockControlBottom
     //
     this.barDockControlBottom.CausesValidation = false;
     this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
     this.barDockControlBottom.Location = new System.Drawing.Point(0, 311);
     this.barDockControlBottom.Size = new System.Drawing.Size(1132, 0);
     //
     // barDockControlLeft
     //
     this.barDockControlLeft.CausesValidation = false;
     this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
     this.barDockControlLeft.Location = new System.Drawing.Point(0, 31);
     this.barDockControlLeft.Size = new System.Drawing.Size(0, 280);
     //
     // barDockControlRight
     //
     this.barDockControlRight.CausesValidation = false;
     this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
     this.barDockControlRight.Location = new System.Drawing.Point(1132, 31);
     this.barDockControlRight.Size = new System.Drawing.Size(0, 280);
     //
     // repositoryItemDateEdit2
     //
     this.repositoryItemDateEdit2.AutoHeight = false;
     this.repositoryItemDateEdit2.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit2.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit2.Name = "repositoryItemDateEdit2";
     //
     // pivotGridControlMain
     //
     this.pivotGridControlMain.DataSource = this.pro0004BindingSource;
     this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill;
     this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
     this.fieldMaterialNumber1,
     this.fieldTypeName1,
     this.fieldDistributionChannel1,
     this.fieldMaterialName1,
     this.fieldProductBase1,
     this.fieldBrand1,
     this.fieldProductGroup31,
     this.fieldProductGroup21,
     this.fieldProductGroup11,
     this.fieldPriceChanges1,
     this.fieldPricePointRang1,
     this.fieldMaterialType1,
     this.fieldFlavor1,
     this.fieldNPDS1,
     this.fieldPricePoint1,
     this.fieldCases1,
     this.fieldNPS1,
     this.fieldVolume1,
     this.fieldPPL1,
     this.calcCases,
     this.calcNPS,
     this.calcVolume,
     this.calcPPL,
     this.fieldYearNo,
     this.fieldCustHierLevel3Name,
     this.fieldCustomerGroup,
     this.fieldCustomerType,
     this.fieldCustomerType2,
     this.fieldRouteNumber,
     this.fieldSubchannelName});
     pivotGridStyleFormatCondition1.Appearance.ForeColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition1.Appearance.Options.UseForeColor = true;
     pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition1.Field = this.calcCases;
     pivotGridStyleFormatCondition1.FieldName = "calcCases";
     pivotGridStyleFormatCondition1.Value1 = "1";
     pivotGridStyleFormatCondition2.Appearance.ForeColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition2.Appearance.Options.UseForeColor = true;
     pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition2.Field = this.calcCases;
     pivotGridStyleFormatCondition2.FieldName = "calcCases";
     pivotGridStyleFormatCondition2.Value1 = "1";
     pivotGridStyleFormatCondition3.Appearance.ForeColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition3.Appearance.Options.UseForeColor = true;
     pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition3.Field = this.calcNPS;
     pivotGridStyleFormatCondition3.FieldName = "calcNPS";
     pivotGridStyleFormatCondition3.Value1 = "1";
     pivotGridStyleFormatCondition4.Appearance.ForeColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition4.Appearance.Options.UseForeColor = true;
     pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition4.Field = this.calcNPS;
     pivotGridStyleFormatCondition4.FieldName = "calcNPS";
     pivotGridStyleFormatCondition4.Value1 = "1";
     pivotGridStyleFormatCondition5.Appearance.ForeColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition5.Appearance.Options.UseForeColor = true;
     pivotGridStyleFormatCondition5.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition5.Field = this.calcVolume;
     pivotGridStyleFormatCondition5.FieldName = "calcVolume";
     pivotGridStyleFormatCondition5.Value1 = "1";
     pivotGridStyleFormatCondition6.Appearance.ForeColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition6.Appearance.Options.UseForeColor = true;
     pivotGridStyleFormatCondition6.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition6.Field = this.calcVolume;
     pivotGridStyleFormatCondition6.FieldName = "calcVolume";
     pivotGridStyleFormatCondition6.Value1 = "1";
     pivotGridStyleFormatCondition7.Appearance.ForeColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition7.Appearance.Options.UseForeColor = true;
     pivotGridStyleFormatCondition7.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition7.Field = this.calcPPL;
     pivotGridStyleFormatCondition7.FieldName = "calcPPL";
     pivotGridStyleFormatCondition7.Value1 = "1";
     pivotGridStyleFormatCondition8.Appearance.ForeColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition8.Appearance.Options.UseForeColor = true;
     pivotGridStyleFormatCondition8.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition8.Field = this.calcPPL;
     pivotGridStyleFormatCondition8.FieldName = "calcPPL";
     pivotGridStyleFormatCondition8.Value1 = "1";
     this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
     pivotGridStyleFormatCondition1,
     pivotGridStyleFormatCondition2,
     pivotGridStyleFormatCondition3,
     pivotGridStyleFormatCondition4,
     pivotGridStyleFormatCondition5,
     pivotGridStyleFormatCondition6,
     pivotGridStyleFormatCondition7,
     pivotGridStyleFormatCondition8});
     this.pivotGridControlMain.Location = new System.Drawing.Point(0, 31);
     this.pivotGridControlMain.Name = "pivotGridControlMain";
     this.pivotGridControlMain.OptionsData.DataFieldUnboundExpressionMode = DevExpress.XtraPivotGrid.DataFieldUnboundExpressionMode.UseSummaryValues;
     this.pivotGridControlMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
     this.repositoryItemTextEditPer});
     this.pivotGridControlMain.Size = new System.Drawing.Size(1132, 280);
     this.pivotGridControlMain.TabIndex = 14;
     this.pivotGridControlMain.CustomCellValue += new System.EventHandler<DevExpress.XtraPivotGrid.PivotCellValueEventArgs>(this.pivotGridControlMain_CustomCellValue);
     this.pivotGridControlMain.CellDoubleClick += new DevExpress.XtraPivotGrid.PivotCellEventHandler(this.pivotGridControlMain_CellDoubleClick);
     //
     // pro0004BindingSource
     //
     this.pro0004BindingSource.DataMember = "Pro_0004";
     this.pro0004BindingSource.DataSource = this.dsNMQry;
     //
     // dsNMQry
     //
     this.dsNMQry.DataSetName = "dsNMQry";
     this.dsNMQry.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     //
     // fieldMaterialNumber1
     //
     this.fieldMaterialNumber1.AreaIndex = 0;
     this.fieldMaterialNumber1.Caption = "Material Number";
     this.fieldMaterialNumber1.FieldName = "MaterialNumber";
     this.fieldMaterialNumber1.Name = "fieldMaterialNumber1";
     //
     // fieldTypeName1
     //
     this.fieldTypeName1.AreaIndex = 1;
     this.fieldTypeName1.Caption = "Type Name";
     this.fieldTypeName1.FieldName = "TypeName";
     this.fieldTypeName1.Name = "fieldTypeName1";
     //
     // fieldDistributionChannel1
     //
     this.fieldDistributionChannel1.AreaIndex = 2;
     this.fieldDistributionChannel1.Caption = "Distribution Channel";
     this.fieldDistributionChannel1.FieldName = "DistributionChannel";
     this.fieldDistributionChannel1.Name = "fieldDistributionChannel1";
     //
     // fieldMaterialName1
     //
     this.fieldMaterialName1.AreaIndex = 3;
     this.fieldMaterialName1.Caption = "Material Name";
     this.fieldMaterialName1.FieldName = "MaterialName";
     this.fieldMaterialName1.Name = "fieldMaterialName1";
     //
     // fieldProductBase1
     //
     this.fieldProductBase1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldProductBase1.AreaIndex = 1;
     this.fieldProductBase1.Caption = "Product Base";
     this.fieldProductBase1.FieldName = "ProductBase";
     this.fieldProductBase1.Name = "fieldProductBase1";
     //
     // fieldBrand1
     //
     this.fieldBrand1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldBrand1.AreaIndex = 0;
     this.fieldBrand1.Caption = "Brand";
     this.fieldBrand1.FieldName = "Brand";
     this.fieldBrand1.Name = "fieldBrand1";
     this.fieldBrand1.Width = 255;
     //
     // fieldProductGroup31
     //
     this.fieldProductGroup31.AreaIndex = 4;
     this.fieldProductGroup31.Caption = "Product Group3";
     this.fieldProductGroup31.FieldName = "ProductGroup3";
     this.fieldProductGroup31.Name = "fieldProductGroup31";
     //
     // fieldProductGroup21
     //
     this.fieldProductGroup21.AreaIndex = 5;
     this.fieldProductGroup21.Caption = "Product Group2";
     this.fieldProductGroup21.FieldName = "ProductGroup2";
     this.fieldProductGroup21.Name = "fieldProductGroup21";
     //
     // fieldProductGroup11
     //
     this.fieldProductGroup11.AreaIndex = 6;
     this.fieldProductGroup11.Caption = "Product Group1";
     this.fieldProductGroup11.FieldName = "ProductGroup1";
     this.fieldProductGroup11.Name = "fieldProductGroup11";
     //
     // fieldPriceChanges1
     //
     this.fieldPriceChanges1.AreaIndex = 7;
     this.fieldPriceChanges1.Caption = "Price Changes";
     this.fieldPriceChanges1.FieldName = "PriceChanges";
     this.fieldPriceChanges1.Name = "fieldPriceChanges1";
     //
     // fieldPricePointRang1
     //
     this.fieldPricePointRang1.AreaIndex = 8;
     this.fieldPricePointRang1.Caption = "Price Point Rang";
     this.fieldPricePointRang1.FieldName = "PricePointRang";
     this.fieldPricePointRang1.Name = "fieldPricePointRang1";
     //
     // fieldMaterialType1
     //
     this.fieldMaterialType1.AreaIndex = 9;
     this.fieldMaterialType1.Caption = "Material Type";
     this.fieldMaterialType1.FieldName = "MaterialType";
     this.fieldMaterialType1.Name = "fieldMaterialType1";
     //
     // fieldFlavor1
     //
     this.fieldFlavor1.AreaIndex = 10;
     this.fieldFlavor1.Caption = "Flavor";
     this.fieldFlavor1.FieldName = "Flavor";
     this.fieldFlavor1.Name = "fieldFlavor1";
     //
     // fieldNPDS1
     //
     this.fieldNPDS1.AreaIndex = 11;
     this.fieldNPDS1.Caption = "NPDS";
     this.fieldNPDS1.FieldName = "NPDS";
     this.fieldNPDS1.Name = "fieldNPDS1";
     //
     // fieldPricePoint1
     //
     this.fieldPricePoint1.AreaIndex = 12;
     this.fieldPricePoint1.Caption = "Price Point";
     this.fieldPricePoint1.FieldName = "PricePoint";
     this.fieldPricePoint1.Name = "fieldPricePoint1";
     //
     // fieldCases1
     //
     this.fieldCases1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldCases1.AreaIndex = 0;
     this.fieldCases1.Caption = "Cases";
     this.fieldCases1.CellFormat.FormatString = "f2";
     this.fieldCases1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldCases1.EmptyCellText = "0.0";
     this.fieldCases1.EmptyValueText = "0.0";
     this.fieldCases1.FieldName = "Cases";
     this.fieldCases1.GrandTotalCellFormat.FormatString = "f2";
     this.fieldCases1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldCases1.Name = "fieldCases1";
     this.fieldCases1.Options.ShowGrandTotal = false;
     this.fieldCases1.TotalCellFormat.FormatString = "f2";
     this.fieldCases1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldCases1.TotalValueFormat.FormatString = "f2";
     this.fieldCases1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldCases1.ValueFormat.FormatString = "f2";
     this.fieldCases1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     //
     // fieldNPS1
     //
     this.fieldNPS1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldNPS1.AreaIndex = 2;
     this.fieldNPS1.Caption = "NPS";
     this.fieldNPS1.CellFormat.FormatString = "f2";
     this.fieldNPS1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldNPS1.EmptyCellText = "0.0";
     this.fieldNPS1.EmptyValueText = "0.0";
     this.fieldNPS1.FieldName = "NPS";
     this.fieldNPS1.GrandTotalCellFormat.FormatString = "f2";
     this.fieldNPS1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldNPS1.Name = "fieldNPS1";
     this.fieldNPS1.Options.ShowGrandTotal = false;
     this.fieldNPS1.TotalCellFormat.FormatString = "f2";
     this.fieldNPS1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldNPS1.TotalValueFormat.FormatString = "f2";
     this.fieldNPS1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldNPS1.ValueFormat.FormatString = "f2";
     this.fieldNPS1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     //
     // fieldVolume1
     //
     this.fieldVolume1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldVolume1.AreaIndex = 4;
     this.fieldVolume1.Caption = "Volume";
     this.fieldVolume1.CellFormat.FormatString = "f2";
     this.fieldVolume1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldVolume1.EmptyCellText = "0.0";
     this.fieldVolume1.EmptyValueText = "0.0";
     this.fieldVolume1.FieldName = "Volume";
     this.fieldVolume1.GrandTotalCellFormat.FormatString = "f2";
     this.fieldVolume1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldVolume1.Name = "fieldVolume1";
     this.fieldVolume1.Options.ShowGrandTotal = false;
     this.fieldVolume1.TotalCellFormat.FormatString = "f2";
     this.fieldVolume1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldVolume1.TotalValueFormat.FormatString = "f2";
     this.fieldVolume1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldVolume1.ValueFormat.FormatString = "f2";
     this.fieldVolume1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     //
     // fieldPPL1
     //
     this.fieldPPL1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldPPL1.AreaIndex = 6;
     this.fieldPPL1.Caption = "PPL";
     this.fieldPPL1.CellFormat.FormatString = "f2";
     this.fieldPPL1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldPPL1.EmptyCellText = "0.0";
     this.fieldPPL1.EmptyValueText = "0.0";
     this.fieldPPL1.FieldName = "PPL";
     this.fieldPPL1.GrandTotalCellFormat.FormatString = "f2";
     this.fieldPPL1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldPPL1.Name = "fieldPPL1";
     this.fieldPPL1.Options.ShowGrandTotal = false;
     this.fieldPPL1.TotalCellFormat.FormatString = "f2";
     this.fieldPPL1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldPPL1.TotalValueFormat.FormatString = "f2";
     this.fieldPPL1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldPPL1.ValueFormat.FormatString = "f2";
     this.fieldPPL1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     //
     // fieldYearNo
     //
     this.fieldYearNo.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
     this.fieldYearNo.AreaIndex = 0;
     this.fieldYearNo.Caption = "Year";
     this.fieldYearNo.FieldName = "YearNo";
     this.fieldYearNo.Name = "fieldYearNo";
     //
     // fieldCustHierLevel3Name
     //
     this.fieldCustHierLevel3Name.AreaIndex = 13;
     this.fieldCustHierLevel3Name.Caption = "CustHierLevel3";
     this.fieldCustHierLevel3Name.FieldName = "CustHierLevel3Name";
     this.fieldCustHierLevel3Name.Name = "fieldCustHierLevel3Name";
     //
     // fieldCustomerGroup
     //
     this.fieldCustomerGroup.AreaIndex = 14;
     this.fieldCustomerGroup.Caption = "CustomerGroup";
     this.fieldCustomerGroup.FieldName = "CustomerGroup";
     this.fieldCustomerGroup.Name = "fieldCustomerGroup";
     //
     // fieldCustomerType
     //
     this.fieldCustomerType.AreaIndex = 15;
     this.fieldCustomerType.Caption = "CustomerType";
     this.fieldCustomerType.FieldName = "CustomerType";
     this.fieldCustomerType.Name = "fieldCustomerType";
     //
     // fieldCustomerType2
     //
     this.fieldCustomerType2.AreaIndex = 16;
     this.fieldCustomerType2.Caption = "CustomerType2";
     this.fieldCustomerType2.FieldName = "CustomerType2";
     this.fieldCustomerType2.Name = "fieldCustomerType2";
     //
     // fieldRouteNumber
     //
     this.fieldRouteNumber.AreaIndex = 17;
     this.fieldRouteNumber.Caption = "RouteNumber";
     this.fieldRouteNumber.FieldName = "RouteNumber";
     this.fieldRouteNumber.Name = "fieldRouteNumber";
     //
     // fieldSubchannelName
     //
     this.fieldSubchannelName.AreaIndex = 18;
     this.fieldSubchannelName.Caption = "Subchannel";
     this.fieldSubchannelName.FieldName = "SubchannelName";
     this.fieldSubchannelName.Name = "fieldSubchannelName";
     //
     // repositoryItemTextEditPer
     //
     this.repositoryItemTextEditPer.AutoHeight = false;
     this.repositoryItemTextEditPer.DisplayFormat.FormatString = "c";
     this.repositoryItemTextEditPer.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.repositoryItemTextEditPer.Mask.EditMask = "p";
     this.repositoryItemTextEditPer.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
     this.repositoryItemTextEditPer.Mask.UseMaskAsDisplayFormat = true;
     this.repositoryItemTextEditPer.Name = "repositoryItemTextEditPer";
     //
     // pro_0004TableAdapter
     //
     this.pro_0004TableAdapter.ClearBeforeFill = true;
     //
     // QryPro_0004Frm
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
     this.ClientSize = new System.Drawing.Size(1132, 311);
     this.Controls.Add(this.pivotGridControlMain);
     this.Controls.Add(this.barDockControlLeft);
     this.Controls.Add(this.barDockControlRight);
     this.Controls.Add(this.barDockControlBottom);
     this.Controls.Add(this.barDockControlTop);
     this.Icon = global::NestleICSales.Properties.Resources.Qry16;
     this.Name = "QryPro_0004Frm";
     this.Text = "Sales Per SKU";
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pro0004BindingSource)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPer)).EndInit();
     this.ResumeLayout(false);
 }
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition5 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition6 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition7 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition8 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition9 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition10 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition11 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition12 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition13 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition14 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition15 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition16 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     this.calcAPOSVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcAPOSVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcINVVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcINVVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcNPSVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcNPSVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcDSVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcDSVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField();
     this.repositoryItemTextEditPers = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
     this.repositoryItemTextEditf2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
     this.repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
     this.popupMenuMain = new DevExpress.XtraBars.PopupMenu(this.components);
     this.barManagerMain = new DevExpress.XtraBars.BarManager(this.components);
     this.bar1 = new DevExpress.XtraBars.Bar();
     this.barHeaderItem1 = new DevExpress.XtraBars.BarHeaderItem();
     this.bbiStartDate = new DevExpress.XtraBars.BarEditItem();
     this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
     this.barHeaderItem2 = new DevExpress.XtraBars.BarHeaderItem();
     this.bbiEndDate = new DevExpress.XtraBars.BarEditItem();
     this.repositoryItemDateEdit3 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
     this.bbiGetData = new DevExpress.XtraBars.BarLargeButtonItem();
     this.bbiExport = new DevExpress.XtraBars.BarButtonItem();
     this.barDockControlTop = new DevExpress.XtraBars.BarDockControl();
     this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl();
     this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl();
     this.barDockControlRight = new DevExpress.XtraBars.BarDockControl();
     this.repositoryItemDateEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
     this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.pro0001BindingSource = new System.Windows.Forms.BindingSource(this.components);
     this.dsNMQry = new NestleICSales.DataSources.dsQry();
     this.fieldRouteNumber1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldRouteName1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldSupervisor1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldRouteBrand1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPlantSalesDistrict1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPlantName1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPlantBaseName1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldDistributionChannel1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldAPOSLD = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTargetAPOSDay = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldAPOS = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTargetAPOS = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldINVLD = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTargetINVDay = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldINV = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTargetINV = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldNPSLD = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTargetNPSDay = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldNPS = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTargetNPS = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldDSLD1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTargetDSDay = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldDS = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTargetDS = new DevExpress.XtraPivotGrid.PivotGridField();
     this.dxValidationProviderMain = new DevExpress.XtraEditors.DXErrorProvider.DXValidationProvider(this.components);
     this.pro_0001TableAdapter = new NestleICSales.DataSources.dsQryTableAdapters.Pro_0001TableAdapter();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.pro0001BindingSource)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).BeginInit();
     this.SuspendLayout();
     //
     // calcAPOSVsTargetDay
     //
     this.calcAPOSVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcAPOSVsTargetDay.AreaIndex = 2;
     this.calcAPOSVsTargetDay.Caption = "APOS Vs Target LD";
     this.calcAPOSVsTargetDay.EmptyCellText = "0";
     this.calcAPOSVsTargetDay.EmptyValueText = "0";
     this.calcAPOSVsTargetDay.GrandTotalCellFormat.FormatString = "p";
     this.calcAPOSVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcAPOSVsTargetDay.Name = "calcAPOSVsTargetDay";
     this.calcAPOSVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
     this.calcAPOSVsTargetDay.UnboundExpression = "([APOSLD] * 1.0) / [TargetAPOSDay]";
     this.calcAPOSVsTargetDay.UnboundFieldName = "calcAPOSVsTarget";
     this.calcAPOSVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
     //
     // calcAPOSVsTargetMonth
     //
     this.calcAPOSVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcAPOSVsTargetMonth.AreaIndex = 5;
     this.calcAPOSVsTargetMonth.Caption = "APOS Vs Target MTD";
     this.calcAPOSVsTargetMonth.EmptyCellText = "0";
     this.calcAPOSVsTargetMonth.EmptyValueText = "0";
     this.calcAPOSVsTargetMonth.GrandTotalCellFormat.FormatString = "p";
     this.calcAPOSVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcAPOSVsTargetMonth.Name = "calcAPOSVsTargetMonth";
     this.calcAPOSVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
     this.calcAPOSVsTargetMonth.UnboundExpression = "([APOS] * 1.0) / [TargetAPOS]";
     this.calcAPOSVsTargetMonth.UnboundFieldName = "calcAPOSVsTargetMonth";
     this.calcAPOSVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
     //
     // calcINVVsTargetDay
     //
     this.calcINVVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcINVVsTargetDay.AreaIndex = 8;
     this.calcINVVsTargetDay.Caption = "INV Vs Target LD";
     this.calcINVVsTargetDay.EmptyCellText = "0";
     this.calcINVVsTargetDay.EmptyValueText = "0";
     this.calcINVVsTargetDay.GrandTotalCellFormat.FormatString = "p";
     this.calcINVVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcINVVsTargetDay.Name = "calcINVVsTargetDay";
     this.calcINVVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
     this.calcINVVsTargetDay.UnboundExpression = "([INVLD] * 1.0) / [TargetINVDay]";
     this.calcINVVsTargetDay.UnboundFieldName = "calcINVVsTargetDay";
     this.calcINVVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
     //
     // calcINVVsTargetMonth
     //
     this.calcINVVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcINVVsTargetMonth.AreaIndex = 11;
     this.calcINVVsTargetMonth.Caption = "INV Vs Target MTD";
     this.calcINVVsTargetMonth.EmptyCellText = "0";
     this.calcINVVsTargetMonth.EmptyValueText = "0";
     this.calcINVVsTargetMonth.GrandTotalCellFormat.FormatString = "p";
     this.calcINVVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcINVVsTargetMonth.Name = "calcINVVsTargetMonth";
     this.calcINVVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
     this.calcINVVsTargetMonth.UnboundExpression = "([INV] * 1.0) / [TargetINV]";
     this.calcINVVsTargetMonth.UnboundFieldName = "calcINVVsTargetMonth";
     this.calcINVVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
     //
     // calcNPSVsTargetDay
     //
     this.calcNPSVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcNPSVsTargetDay.AreaIndex = 14;
     this.calcNPSVsTargetDay.Caption = "NPS Vs Target LD";
     this.calcNPSVsTargetDay.EmptyCellText = "0";
     this.calcNPSVsTargetDay.EmptyValueText = "0";
     this.calcNPSVsTargetDay.GrandTotalCellFormat.FormatString = "p";
     this.calcNPSVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcNPSVsTargetDay.Name = "calcNPSVsTargetDay";
     this.calcNPSVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
     this.calcNPSVsTargetDay.UnboundExpression = "([NPSLD] * 1.0) / [TargetNPSDay]";
     this.calcNPSVsTargetDay.UnboundFieldName = "calcNPSVsTargetDay";
     this.calcNPSVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
     //
     // calcNPSVsTargetMonth
     //
     this.calcNPSVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcNPSVsTargetMonth.AreaIndex = 17;
     this.calcNPSVsTargetMonth.Caption = "NPS Vs Target MTD";
     this.calcNPSVsTargetMonth.EmptyCellText = "0";
     this.calcNPSVsTargetMonth.EmptyValueText = "0";
     this.calcNPSVsTargetMonth.GrandTotalCellFormat.FormatString = "p";
     this.calcNPSVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcNPSVsTargetMonth.Name = "calcNPSVsTargetMonth";
     this.calcNPSVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
     this.calcNPSVsTargetMonth.UnboundExpression = "([NPS] * 1.0) / [TargetNPS]";
     this.calcNPSVsTargetMonth.UnboundFieldName = "calcNPSVsTargetMonth";
     this.calcNPSVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
     //
     // calcDSVsTargetDay
     //
     this.calcDSVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcDSVsTargetDay.AreaIndex = 20;
     this.calcDSVsTargetDay.Caption = "DS Vs Target LD";
     this.calcDSVsTargetDay.EmptyCellText = "0";
     this.calcDSVsTargetDay.EmptyValueText = "0";
     this.calcDSVsTargetDay.GrandTotalCellFormat.FormatString = "p";
     this.calcDSVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcDSVsTargetDay.Name = "calcDSVsTargetDay";
     this.calcDSVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
     this.calcDSVsTargetDay.UnboundExpression = "([DSLD] * 1.0) / [TargetDSDay]";
     this.calcDSVsTargetDay.UnboundFieldName = "calcDSVsTargetDay";
     this.calcDSVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
     //
     // calcDSVsTargetMonth
     //
     this.calcDSVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcDSVsTargetMonth.AreaIndex = 23;
     this.calcDSVsTargetMonth.Caption = "DS Vs Target MTD";
     this.calcDSVsTargetMonth.EmptyCellText = "0";
     this.calcDSVsTargetMonth.EmptyValueText = "0";
     this.calcDSVsTargetMonth.GrandTotalCellFormat.FormatString = "p";
     this.calcDSVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.calcDSVsTargetMonth.Name = "calcDSVsTargetMonth";
     this.calcDSVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
     this.calcDSVsTargetMonth.UnboundExpression = "([DS] * 1.0) / [TargetDS]";
     this.calcDSVsTargetMonth.UnboundFieldName = "calcDSVsTargetMonth";
     this.calcDSVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
     //
     // repositoryItemTextEditPers
     //
     this.repositoryItemTextEditPers.AutoHeight = false;
     this.repositoryItemTextEditPers.EditFormat.FormatString = "P1";
     this.repositoryItemTextEditPers.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.repositoryItemTextEditPers.ExportMode = DevExpress.XtraEditors.Repository.ExportMode.DisplayText;
     this.repositoryItemTextEditPers.Mask.EditMask = "P1";
     this.repositoryItemTextEditPers.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
     this.repositoryItemTextEditPers.Mask.UseMaskAsDisplayFormat = true;
     this.repositoryItemTextEditPers.Name = "repositoryItemTextEditPers";
     //
     // repositoryItemTextEditf2
     //
     this.repositoryItemTextEditf2.AutoHeight = false;
     this.repositoryItemTextEditf2.DisplayFormat.FormatString = "f2";
     this.repositoryItemTextEditf2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.repositoryItemTextEditf2.Mask.EditMask = "f2";
     this.repositoryItemTextEditf2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
     this.repositoryItemTextEditf2.Name = "repositoryItemTextEditf2";
     //
     // repositoryItemTextEdit1
     //
     this.repositoryItemTextEdit1.AutoHeight = false;
     this.repositoryItemTextEdit1.Name = "repositoryItemTextEdit1";
     //
     // popupMenuMain
     //
     this.popupMenuMain.Manager = this.barManagerMain;
     this.popupMenuMain.Name = "popupMenuMain";
     //
     // barManagerMain
     //
     this.barManagerMain.Bars.AddRange(new DevExpress.XtraBars.Bar[] {
     this.bar1});
     this.barManagerMain.DockControls.Add(this.barDockControlTop);
     this.barManagerMain.DockControls.Add(this.barDockControlBottom);
     this.barManagerMain.DockControls.Add(this.barDockControlLeft);
     this.barManagerMain.DockControls.Add(this.barDockControlRight);
     this.barManagerMain.Form = this;
     this.barManagerMain.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
     this.bbiExport,
     this.bbiStartDate,
     this.barHeaderItem1,
     this.bbiGetData,
     this.barHeaderItem2,
     this.bbiEndDate});
     this.barManagerMain.MaxItemId = 12;
     this.barManagerMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
     this.repositoryItemDateEdit1,
     this.repositoryItemDateEdit2,
     this.repositoryItemDateEdit3});
     //
     // bar1
     //
     this.bar1.BarName = "Main";
     this.bar1.DockCol = 0;
     this.bar1.DockRow = 0;
     this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top;
     this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
     new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem1),
     new DevExpress.XtraBars.LinkPersistInfo(this.bbiStartDate),
     new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem2),
     new DevExpress.XtraBars.LinkPersistInfo(this.bbiEndDate),
     new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.bbiGetData, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph),
     new DevExpress.XtraBars.LinkPersistInfo(this.bbiExport)});
     this.bar1.Text = "Custom 2";
     //
     // barHeaderItem1
     //
     this.barHeaderItem1.Caption = "Start Date";
     this.barHeaderItem1.Id = 3;
     this.barHeaderItem1.Name = "barHeaderItem1";
     //
     // bbiStartDate
     //
     this.bbiStartDate.Caption = "Start Date";
     this.bbiStartDate.Edit = this.repositoryItemDateEdit1;
     this.bbiStartDate.Id = 2;
     this.bbiStartDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D1));
     this.bbiStartDate.Name = "bbiStartDate";
     this.bbiStartDate.Width = 120;
     //
     // repositoryItemDateEdit1
     //
     this.repositoryItemDateEdit1.AutoHeight = false;
     this.repositoryItemDateEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit1.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit1.Name = "repositoryItemDateEdit1";
     //
     // barHeaderItem2
     //
     this.barHeaderItem2.Caption = "EndDate";
     this.barHeaderItem2.Id = 10;
     this.barHeaderItem2.Name = "barHeaderItem2";
     //
     // bbiEndDate
     //
     this.bbiEndDate.Caption = "End Date";
     this.bbiEndDate.Edit = this.repositoryItemDateEdit3;
     this.bbiEndDate.Id = 11;
     this.bbiEndDate.Name = "bbiEndDate";
     this.bbiEndDate.Width = 120;
     //
     // repositoryItemDateEdit3
     //
     this.repositoryItemDateEdit3.AutoHeight = false;
     this.repositoryItemDateEdit3.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit3.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit3.Name = "repositoryItemDateEdit3";
     //
     // bbiGetData
     //
     this.bbiGetData.Caption = "Get Data";
     this.bbiGetData.CaptionAlignment = DevExpress.XtraBars.BarItemCaptionAlignment.Right;
     this.bbiGetData.Glyph = global::NestleICSales.Properties.Resources.apply_16x16;
     this.bbiGetData.Id = 9;
     this.bbiGetData.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.G));
     this.bbiGetData.Name = "bbiGetData";
     this.bbiGetData.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiGetData_ItemClick);
     //
     // bbiExport
     //
     this.bbiExport.Caption = "Export";
     this.bbiExport.Glyph = global::NestleICSales.Properties.Resources.Export;
     this.bbiExport.Id = 1;
     this.bbiExport.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.E));
     this.bbiExport.Name = "bbiExport";
     this.bbiExport.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExport_ItemClick);
     //
     // barDockControlTop
     //
     this.barDockControlTop.CausesValidation = false;
     this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top;
     this.barDockControlTop.Location = new System.Drawing.Point(0, 0);
     this.barDockControlTop.Size = new System.Drawing.Size(1132, 31);
     //
     // barDockControlBottom
     //
     this.barDockControlBottom.CausesValidation = false;
     this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
     this.barDockControlBottom.Location = new System.Drawing.Point(0, 311);
     this.barDockControlBottom.Size = new System.Drawing.Size(1132, 0);
     //
     // barDockControlLeft
     //
     this.barDockControlLeft.CausesValidation = false;
     this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
     this.barDockControlLeft.Location = new System.Drawing.Point(0, 31);
     this.barDockControlLeft.Size = new System.Drawing.Size(0, 280);
     //
     // barDockControlRight
     //
     this.barDockControlRight.CausesValidation = false;
     this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
     this.barDockControlRight.Location = new System.Drawing.Point(1132, 31);
     this.barDockControlRight.Size = new System.Drawing.Size(0, 280);
     //
     // repositoryItemDateEdit2
     //
     this.repositoryItemDateEdit2.AutoHeight = false;
     this.repositoryItemDateEdit2.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit2.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit2.Name = "repositoryItemDateEdit2";
     //
     // pivotGridControlMain
     //
     this.pivotGridControlMain.DataSource = this.pro0001BindingSource;
     this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill;
     this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
     this.fieldRouteNumber1,
     this.fieldRouteName1,
     this.fieldSupervisor1,
     this.fieldRouteBrand1,
     this.fieldPlantSalesDistrict1,
     this.fieldPlantName1,
     this.fieldPlantBaseName1,
     this.fieldDistributionChannel1,
     this.fieldAPOSLD,
     this.fieldTargetAPOSDay,
     this.fieldAPOS,
     this.fieldTargetAPOS,
     this.fieldINVLD,
     this.fieldTargetINVDay,
     this.fieldINV,
     this.fieldTargetINV,
     this.fieldNPSLD,
     this.fieldTargetNPSDay,
     this.fieldNPS,
     this.fieldTargetNPS,
     this.fieldDSLD1,
     this.fieldTargetDSDay,
     this.fieldDS,
     this.fieldTargetDS,
     this.calcAPOSVsTargetDay,
     this.calcAPOSVsTargetMonth,
     this.calcINVVsTargetDay,
     this.calcINVVsTargetMonth,
     this.calcNPSVsTargetDay,
     this.calcNPSVsTargetMonth,
     this.calcDSVsTargetDay,
     this.calcDSVsTargetMonth});
     pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition1.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition1.Field = this.calcAPOSVsTargetDay;
     pivotGridStyleFormatCondition1.FieldName = "calcAPOSVsTargetDay";
     pivotGridStyleFormatCondition1.Value1 = "1";
     pivotGridStyleFormatCondition2.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition2.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition2.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition2.Field = this.calcAPOSVsTargetDay;
     pivotGridStyleFormatCondition2.FieldName = "calcAPOSVsTargetDay";
     pivotGridStyleFormatCondition2.Value1 = "1";
     pivotGridStyleFormatCondition3.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition3.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition3.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition3.Field = this.calcAPOSVsTargetMonth;
     pivotGridStyleFormatCondition3.FieldName = "calcAPOSVsTargetMonth";
     pivotGridStyleFormatCondition3.Value1 = "1";
     pivotGridStyleFormatCondition4.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition4.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition4.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition4.Field = this.calcAPOSVsTargetMonth;
     pivotGridStyleFormatCondition4.FieldName = "calcAPOSVsTargetMonth";
     pivotGridStyleFormatCondition4.Value1 = "1";
     pivotGridStyleFormatCondition5.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition5.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition5.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition5.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition5.Field = this.calcINVVsTargetDay;
     pivotGridStyleFormatCondition5.FieldName = "calcINVVsTargetDay";
     pivotGridStyleFormatCondition5.Value1 = "1";
     pivotGridStyleFormatCondition6.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition6.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition6.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition6.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition6.Field = this.calcINVVsTargetDay;
     pivotGridStyleFormatCondition6.FieldName = "calcINVVsTargetDay";
     pivotGridStyleFormatCondition6.Value1 = "1";
     pivotGridStyleFormatCondition7.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition7.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition7.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition7.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition7.Field = this.calcINVVsTargetMonth;
     pivotGridStyleFormatCondition7.FieldName = "calcINVVsTargetMonth";
     pivotGridStyleFormatCondition7.Value1 = "1";
     pivotGridStyleFormatCondition8.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition8.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition8.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition8.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition8.Field = this.calcINVVsTargetMonth;
     pivotGridStyleFormatCondition8.FieldName = "calcINVVsTargetMonth";
     pivotGridStyleFormatCondition8.Value1 = "1";
     pivotGridStyleFormatCondition9.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition9.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition9.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition9.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition9.Field = this.calcNPSVsTargetDay;
     pivotGridStyleFormatCondition9.FieldName = "calcNPSVsTargetDay";
     pivotGridStyleFormatCondition9.Value1 = "1";
     pivotGridStyleFormatCondition10.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition10.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition10.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition10.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition10.Field = this.calcNPSVsTargetDay;
     pivotGridStyleFormatCondition10.FieldName = "calcNPSVsTargetDay";
     pivotGridStyleFormatCondition10.Value1 = "1";
     pivotGridStyleFormatCondition11.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition11.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition11.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition11.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition11.Field = this.calcNPSVsTargetMonth;
     pivotGridStyleFormatCondition11.FieldName = "calcNPSVsTargetMonth";
     pivotGridStyleFormatCondition11.Value1 = "1";
     pivotGridStyleFormatCondition12.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition12.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition12.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition12.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition12.Field = this.calcNPSVsTargetMonth;
     pivotGridStyleFormatCondition12.FieldName = "calcNPSVsTargetMonth";
     pivotGridStyleFormatCondition12.Value1 = "1";
     pivotGridStyleFormatCondition13.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition13.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition13.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition13.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition13.Field = this.calcDSVsTargetDay;
     pivotGridStyleFormatCondition13.FieldName = "calcDSVsTargetDay";
     pivotGridStyleFormatCondition13.Value1 = "1";
     pivotGridStyleFormatCondition14.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition14.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition14.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition14.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition14.Field = this.calcDSVsTargetDay;
     pivotGridStyleFormatCondition14.FieldName = "calcDSVsTargetDay";
     pivotGridStyleFormatCondition14.Value1 = "1";
     pivotGridStyleFormatCondition15.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition15.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition15.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition15.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition15.Field = this.calcDSVsTargetMonth;
     pivotGridStyleFormatCondition15.FieldName = "calcDSVsTargetMonth";
     pivotGridStyleFormatCondition15.Value1 = "1";
     pivotGridStyleFormatCondition16.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition16.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition16.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition16.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition16.Field = this.calcDSVsTargetMonth;
     pivotGridStyleFormatCondition16.FieldName = "calcDSVsTargetMonth";
     pivotGridStyleFormatCondition16.Value1 = "1";
     this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
     pivotGridStyleFormatCondition1,
     pivotGridStyleFormatCondition2,
     pivotGridStyleFormatCondition3,
     pivotGridStyleFormatCondition4,
     pivotGridStyleFormatCondition5,
     pivotGridStyleFormatCondition6,
     pivotGridStyleFormatCondition7,
     pivotGridStyleFormatCondition8,
     pivotGridStyleFormatCondition9,
     pivotGridStyleFormatCondition10,
     pivotGridStyleFormatCondition11,
     pivotGridStyleFormatCondition12,
     pivotGridStyleFormatCondition13,
     pivotGridStyleFormatCondition14,
     pivotGridStyleFormatCondition15,
     pivotGridStyleFormatCondition16});
     this.pivotGridControlMain.Location = new System.Drawing.Point(0, 31);
     this.pivotGridControlMain.Name = "pivotGridControlMain";
     this.pivotGridControlMain.OptionsPrint.PrintColumnHeaders = DevExpress.Utils.DefaultBoolean.False;
     this.pivotGridControlMain.OptionsPrint.PrintDataHeaders = DevExpress.Utils.DefaultBoolean.False;
     this.pivotGridControlMain.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False;
     this.pivotGridControlMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
     this.repositoryItemTextEditPers});
     this.pivotGridControlMain.Size = new System.Drawing.Size(1132, 280);
     this.pivotGridControlMain.TabIndex = 9;
     //
     // pro0001BindingSource
     //
     this.pro0001BindingSource.DataMember = "Pro_0001";
     this.pro0001BindingSource.DataSource = this.dsNMQry;
     //
     // dsNMQry
     //
     this.dsNMQry.DataSetName = "dsNMQry";
     this.dsNMQry.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     //
     // fieldRouteNumber1
     //
     this.fieldRouteNumber1.AreaIndex = 0;
     this.fieldRouteNumber1.Caption = "Route Number";
     this.fieldRouteNumber1.FieldName = "RouteNumber";
     this.fieldRouteNumber1.Name = "fieldRouteNumber1";
     //
     // fieldRouteName1
     //
     this.fieldRouteName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldRouteName1.AreaIndex = 1;
     this.fieldRouteName1.Caption = "Route Name";
     this.fieldRouteName1.FieldName = "RouteName";
     this.fieldRouteName1.Name = "fieldRouteName1";
     //
     // fieldSupervisor1
     //
     this.fieldSupervisor1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldSupervisor1.AreaIndex = 0;
     this.fieldSupervisor1.Caption = "Supervisor";
     this.fieldSupervisor1.FieldName = "Supervisor";
     this.fieldSupervisor1.Name = "fieldSupervisor1";
     //
     // fieldRouteBrand1
     //
     this.fieldRouteBrand1.AreaIndex = 1;
     this.fieldRouteBrand1.Caption = "Route Brand";
     this.fieldRouteBrand1.FieldName = "RouteBrand";
     this.fieldRouteBrand1.Name = "fieldRouteBrand1";
     //
     // fieldPlantSalesDistrict1
     //
     this.fieldPlantSalesDistrict1.AreaIndex = 2;
     this.fieldPlantSalesDistrict1.Caption = "Plant Sales District";
     this.fieldPlantSalesDistrict1.FieldName = "PlantSalesDistrict";
     this.fieldPlantSalesDistrict1.Name = "fieldPlantSalesDistrict1";
     //
     // fieldPlantName1
     //
     this.fieldPlantName1.AreaIndex = 3;
     this.fieldPlantName1.Caption = "Plant Name";
     this.fieldPlantName1.FieldName = "PlantName";
     this.fieldPlantName1.Name = "fieldPlantName1";
     //
     // fieldPlantBaseName1
     //
     this.fieldPlantBaseName1.AreaIndex = 4;
     this.fieldPlantBaseName1.Caption = "Plant Base Name";
     this.fieldPlantBaseName1.FieldName = "PlantBaseName";
     this.fieldPlantBaseName1.Name = "fieldPlantBaseName1";
     //
     // fieldDistributionChannel1
     //
     this.fieldDistributionChannel1.AreaIndex = 5;
     this.fieldDistributionChannel1.Caption = "Distribution Channel";
     this.fieldDistributionChannel1.FieldName = "DistributionChannel";
     this.fieldDistributionChannel1.Name = "fieldDistributionChannel1";
     //
     // fieldAPOSLD
     //
     this.fieldAPOSLD.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldAPOSLD.AreaIndex = 0;
     this.fieldAPOSLD.Caption = "APOS LD";
     this.fieldAPOSLD.CellFormat.FormatString = "f2";
     this.fieldAPOSLD.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldAPOSLD.EmptyCellText = "0";
     this.fieldAPOSLD.EmptyValueText = "0";
     this.fieldAPOSLD.FieldName = "APOSLD";
     this.fieldAPOSLD.Name = "fieldAPOSLD";
     //
     // fieldTargetAPOSDay
     //
     this.fieldTargetAPOSDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldTargetAPOSDay.AreaIndex = 1;
     this.fieldTargetAPOSDay.Caption = "APOS Target LD";
     this.fieldTargetAPOSDay.CellFormat.FormatString = "f2";
     this.fieldTargetAPOSDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldTargetAPOSDay.EmptyCellText = "0";
     this.fieldTargetAPOSDay.EmptyValueText = "0";
     this.fieldTargetAPOSDay.FieldName = "TargetAPOSDay";
     this.fieldTargetAPOSDay.Name = "fieldTargetAPOSDay";
     //
     // fieldAPOS
     //
     this.fieldAPOS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldAPOS.AreaIndex = 3;
     this.fieldAPOS.Caption = "APOS MTD";
     this.fieldAPOS.CellFormat.FormatString = "f2";
     this.fieldAPOS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldAPOS.EmptyCellText = "0";
     this.fieldAPOS.EmptyValueText = "0";
     this.fieldAPOS.FieldName = "APOS";
     this.fieldAPOS.Name = "fieldAPOS";
     //
     // fieldTargetAPOS
     //
     this.fieldTargetAPOS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldTargetAPOS.AreaIndex = 4;
     this.fieldTargetAPOS.Caption = "APOS Target MTD";
     this.fieldTargetAPOS.CellFormat.FormatString = "f2";
     this.fieldTargetAPOS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldTargetAPOS.EmptyCellText = "0";
     this.fieldTargetAPOS.EmptyValueText = "0";
     this.fieldTargetAPOS.FieldName = "TargetAPOS";
     this.fieldTargetAPOS.Name = "fieldTargetAPOS";
     //
     // fieldINVLD
     //
     this.fieldINVLD.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldINVLD.AreaIndex = 6;
     this.fieldINVLD.Caption = "INV LD";
     this.fieldINVLD.CellFormat.FormatString = "f2";
     this.fieldINVLD.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldINVLD.EmptyCellText = "0";
     this.fieldINVLD.EmptyValueText = "0";
     this.fieldINVLD.FieldName = "INVLD";
     this.fieldINVLD.Name = "fieldINVLD";
     //
     // fieldTargetINVDay
     //
     this.fieldTargetINVDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldTargetINVDay.AreaIndex = 7;
     this.fieldTargetINVDay.Caption = "INV Target LD";
     this.fieldTargetINVDay.CellFormat.FormatString = "f2";
     this.fieldTargetINVDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldTargetINVDay.EmptyCellText = "0";
     this.fieldTargetINVDay.EmptyValueText = "0";
     this.fieldTargetINVDay.FieldName = "TargetINVDay";
     this.fieldTargetINVDay.Name = "fieldTargetINVDay";
     //
     // fieldINV
     //
     this.fieldINV.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldINV.AreaIndex = 9;
     this.fieldINV.Caption = "INV MTD";
     this.fieldINV.CellFormat.FormatString = "f2";
     this.fieldINV.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldINV.EmptyCellText = "0";
     this.fieldINV.EmptyValueText = "0";
     this.fieldINV.FieldName = "INV";
     this.fieldINV.Name = "fieldINV";
     //
     // fieldTargetINV
     //
     this.fieldTargetINV.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldTargetINV.AreaIndex = 10;
     this.fieldTargetINV.Caption = "INV Target MTD";
     this.fieldTargetINV.CellFormat.FormatString = "f2";
     this.fieldTargetINV.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldTargetINV.EmptyCellText = "0";
     this.fieldTargetINV.EmptyValueText = "0";
     this.fieldTargetINV.FieldName = "TargetINV";
     this.fieldTargetINV.Name = "fieldTargetINV";
     //
     // fieldNPSLD
     //
     this.fieldNPSLD.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldNPSLD.AreaIndex = 12;
     this.fieldNPSLD.Caption = "NPS LD";
     this.fieldNPSLD.CellFormat.FormatString = "f2";
     this.fieldNPSLD.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldNPSLD.EmptyCellText = "0";
     this.fieldNPSLD.EmptyValueText = "0";
     this.fieldNPSLD.FieldName = "NPSLD";
     this.fieldNPSLD.Name = "fieldNPSLD";
     //
     // fieldTargetNPSDay
     //
     this.fieldTargetNPSDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldTargetNPSDay.AreaIndex = 13;
     this.fieldTargetNPSDay.Caption = "NPS Target LD";
     this.fieldTargetNPSDay.CellFormat.FormatString = "f2";
     this.fieldTargetNPSDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldTargetNPSDay.EmptyCellText = "0";
     this.fieldTargetNPSDay.EmptyValueText = "0";
     this.fieldTargetNPSDay.FieldName = "TargetNPSDay";
     this.fieldTargetNPSDay.Name = "fieldTargetNPSDay";
     //
     // fieldNPS
     //
     this.fieldNPS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldNPS.AreaIndex = 15;
     this.fieldNPS.Caption = "NPS MTD";
     this.fieldNPS.CellFormat.FormatString = "f2";
     this.fieldNPS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldNPS.EmptyCellText = "0";
     this.fieldNPS.EmptyValueText = "0";
     this.fieldNPS.FieldName = "NPS";
     this.fieldNPS.Name = "fieldNPS";
     //
     // fieldTargetNPS
     //
     this.fieldTargetNPS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldTargetNPS.AreaIndex = 16;
     this.fieldTargetNPS.Caption = "NPS Target MTD";
     this.fieldTargetNPS.CellFormat.FormatString = "f2";
     this.fieldTargetNPS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldTargetNPS.EmptyCellText = "0";
     this.fieldTargetNPS.EmptyValueText = "0";
     this.fieldTargetNPS.FieldName = "TargetNPS";
     this.fieldTargetNPS.Name = "fieldTargetNPS";
     //
     // fieldDSLD1
     //
     this.fieldDSLD1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldDSLD1.AreaIndex = 18;
     this.fieldDSLD1.Caption = "DS LD";
     this.fieldDSLD1.CellFormat.FormatString = "f2";
     this.fieldDSLD1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldDSLD1.EmptyCellText = "0";
     this.fieldDSLD1.EmptyValueText = "0";
     this.fieldDSLD1.FieldName = "DSLD";
     this.fieldDSLD1.Name = "fieldDSLD1";
     //
     // fieldTargetDSDay
     //
     this.fieldTargetDSDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldTargetDSDay.AreaIndex = 19;
     this.fieldTargetDSDay.Caption = "DS Target LD";
     this.fieldTargetDSDay.CellFormat.FormatString = "f2";
     this.fieldTargetDSDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldTargetDSDay.EmptyCellText = "0";
     this.fieldTargetDSDay.EmptyValueText = "0";
     this.fieldTargetDSDay.FieldName = "TargetDSDay";
     this.fieldTargetDSDay.Name = "fieldTargetDSDay";
     //
     // fieldDS
     //
     this.fieldDS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldDS.AreaIndex = 21;
     this.fieldDS.Caption = "DS MTD";
     this.fieldDS.CellFormat.FormatString = "f2";
     this.fieldDS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldDS.EmptyCellText = "0";
     this.fieldDS.EmptyValueText = "0";
     this.fieldDS.FieldName = "DS";
     this.fieldDS.Name = "fieldDS";
     //
     // fieldTargetDS
     //
     this.fieldTargetDS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldTargetDS.AreaIndex = 22;
     this.fieldTargetDS.Caption = "DS Target MTD";
     this.fieldTargetDS.CellFormat.FormatString = "f2";
     this.fieldTargetDS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldTargetDS.EmptyCellText = "0";
     this.fieldTargetDS.EmptyValueText = "0";
     this.fieldTargetDS.FieldName = "TargetDS";
     this.fieldTargetDS.Name = "fieldTargetDS";
     //
     // pro_0001TableAdapter
     //
     this.pro_0001TableAdapter.ClearBeforeFill = true;
     //
     // QryPro_0001BFrm
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
     this.ClientSize = new System.Drawing.Size(1132, 311);
     this.Controls.Add(this.pivotGridControlMain);
     this.Controls.Add(this.barDockControlLeft);
     this.Controls.Add(this.barDockControlRight);
     this.Controls.Add(this.barDockControlBottom);
     this.Controls.Add(this.barDockControlTop);
     this.Icon = global::NestleICSales.Properties.Resources.Qry16;
     this.Name = "QryPro_0001BFrm";
     this.Text = "Actual KPI Vs Target";
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pro0001BindingSource)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).EndInit();
     this.ResumeLayout(false);
 }
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
     this.fieldRouteBrand1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.repositoryItemTextEditPers = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
     this.repositoryItemTextEditf2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
     this.repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
     this.popupMenuMain = new DevExpress.XtraBars.PopupMenu(this.components);
     this.barManagerMain = new DevExpress.XtraBars.BarManager(this.components);
     this.bar1 = new DevExpress.XtraBars.Bar();
     this.barHeaderItem1 = new DevExpress.XtraBars.BarHeaderItem();
     this.bbiStartDate = new DevExpress.XtraBars.BarEditItem();
     this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
     this.bbiGetData = new DevExpress.XtraBars.BarLargeButtonItem();
     this.bbiExport = new DevExpress.XtraBars.BarButtonItem();
     this.barDockControlTop = new DevExpress.XtraBars.BarDockControl();
     this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl();
     this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl();
     this.barDockControlRight = new DevExpress.XtraBars.BarDockControl();
     this.repositoryItemDateEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
     this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.dsNMQry = new NestleICSales.DataSources.dsQry();
     this.fieldRouteNumber1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldRouteName1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldSupervisor1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPlantSalesDistrict1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPlantName1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldPlantBaseName1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldDistributionChannel1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldActive1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldEquipment1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldCustomer = new DevExpress.XtraPivotGrid.PivotGridField();
     this.calcEqAvg = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldCType = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldCustomerType = new DevExpress.XtraPivotGrid.PivotGridField();
     this.dxValidationProviderMain = new DevExpress.XtraEditors.DXErrorProvider.DXValidationProvider(this.components);
     this.pro0002BindingSource = new System.Windows.Forms.BindingSource(this.components);
     this.pro_0002TableAdapter = new NestleICSales.DataSources.dsQryTableAdapters.Pro_0002TableAdapter();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.pro0002BindingSource)).BeginInit();
     this.SuspendLayout();
     //
     // fieldRouteBrand1
     //
     this.fieldRouteBrand1.AreaIndex = 1;
     this.fieldRouteBrand1.Caption = "Route Brand";
     this.fieldRouteBrand1.FieldName = "RouteBrand";
     this.fieldRouteBrand1.Name = "fieldRouteBrand1";
     //
     // repositoryItemTextEditPers
     //
     this.repositoryItemTextEditPers.AutoHeight = false;
     this.repositoryItemTextEditPers.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.repositoryItemTextEditPers.EditFormat.FormatString = "P1";
     this.repositoryItemTextEditPers.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.repositoryItemTextEditPers.ExportMode = DevExpress.XtraEditors.Repository.ExportMode.DisplayText;
     this.repositoryItemTextEditPers.Mask.EditMask = "P1";
     this.repositoryItemTextEditPers.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
     this.repositoryItemTextEditPers.Mask.UseMaskAsDisplayFormat = true;
     this.repositoryItemTextEditPers.Name = "repositoryItemTextEditPers";
     //
     // repositoryItemTextEditf2
     //
     this.repositoryItemTextEditf2.AutoHeight = false;
     this.repositoryItemTextEditf2.DisplayFormat.FormatString = "f2";
     this.repositoryItemTextEditf2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.repositoryItemTextEditf2.Mask.EditMask = "f2";
     this.repositoryItemTextEditf2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
     this.repositoryItemTextEditf2.Name = "repositoryItemTextEditf2";
     //
     // repositoryItemTextEdit1
     //
     this.repositoryItemTextEdit1.AutoHeight = false;
     this.repositoryItemTextEdit1.Name = "repositoryItemTextEdit1";
     //
     // popupMenuMain
     //
     this.popupMenuMain.Manager = this.barManagerMain;
     this.popupMenuMain.Name = "popupMenuMain";
     //
     // barManagerMain
     //
     this.barManagerMain.Bars.AddRange(new DevExpress.XtraBars.Bar[] {
     this.bar1});
     this.barManagerMain.DockControls.Add(this.barDockControlTop);
     this.barManagerMain.DockControls.Add(this.barDockControlBottom);
     this.barManagerMain.DockControls.Add(this.barDockControlLeft);
     this.barManagerMain.DockControls.Add(this.barDockControlRight);
     this.barManagerMain.Form = this;
     this.barManagerMain.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
     this.bbiExport,
     this.bbiStartDate,
     this.barHeaderItem1,
     this.bbiGetData});
     this.barManagerMain.MaxItemId = 10;
     this.barManagerMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
     this.repositoryItemDateEdit1,
     this.repositoryItemDateEdit2});
     //
     // bar1
     //
     this.bar1.BarName = "Main";
     this.bar1.DockCol = 0;
     this.bar1.DockRow = 0;
     this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top;
     this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
     new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem1),
     new DevExpress.XtraBars.LinkPersistInfo(this.bbiStartDate),
     new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.bbiGetData, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph),
     new DevExpress.XtraBars.LinkPersistInfo(this.bbiExport)});
     this.bar1.Text = "Custom 2";
     //
     // barHeaderItem1
     //
     this.barHeaderItem1.Caption = "Select Date";
     this.barHeaderItem1.Id = 3;
     this.barHeaderItem1.Name = "barHeaderItem1";
     //
     // bbiStartDate
     //
     this.bbiStartDate.Caption = "Start Date";
     this.bbiStartDate.Edit = this.repositoryItemDateEdit1;
     this.bbiStartDate.Id = 2;
     this.bbiStartDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D1));
     this.bbiStartDate.Name = "bbiStartDate";
     this.bbiStartDate.Width = 120;
     //
     // repositoryItemDateEdit1
     //
     this.repositoryItemDateEdit1.AutoHeight = false;
     this.repositoryItemDateEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit1.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit1.Name = "repositoryItemDateEdit1";
     //
     // bbiGetData
     //
     this.bbiGetData.Caption = "Get Data";
     this.bbiGetData.CaptionAlignment = DevExpress.XtraBars.BarItemCaptionAlignment.Right;
     this.bbiGetData.Glyph = global::NestleICSales.Properties.Resources.apply_16x16;
     this.bbiGetData.Id = 9;
     this.bbiGetData.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.G));
     this.bbiGetData.Name = "bbiGetData";
     this.bbiGetData.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiGetData_ItemClick);
     //
     // bbiExport
     //
     this.bbiExport.Caption = "Export";
     this.bbiExport.Glyph = global::NestleICSales.Properties.Resources.Export;
     this.bbiExport.Id = 1;
     this.bbiExport.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.E));
     this.bbiExport.Name = "bbiExport";
     this.bbiExport.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExport_ItemClick);
     //
     // barDockControlTop
     //
     this.barDockControlTop.CausesValidation = false;
     this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top;
     this.barDockControlTop.Location = new System.Drawing.Point(0, 0);
     this.barDockControlTop.Size = new System.Drawing.Size(1132, 31);
     //
     // barDockControlBottom
     //
     this.barDockControlBottom.CausesValidation = false;
     this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
     this.barDockControlBottom.Location = new System.Drawing.Point(0, 311);
     this.barDockControlBottom.Size = new System.Drawing.Size(1132, 0);
     //
     // barDockControlLeft
     //
     this.barDockControlLeft.CausesValidation = false;
     this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
     this.barDockControlLeft.Location = new System.Drawing.Point(0, 31);
     this.barDockControlLeft.Size = new System.Drawing.Size(0, 280);
     //
     // barDockControlRight
     //
     this.barDockControlRight.CausesValidation = false;
     this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
     this.barDockControlRight.Location = new System.Drawing.Point(1132, 31);
     this.barDockControlRight.Size = new System.Drawing.Size(0, 280);
     //
     // repositoryItemDateEdit2
     //
     this.repositoryItemDateEdit2.AutoHeight = false;
     this.repositoryItemDateEdit2.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit2.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
     new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.repositoryItemDateEdit2.Name = "repositoryItemDateEdit2";
     //
     // pivotGridControlMain
     //
     this.pivotGridControlMain.DataSource = this.pro0002BindingSource;
     this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill;
     this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
     this.fieldRouteNumber1,
     this.fieldRouteName1,
     this.fieldSupervisor1,
     this.fieldRouteBrand1,
     this.fieldPlantSalesDistrict1,
     this.fieldPlantName1,
     this.fieldPlantBaseName1,
     this.fieldDistributionChannel1,
     this.fieldActive1,
     this.fieldEquipment1,
     this.fieldCustomer,
     this.calcEqAvg,
     this.fieldCType,
     this.fieldCustomerType});
     pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition1.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition1.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
     pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition1.Field = this.fieldRouteBrand1;
     pivotGridStyleFormatCondition1.FieldName = "fieldRouteBrand1";
     pivotGridStyleFormatCondition1.Value1 = "1";
     pivotGridStyleFormatCondition2.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition2.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition2.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
     pivotGridStyleFormatCondition2.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition2.Field = this.fieldRouteBrand1;
     pivotGridStyleFormatCondition2.FieldName = "fieldRouteBrand1";
     pivotGridStyleFormatCondition2.Value1 = "1";
     pivotGridStyleFormatCondition3.Appearance.BackColor = System.Drawing.Color.Red;
     pivotGridStyleFormatCondition3.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition3.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
     pivotGridStyleFormatCondition3.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
     pivotGridStyleFormatCondition3.Field = this.fieldRouteBrand1;
     pivotGridStyleFormatCondition3.FieldName = "fieldRouteBrand1";
     pivotGridStyleFormatCondition3.Value1 = "1";
     pivotGridStyleFormatCondition4.Appearance.BackColor = System.Drawing.Color.Green;
     pivotGridStyleFormatCondition4.Appearance.BackColor2 = System.Drawing.Color.White;
     pivotGridStyleFormatCondition4.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
     pivotGridStyleFormatCondition4.Appearance.Options.UseBackColor = true;
     pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
     pivotGridStyleFormatCondition4.Field = this.fieldRouteBrand1;
     pivotGridStyleFormatCondition4.FieldName = "fieldRouteBrand1";
     pivotGridStyleFormatCondition4.Value1 = "1";
     this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
     pivotGridStyleFormatCondition1,
     pivotGridStyleFormatCondition2,
     pivotGridStyleFormatCondition3,
     pivotGridStyleFormatCondition4});
     this.pivotGridControlMain.Location = new System.Drawing.Point(0, 31);
     this.pivotGridControlMain.Name = "pivotGridControlMain";
     this.pivotGridControlMain.OptionsPrint.PrintColumnHeaders = DevExpress.Utils.DefaultBoolean.False;
     this.pivotGridControlMain.OptionsPrint.PrintDataHeaders = DevExpress.Utils.DefaultBoolean.False;
     this.pivotGridControlMain.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False;
     this.pivotGridControlMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
     this.repositoryItemTextEditPers});
     this.pivotGridControlMain.Size = new System.Drawing.Size(1132, 280);
     this.pivotGridControlMain.TabIndex = 9;
     //
     // dsNMQry
     //
     this.dsNMQry.DataSetName = "dsNMQry";
     this.dsNMQry.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     //
     // fieldRouteNumber1
     //
     this.fieldRouteNumber1.AreaIndex = 0;
     this.fieldRouteNumber1.Caption = "Route Number";
     this.fieldRouteNumber1.FieldName = "RouteNumber";
     this.fieldRouteNumber1.Name = "fieldRouteNumber1";
     //
     // fieldRouteName1
     //
     this.fieldRouteName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldRouteName1.AreaIndex = 1;
     this.fieldRouteName1.Caption = "Route Name";
     this.fieldRouteName1.FieldName = "RouteName";
     this.fieldRouteName1.Name = "fieldRouteName1";
     //
     // fieldSupervisor1
     //
     this.fieldSupervisor1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldSupervisor1.AreaIndex = 0;
     this.fieldSupervisor1.Caption = "Supervisor";
     this.fieldSupervisor1.FieldName = "Supervisor";
     this.fieldSupervisor1.Name = "fieldSupervisor1";
     //
     // fieldPlantSalesDistrict1
     //
     this.fieldPlantSalesDistrict1.AreaIndex = 2;
     this.fieldPlantSalesDistrict1.Caption = "Plant Sales District";
     this.fieldPlantSalesDistrict1.FieldName = "PlantSalesDistrict";
     this.fieldPlantSalesDistrict1.Name = "fieldPlantSalesDistrict1";
     //
     // fieldPlantName1
     //
     this.fieldPlantName1.AreaIndex = 3;
     this.fieldPlantName1.Caption = "Plant Name";
     this.fieldPlantName1.FieldName = "PlantName";
     this.fieldPlantName1.Name = "fieldPlantName1";
     //
     // fieldPlantBaseName1
     //
     this.fieldPlantBaseName1.AreaIndex = 4;
     this.fieldPlantBaseName1.Caption = "Plant Base Name";
     this.fieldPlantBaseName1.FieldName = "PlantBaseName";
     this.fieldPlantBaseName1.Name = "fieldPlantBaseName1";
     //
     // fieldDistributionChannel1
     //
     this.fieldDistributionChannel1.AreaIndex = 5;
     this.fieldDistributionChannel1.Caption = "Distribution Channel";
     this.fieldDistributionChannel1.FieldName = "DistributionChannel";
     this.fieldDistributionChannel1.Name = "fieldDistributionChannel1";
     //
     // fieldActive1
     //
     this.fieldActive1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
     this.fieldActive1.AreaIndex = 0;
     this.fieldActive1.Caption = "Active";
     this.fieldActive1.FieldName = "Active";
     this.fieldActive1.Name = "fieldActive1";
     //
     // fieldEquipment1
     //
     this.fieldEquipment1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldEquipment1.AreaIndex = 1;
     this.fieldEquipment1.Caption = "Frz";
     this.fieldEquipment1.FieldName = "Equipment";
     this.fieldEquipment1.Name = "fieldEquipment1";
     //
     // fieldCustomer
     //
     this.fieldCustomer.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldCustomer.AreaIndex = 0;
     this.fieldCustomer.Caption = "Customer";
     this.fieldCustomer.FieldName = "Customer";
     this.fieldCustomer.Name = "fieldCustomer";
     //
     // calcEqAvg
     //
     this.calcEqAvg.Appearance.Cell.ForeColor = System.Drawing.Color.Red;
     this.calcEqAvg.Appearance.Cell.Options.UseForeColor = true;
     this.calcEqAvg.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.calcEqAvg.AreaIndex = 2;
     this.calcEqAvg.Caption = "Arg Frz";
     this.calcEqAvg.FieldName = "Equipment";
     this.calcEqAvg.Name = "calcEqAvg";
     this.calcEqAvg.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.PercentOfRow;
     //
     // fieldCType
     //
     this.fieldCType.AreaIndex = 6;
     this.fieldCType.Caption = "Frz Type";
     this.fieldCType.FieldName = "CType";
     this.fieldCType.Name = "fieldCType";
     //
     // fieldCustomerType
     //
     this.fieldCustomerType.AreaIndex = 7;
     this.fieldCustomerType.Caption = "Customer Type";
     this.fieldCustomerType.FieldName = "CustomerType";
     this.fieldCustomerType.Name = "fieldCustomerType";
     //
     // pro0002BindingSource
     //
     this.pro0002BindingSource.DataMember = "Pro_0002";
     this.pro0002BindingSource.DataSource = this.dsNMQry;
     //
     // pro_0002TableAdapter
     //
     this.pro_0002TableAdapter.ClearBeforeFill = true;
     //
     // QryPro_0002Frm
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
     this.ClientSize = new System.Drawing.Size(1132, 311);
     this.Controls.Add(this.pivotGridControlMain);
     this.Controls.Add(this.barDockControlLeft);
     this.Controls.Add(this.barDockControlRight);
     this.Controls.Add(this.barDockControlBottom);
     this.Controls.Add(this.barDockControlTop);
     this.Icon = global::NestleICSales.Properties.Resources.Qry16;
     this.Name = "QryPro_0002Frm";
     this.Text = "Zero Sales MTD";
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pro0002BindingSource)).EndInit();
     this.ResumeLayout(false);
 }