//处理字段结合绑定的情况
private void processUnitField(ColPivotList xmlCfgLst, DevExpress.XtraPivotGrid.PivotGridControl gridCtl)
{
if (xmlCfgLst == null || xmlCfgLst.FieldGroups == null || xmlCfgLst.FieldGroups.Length == 0)
{
return;
}
string[] groups = xmlCfgLst.FieldGroups.Split(';');
foreach (string group in groups)
{
string[] fields = group.Split(',');
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup = new DevExpress.XtraPivotGrid.PivotGridGroup();
gridCtl.Groups.Add(pivotGridGroup);
foreach (string field in fields)
{
DevExpress.XtraPivotGrid.PivotGridField pivField = gridCtl.Fields[field];
if (pivField == null)
{
continue;
}
pivotGridGroup.Add(pivField);
}
}
}
/// <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.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraCharts.XYDiagram xyDiagram1 = new DevExpress.XtraCharts.XYDiagram();
DevExpress.XtraCharts.StackedBarSeriesLabel stackedBarSeriesLabel1 = new DevExpress.XtraCharts.StackedBarSeriesLabel();
DevExpress.XtraCharts.StackedBarSeriesView stackedBarSeriesView1 = new DevExpress.XtraCharts.StackedBarSeriesView();
this.fieldOrderDate = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate3 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldShipCountry1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldShipCity1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.xtraPivotGridTutorialBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.nwindDataSet = new NwindDataSet.nwindDataSet();
this.xtraPivotGridTutorialViewTableAdapter = new NwindDataSet.nwindDataSetTableAdapters.XtraPivotGridTutorialViewTableAdapter();
this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl();
this.splitContainerControl2 = new DevExpress.XtraEditors.SplitContainerControl();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.fieldUnitPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldQuantity1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldFreight1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldShipperCompany1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate4 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDiscount = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldFreightPercentage = new DevExpress.XtraPivotGrid.PivotGridField();
this.chartControl1 = new DevExpress.XtraCharts.ChartControl();
((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit();
this.splitContainerControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl2)).BeginInit();
this.splitContainerControl2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.chartControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(stackedBarSeriesLabel1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(stackedBarSeriesView1)).BeginInit();
this.SuspendLayout();
//
// fieldOrderDate
//
this.fieldOrderDate.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate.AreaIndex = 0;
this.fieldOrderDate.Caption = "Year";
this.fieldOrderDate.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate.FieldName = "OrderDate";
this.fieldOrderDate.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.fieldOrderDate.Name = "fieldOrderDate";
this.fieldOrderDate.UnboundFieldName = "fieldOrderDate";
//
// fieldOrderDate1
//
this.fieldOrderDate1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate1.AreaIndex = 1;
this.fieldOrderDate1.Caption = "Quarter";
this.fieldOrderDate1.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate1.ExpandedInFieldsGroup = false;
this.fieldOrderDate1.FieldName = "OrderDate";
this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter;
this.fieldOrderDate1.Name = "fieldOrderDate1";
this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1";
this.fieldOrderDate1.ValueFormat.FormatString = "Quarter {0}";
this.fieldOrderDate1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// fieldOrderDate2
//
this.fieldOrderDate2.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate2.AreaIndex = 2;
this.fieldOrderDate2.Caption = "Month";
this.fieldOrderDate2.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate2.ExpandedInFieldsGroup = false;
this.fieldOrderDate2.FieldName = "OrderDate";
this.fieldOrderDate2.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
this.fieldOrderDate2.Name = "fieldOrderDate2";
this.fieldOrderDate2.UnboundFieldName = "fieldOrderDate2";
this.fieldOrderDate2.Visible = false;
//
// fieldOrderDate3
//
this.fieldOrderDate3.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate3.AreaIndex = 3;
this.fieldOrderDate3.Caption = "Day";
this.fieldOrderDate3.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate3.FieldName = "OrderDate";
this.fieldOrderDate3.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateDay;
this.fieldOrderDate3.Name = "fieldOrderDate3";
this.fieldOrderDate3.UnboundFieldName = "fieldOrderDate3";
this.fieldOrderDate3.Visible = false;
//
// fieldShipCountry1
//
this.fieldShipCountry1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldShipCountry1.AreaIndex = 0;
this.fieldShipCountry1.Caption = "Ship Country";
this.fieldShipCountry1.DisplayFolder = "Dimensions\\Geography";
this.fieldShipCountry1.FieldName = "ShipCountry";
this.fieldShipCountry1.Name = "fieldShipCountry1";
this.fieldShipCountry1.Visible = false;
//
// fieldShipCity1
//
this.fieldShipCity1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldShipCity1.AreaIndex = 1;
this.fieldShipCity1.Caption = "Ship City";
this.fieldShipCity1.DisplayFolder = "Dimensions\\Geography";
this.fieldShipCity1.FieldName = "ShipCity";
this.fieldShipCity1.Name = "fieldShipCity1";
this.fieldShipCity1.Visible = false;
//
// fieldCategoryName1
//
this.fieldCategoryName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCategoryName1.AreaIndex = 0;
this.fieldCategoryName1.Caption = "Category";
this.fieldCategoryName1.DisplayFolder = "Dimensions\\Products";
this.fieldCategoryName1.FieldName = "CategoryName";
this.fieldCategoryName1.Name = "fieldCategoryName1";
//
// fieldProductName1
//
this.fieldProductName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldProductName1.AreaIndex = 1;
this.fieldProductName1.Caption = "Product";
this.fieldProductName1.DisplayFolder = "Dimensions\\Products";
this.fieldProductName1.FieldName = "ProductName";
this.fieldProductName1.Name = "fieldProductName1";
//
// xtraPivotGridTutorialBindingSource
//
this.xtraPivotGridTutorialBindingSource.DataMember = "XtraPivotGridTutorialView";
this.xtraPivotGridTutorialBindingSource.DataSource = this.nwindDataSet;
//
// nwindDataSet
//
this.nwindDataSet.DataSetName = "nwindDataSet";
this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// xtraPivotGridTutorialViewTableAdapter
//
this.xtraPivotGridTutorialViewTableAdapter.ClearBeforeFill = true;
//
// splitContainerControl1
//
this.splitContainerControl1.Collapsed = true;
this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.splitContainerControl1.Location = new System.Drawing.Point(0, 0);
this.splitContainerControl1.Name = "splitContainerControl1";
this.splitContainerControl1.Panel1.Text = "Panel1";
this.splitContainerControl1.Panel2.Controls.Add(this.splitContainerControl2);
this.splitContainerControl1.Panel2.Text = "Panel2";
this.splitContainerControl1.Size = new System.Drawing.Size(732, 541);
this.splitContainerControl1.SplitterPosition = 312;
this.splitContainerControl1.TabIndex = 1;
this.splitContainerControl1.Text = "splitContainerControl1";
//
// splitContainerControl2
//
this.splitContainerControl2.Dock = System.Windows.Forms.DockStyle.Fill;
this.splitContainerControl2.Horizontal = false;
this.splitContainerControl2.Location = new System.Drawing.Point(0, 0);
this.splitContainerControl2.Name = "splitContainerControl2";
this.splitContainerControl2.Panel1.Controls.Add(this.pivotGridControl1);
this.splitContainerControl2.Panel1.Text = "Panel1";
this.splitContainerControl2.Panel2.Controls.Add(this.chartControl1);
this.splitContainerControl2.Panel2.Text = "Panel2";
this.splitContainerControl2.Size = new System.Drawing.Size(415, 541);
this.splitContainerControl2.SplitterPosition = 326;
this.splitContainerControl2.TabIndex = 0;
this.splitContainerControl2.Text = "splitContainerControl2";
//
// pivotGridControl1
//
this.pivotGridControl1.DataSource = this.xtraPivotGridTutorialBindingSource;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldCategoryName1,
this.fieldProductName1,
this.fieldUnitPrice1,
this.fieldQuantity1,
this.fieldPrice1,
this.fieldExtendedPrice1,
this.fieldFreight1,
this.fieldSalesPerson1,
this.fieldShipCountry1,
this.fieldShipCity1,
this.fieldShipperCompany1,
this.fieldOrderDate,
this.fieldOrderDate1,
this.fieldOrderDate2,
this.fieldOrderDate3,
this.fieldOrderDate4,
this.fieldDiscount,
this.fieldFreightPercentage
});
pivotGridGroup1.Caption = "Calendar";
pivotGridGroup1.Fields.Add(this.fieldOrderDate);
pivotGridGroup1.Fields.Add(this.fieldOrderDate1);
pivotGridGroup1.Fields.Add(this.fieldOrderDate2);
pivotGridGroup1.Fields.Add(this.fieldOrderDate3);
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
pivotGridGroup2.Caption = "Ship Info";
pivotGridGroup2.Fields.Add(this.fieldShipCountry1);
pivotGridGroup2.Fields.Add(this.fieldShipCity1);
pivotGridGroup2.Hierarchy = null;
pivotGridGroup2.ShowNewValues = true;
pivotGridGroup3.Caption = "Product Info";
pivotGridGroup3.Fields.Add(this.fieldCategoryName1);
pivotGridGroup3.Fields.Add(this.fieldProductName1);
pivotGridGroup3.Hierarchy = null;
pivotGridGroup3.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1,
pivotGridGroup2,
pivotGridGroup3
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OptionsChartDataSource.SelectionOnly = false;
this.pivotGridControl1.OptionsCustomization.AllowFilterInCustomizationForm = true;
this.pivotGridControl1.OptionsCustomization.AllowSortInCustomizationForm = true;
this.pivotGridControl1.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007;
this.pivotGridControl1.OptionsData.AutoExpandGroups = DevExpress.Utils.DefaultBoolean.False;
this.pivotGridControl1.OptionsData.DataFieldUnboundExpressionMode = DevExpress.XtraPivotGrid.DataFieldUnboundExpressionMode.UseSummaryValues;
this.pivotGridControl1.OptionsDataField.Area = DevExpress.XtraPivotGrid.PivotDataArea.ColumnArea;
this.pivotGridControl1.OptionsDataField.AreaIndex = 0;
this.pivotGridControl1.OptionsView.RowTotalsLocation = DevExpress.XtraPivotGrid.PivotRowTotalsLocation.Tree;
this.pivotGridControl1.OptionsView.ShowColumnGrandTotalHeader = false;
this.pivotGridControl1.OptionsView.ShowColumnHeaders = false;
this.pivotGridControl1.OptionsView.ShowDataHeaders = false;
this.pivotGridControl1.OptionsView.ShowFilterHeaders = false;
this.pivotGridControl1.OptionsView.ShowRowHeaders = false;
this.pivotGridControl1.Size = new System.Drawing.Size(415, 326);
this.pivotGridControl1.TabIndex = 2;
//
// fieldUnitPrice1
//
this.fieldUnitPrice1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldUnitPrice1.AreaIndex = 0;
this.fieldUnitPrice1.Caption = "Unit Price";
this.fieldUnitPrice1.DisplayFolder = "Dimensions\\Products";
this.fieldUnitPrice1.FieldName = "UnitPrice";
this.fieldUnitPrice1.Name = "fieldUnitPrice1";
this.fieldUnitPrice1.Visible = false;
//
// fieldQuantity1
//
this.fieldQuantity1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldQuantity1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldQuantity1.AreaIndex = 1;
this.fieldQuantity1.Caption = "Quantity";
this.fieldQuantity1.DisplayFolder = "Measures";
this.fieldQuantity1.FieldName = "Quantity";
this.fieldQuantity1.Name = "fieldQuantity1";
this.fieldQuantity1.Visible = false;
//
// fieldPrice1
//
this.fieldPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldPrice1.AreaIndex = 0;
this.fieldPrice1.Caption = "Amount";
this.fieldPrice1.CellFormat.FormatString = "C0";
this.fieldPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldPrice1.DisplayFolder = "Measures";
this.fieldPrice1.FieldName = "Price";
this.fieldPrice1.Name = "fieldPrice1";
//
// fieldExtendedPrice1
//
this.fieldExtendedPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldExtendedPrice1.Caption = "Extended Amount";
this.fieldExtendedPrice1.CellFormat.FormatString = "C0";
this.fieldExtendedPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldExtendedPrice1.DisplayFolder = "Measures";
this.fieldExtendedPrice1.FieldName = "ExtendedPrice";
this.fieldExtendedPrice1.Name = "fieldExtendedPrice1";
this.fieldExtendedPrice1.Visible = false;
//
// fieldFreight1
//
this.fieldFreight1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldFreight1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldFreight1.AreaIndex = 2;
this.fieldFreight1.Caption = "Freight";
this.fieldFreight1.CellFormat.FormatString = "C0";
this.fieldFreight1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldFreight1.DisplayFolder = "Measures";
this.fieldFreight1.FieldName = "Freight";
this.fieldFreight1.Name = "fieldFreight1";
//
// fieldSalesPerson1
//
this.fieldSalesPerson1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldSalesPerson1.AreaIndex = 0;
this.fieldSalesPerson1.Caption = "Sales Person";
this.fieldSalesPerson1.DisplayFolder = "Dimensions";
this.fieldSalesPerson1.FieldName = "SalesPerson";
this.fieldSalesPerson1.Name = "fieldSalesPerson1";
this.fieldSalesPerson1.Visible = false;
//
// fieldShipperCompany1
//
this.fieldShipperCompany1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldShipperCompany1.AreaIndex = 0;
this.fieldShipperCompany1.Caption = "Shipper Company";
this.fieldShipperCompany1.DisplayFolder = "Dimensions";
this.fieldShipperCompany1.FieldName = "ShipperCompany";
this.fieldShipperCompany1.Name = "fieldShipperCompany1";
this.fieldShipperCompany1.Visible = false;
//
// fieldOrderDate4
//
this.fieldOrderDate4.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate4.AreaIndex = 4;
this.fieldOrderDate4.Caption = "Date";
this.fieldOrderDate4.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate4.FieldName = "OrderDate";
this.fieldOrderDate4.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.Date;
this.fieldOrderDate4.Name = "fieldOrderDate4";
this.fieldOrderDate4.UnboundFieldName = "fieldOrderDate4";
this.fieldOrderDate4.Visible = false;
//
// fieldDiscount
//
this.fieldDiscount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldDiscount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldDiscount.AreaIndex = 1;
this.fieldDiscount.Caption = "Discount";
this.fieldDiscount.CellFormat.FormatString = "C0";
this.fieldDiscount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldDiscount.DisplayFolder = "Measures";
this.fieldDiscount.FieldName = "DiscountAmount";
this.fieldDiscount.Name = "fieldDiscount";
this.fieldDiscount.UnboundExpression = "Abs([fieldExtendedPrice1] - [fieldPrice1])";
this.fieldDiscount.UnboundFieldName = "fieldDiscountAmount";
this.fieldDiscount.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// fieldFreightPercentage
//
this.fieldFreightPercentage.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldFreightPercentage.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldFreightPercentage.AreaIndex = 2;
this.fieldFreightPercentage.Caption = "Freight %";
this.fieldFreightPercentage.CellFormat.FormatString = "P";
this.fieldFreightPercentage.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldFreightPercentage.DisplayFolder = "Measures";
this.fieldFreightPercentage.FieldName = "FreightPercentage";
this.fieldFreightPercentage.Name = "fieldFreightPercentage";
this.fieldFreightPercentage.UnboundExpression = "[fieldFreight1] / ([fieldFreight1] + [fieldExtendedPrice1])";
this.fieldFreightPercentage.UnboundFieldName = "fFreightPercentage";
this.fieldFreightPercentage.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
this.fieldFreightPercentage.Visible = false;
//
// chartControl1
//
this.chartControl1.DataSource = this.pivotGridControl1;
xyDiagram1.AxisX.Range.ScrollingRange.SideMarginsEnabled = true;
xyDiagram1.AxisX.Range.SideMarginsEnabled = true;
xyDiagram1.AxisX.Title.Text = "Category Product";
xyDiagram1.AxisX.VisibleInPanesSerializable = "-1";
xyDiagram1.AxisY.NumericOptions.Format = DevExpress.XtraCharts.NumericFormat.Currency;
xyDiagram1.AxisY.Range.ScrollingRange.SideMarginsEnabled = true;
xyDiagram1.AxisY.Range.SideMarginsEnabled = true;
xyDiagram1.AxisY.Title.Text = "Amount Discount Freight";
xyDiagram1.AxisY.VisibleInPanesSerializable = "-1";
this.chartControl1.Diagram = xyDiagram1;
this.chartControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.chartControl1.Legend.AlignmentHorizontal = DevExpress.XtraCharts.LegendAlignmentHorizontal.Center;
this.chartControl1.Legend.AlignmentVertical = DevExpress.XtraCharts.LegendAlignmentVertical.TopOutside;
this.chartControl1.Legend.Direction = DevExpress.XtraCharts.LegendDirection.LeftToRight;
this.chartControl1.Legend.MaxVerticalPercentage = 30;
this.chartControl1.Location = new System.Drawing.Point(0, 0);
this.chartControl1.Name = "chartControl1";
this.chartControl1.SeriesDataMember = "Series";
this.chartControl1.SeriesSerializable = new DevExpress.XtraCharts.Series[0];
this.chartControl1.SeriesTemplate.ArgumentDataMember = "Arguments";
this.chartControl1.SeriesTemplate.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative;
this.chartControl1.SeriesTemplate.CrosshairLabelPattern = "{S} : {V:C2}";
this.chartControl1.SeriesTemplate.Label = stackedBarSeriesLabel1;
this.chartControl1.SeriesTemplate.ValueDataMembersSerializable = "Values";
this.chartControl1.SeriesTemplate.View = stackedBarSeriesView1;
this.chartControl1.Size = new System.Drawing.Size(415, 210);
this.chartControl1.TabIndex = 0;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(732, 541);
this.Controls.Add(this.splitContainerControl1);
this.Name = "Form1";
this.Text = "XtraPivotGridTutorial.Step5";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit();
this.splitContainerControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl2)).EndInit();
this.splitContainerControl2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).EndInit();
((System.ComponentModel.ISupportInitialize)(stackedBarSeriesLabel1)).EndInit();
((System.ComponentModel.ISupportInitialize)(stackedBarSeriesView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.chartControl1)).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.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.fieldOrderDate = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate3 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldShipCountry1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldShipCity1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.xtraPivotGridTutorialBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.nwindDataSet = new NwindDataSet.nwindDataSet();
this.xtraPivotGridTutorialViewTableAdapter = new NwindDataSet.nwindDataSetTableAdapters.XtraPivotGridTutorialViewTableAdapter();
this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.fieldUnitPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldQuantity1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldFreight1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldShipperCompany1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate4 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDiscount = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldFreightPercentage = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit();
this.splitContainerControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.SuspendLayout();
//
// fieldOrderDate
//
this.fieldOrderDate.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate.AreaIndex = 0;
this.fieldOrderDate.Caption = "Year";
this.fieldOrderDate.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate.FieldName = "OrderDate";
this.fieldOrderDate.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.fieldOrderDate.Name = "fieldOrderDate";
this.fieldOrderDate.UnboundFieldName = "fieldOrderDate";
//
// fieldOrderDate1
//
this.fieldOrderDate1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate1.AreaIndex = 1;
this.fieldOrderDate1.Caption = "Quarter";
this.fieldOrderDate1.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate1.ExpandedInFieldsGroup = false;
this.fieldOrderDate1.FieldName = "OrderDate";
this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter;
this.fieldOrderDate1.Name = "fieldOrderDate1";
this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1";
this.fieldOrderDate1.ValueFormat.FormatString = "Quarter {0}";
this.fieldOrderDate1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// fieldOrderDate2
//
this.fieldOrderDate2.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate2.AreaIndex = 2;
this.fieldOrderDate2.Caption = "Month";
this.fieldOrderDate2.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate2.ExpandedInFieldsGroup = false;
this.fieldOrderDate2.FieldName = "OrderDate";
this.fieldOrderDate2.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
this.fieldOrderDate2.Name = "fieldOrderDate2";
this.fieldOrderDate2.UnboundFieldName = "fieldOrderDate2";
this.fieldOrderDate2.Visible = false;
//
// fieldOrderDate3
//
this.fieldOrderDate3.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate3.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate3.AreaIndex = 3;
this.fieldOrderDate3.Caption = "Day";
this.fieldOrderDate3.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate3.FieldName = "OrderDate";
this.fieldOrderDate3.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateDay;
this.fieldOrderDate3.Name = "fieldOrderDate3";
this.fieldOrderDate3.UnboundFieldName = "fieldOrderDate3";
this.fieldOrderDate3.Visible = false;
//
// fieldShipCountry1
//
this.fieldShipCountry1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldShipCountry1.AreaIndex = 0;
this.fieldShipCountry1.Caption = "Ship Country";
this.fieldShipCountry1.DisplayFolder = "Dimensions\\Geography";
this.fieldShipCountry1.FieldName = "ShipCountry";
this.fieldShipCountry1.Name = "fieldShipCountry1";
this.fieldShipCountry1.Visible = false;
//
// fieldShipCity1
//
this.fieldShipCity1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldShipCity1.AreaIndex = 1;
this.fieldShipCity1.Caption = "Ship City";
this.fieldShipCity1.DisplayFolder = "Dimensions\\Geography";
this.fieldShipCity1.FieldName = "ShipCity";
this.fieldShipCity1.Name = "fieldShipCity1";
this.fieldShipCity1.Visible = false;
//
// fieldCategoryName1
//
this.fieldCategoryName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCategoryName1.AreaIndex = 0;
this.fieldCategoryName1.Caption = "Category";
this.fieldCategoryName1.DisplayFolder = "Dimensions\\Products";
this.fieldCategoryName1.FieldName = "CategoryName";
this.fieldCategoryName1.Name = "fieldCategoryName1";
//
// fieldProductName1
//
this.fieldProductName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldProductName1.AreaIndex = 1;
this.fieldProductName1.Caption = "Product";
this.fieldProductName1.DisplayFolder = "Dimensions\\Products";
this.fieldProductName1.FieldName = "ProductName";
this.fieldProductName1.Name = "fieldProductName1";
//
// xtraPivotGridTutorialBindingSource
//
this.xtraPivotGridTutorialBindingSource.DataMember = "XtraPivotGridTutorialView";
this.xtraPivotGridTutorialBindingSource.DataSource = this.nwindDataSet;
//
// nwindDataSet
//
this.nwindDataSet.DataSetName = "nwindDataSet";
this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// xtraPivotGridTutorialViewTableAdapter
//
this.xtraPivotGridTutorialViewTableAdapter.ClearBeforeFill = true;
//
// splitContainerControl1
//
this.splitContainerControl1.CollapsePanel = DevExpress.XtraEditors.SplitCollapsePanel.Panel1;
this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.splitContainerControl1.Location = new System.Drawing.Point(0, 0);
this.splitContainerControl1.Name = "splitContainerControl1";
this.splitContainerControl1.Panel1.Text = "Panel1";
this.splitContainerControl1.Panel2.Controls.Add(this.pivotGridControl1);
this.splitContainerControl1.Panel2.Text = "Panel2";
this.splitContainerControl1.Size = new System.Drawing.Size(1012, 541);
this.splitContainerControl1.SplitterPosition = 312;
this.splitContainerControl1.TabIndex = 1;
this.splitContainerControl1.Text = "splitContainerControl1";
//
// pivotGridControl1
//
this.pivotGridControl1.DataSource = this.xtraPivotGridTutorialBindingSource;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldCategoryName1,
this.fieldProductName1,
this.fieldUnitPrice1,
this.fieldQuantity1,
this.fieldPrice1,
this.fieldExtendedPrice1,
this.fieldFreight1,
this.fieldSalesPerson1,
this.fieldShipCountry1,
this.fieldShipCity1,
this.fieldShipperCompany1,
this.fieldOrderDate,
this.fieldOrderDate1,
this.fieldOrderDate2,
this.fieldOrderDate3,
this.fieldOrderDate4,
this.fieldDiscount,
this.fieldFreightPercentage
});
pivotGridGroup1.Caption = "Calendar";
pivotGridGroup1.Fields.Add(this.fieldOrderDate);
pivotGridGroup1.Fields.Add(this.fieldOrderDate1);
pivotGridGroup1.Fields.Add(this.fieldOrderDate2);
pivotGridGroup1.Fields.Add(this.fieldOrderDate3);
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
pivotGridGroup2.Caption = "Ship Info";
pivotGridGroup2.Fields.Add(this.fieldShipCountry1);
pivotGridGroup2.Fields.Add(this.fieldShipCity1);
pivotGridGroup2.Hierarchy = null;
pivotGridGroup2.ShowNewValues = true;
pivotGridGroup3.Caption = "Product Info";
pivotGridGroup3.Fields.Add(this.fieldCategoryName1);
pivotGridGroup3.Fields.Add(this.fieldProductName1);
pivotGridGroup3.Hierarchy = null;
pivotGridGroup3.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1,
pivotGridGroup2,
pivotGridGroup3
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OptionsCustomization.AllowFilterInCustomizationForm = true;
this.pivotGridControl1.OptionsCustomization.AllowSortInCustomizationForm = true;
this.pivotGridControl1.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007;
this.pivotGridControl1.OptionsData.AutoExpandGroups = DevExpress.Utils.DefaultBoolean.False;
this.pivotGridControl1.OptionsData.DataFieldUnboundExpressionMode = DevExpress.XtraPivotGrid.DataFieldUnboundExpressionMode.UseSummaryValues;
this.pivotGridControl1.OptionsDataField.Area = DevExpress.XtraPivotGrid.PivotDataArea.RowArea;
this.pivotGridControl1.OptionsDataField.AreaIndex = 2;
this.pivotGridControl1.OptionsView.RowTotalsLocation = DevExpress.XtraPivotGrid.PivotRowTotalsLocation.Tree;
this.pivotGridControl1.OptionsView.ShowColumnHeaders = false;
this.pivotGridControl1.OptionsView.ShowDataHeaders = false;
this.pivotGridControl1.OptionsView.ShowFilterHeaders = false;
this.pivotGridControl1.OptionsView.ShowRowHeaders = false;
this.pivotGridControl1.Size = new System.Drawing.Size(1007, 541);
this.pivotGridControl1.TabIndex = 1;
this.pivotGridControl1.ShowingCustomizationForm += new DevExpress.XtraPivotGrid.CustomizationFormShowingEventHandler(this.pivotGridControl1_ShowingCustomizationForm);
//
// fieldUnitPrice1
//
this.fieldUnitPrice1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldUnitPrice1.AreaIndex = 0;
this.fieldUnitPrice1.Caption = "Unit Price";
this.fieldUnitPrice1.DisplayFolder = "Dimensions\\Products";
this.fieldUnitPrice1.FieldName = "UnitPrice";
this.fieldUnitPrice1.Name = "fieldUnitPrice1";
this.fieldUnitPrice1.Visible = false;
//
// fieldQuantity1
//
this.fieldQuantity1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldQuantity1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldQuantity1.AreaIndex = 1;
this.fieldQuantity1.Caption = "Quantity";
this.fieldQuantity1.DisplayFolder = "Measures";
this.fieldQuantity1.FieldName = "Quantity";
this.fieldQuantity1.Name = "fieldQuantity1";
this.fieldQuantity1.Visible = false;
//
// fieldPrice1
//
this.fieldPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldPrice1.AreaIndex = 0;
this.fieldPrice1.Caption = "Amount";
this.fieldPrice1.CellFormat.FormatString = "C0";
this.fieldPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldPrice1.DisplayFolder = "Measures";
this.fieldPrice1.FieldName = "Price";
this.fieldPrice1.Name = "fieldPrice1";
//
// fieldExtendedPrice1
//
this.fieldExtendedPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldExtendedPrice1.Caption = "Extended Amount";
this.fieldExtendedPrice1.CellFormat.FormatString = "C0";
this.fieldExtendedPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldExtendedPrice1.DisplayFolder = "Measures";
this.fieldExtendedPrice1.FieldName = "ExtendedPrice";
this.fieldExtendedPrice1.Name = "fieldExtendedPrice1";
this.fieldExtendedPrice1.Visible = false;
//
// fieldFreight1
//
this.fieldFreight1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldFreight1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldFreight1.Caption = "Freight";
this.fieldFreight1.CellFormat.FormatString = "C0";
this.fieldFreight1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldFreight1.DisplayFolder = "Measures";
this.fieldFreight1.FieldName = "Freight";
this.fieldFreight1.Name = "fieldFreight1";
this.fieldFreight1.Visible = false;
//
// fieldSalesPerson1
//
this.fieldSalesPerson1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldSalesPerson1.AreaIndex = 0;
this.fieldSalesPerson1.Caption = "Sales Person";
this.fieldSalesPerson1.DisplayFolder = "Dimensions";
this.fieldSalesPerson1.FieldName = "SalesPerson";
this.fieldSalesPerson1.Name = "fieldSalesPerson1";
this.fieldSalesPerson1.Visible = false;
//
// fieldShipperCompany1
//
this.fieldShipperCompany1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldShipperCompany1.AreaIndex = 0;
this.fieldShipperCompany1.Caption = "Shipper Company";
this.fieldShipperCompany1.DisplayFolder = "Dimensions";
this.fieldShipperCompany1.FieldName = "ShipperCompany";
this.fieldShipperCompany1.Name = "fieldShipperCompany1";
this.fieldShipperCompany1.Visible = false;
//
// fieldOrderDate4
//
this.fieldOrderDate4.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate4.AreaIndex = 4;
this.fieldOrderDate4.Caption = "Date";
this.fieldOrderDate4.DisplayFolder = "Dimensions\\Dates";
this.fieldOrderDate4.FieldName = "OrderDate";
this.fieldOrderDate4.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.Date;
this.fieldOrderDate4.Name = "fieldOrderDate4";
this.fieldOrderDate4.UnboundFieldName = "fieldOrderDate4";
this.fieldOrderDate4.Visible = false;
//
// fieldDiscount
//
this.fieldDiscount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldDiscount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldDiscount.AreaIndex = 1;
this.fieldDiscount.Caption = "Discount";
this.fieldDiscount.CellFormat.FormatString = "C0";
this.fieldDiscount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldDiscount.DisplayFolder = "Measures";
this.fieldDiscount.FieldName = "DiscountAmount";
this.fieldDiscount.Name = "fieldDiscount";
this.fieldDiscount.UnboundExpression = "Abs([fieldExtendedPrice1] - [fieldPrice1])";
this.fieldDiscount.UnboundFieldName = "fieldDiscountAmount";
this.fieldDiscount.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// fieldFreightPercentage
//
this.fieldFreightPercentage.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldFreightPercentage.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldFreightPercentage.AreaIndex = 2;
this.fieldFreightPercentage.Caption = "Freight %";
this.fieldFreightPercentage.CellFormat.FormatString = "P";
this.fieldFreightPercentage.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldFreightPercentage.DisplayFolder = "Measures";
this.fieldFreightPercentage.FieldName = "FreightPercentage";
this.fieldFreightPercentage.Name = "fieldFreightPercentage";
this.fieldFreightPercentage.UnboundExpression = "[fieldFreight1] / ([fieldFreight1] + [fieldExtendedPrice1])";
this.fieldFreightPercentage.UnboundFieldName = "fFreightPercentage";
this.fieldFreightPercentage.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1012, 541);
this.Controls.Add(this.splitContainerControl1);
this.Name = "Form1";
this.Text = "XtraPivotGridTutorial.Step4";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit();
this.splitContainerControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).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.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup4 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.fielddivision = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCourseName = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.studentenrollmentviewBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.fieldlearnerNumber = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldName = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSurname = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldMAXeregdate = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldnumRegistrations = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldlearnerStatus = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldcompleted = new DevExpress.XtraPivotGrid.PivotGridField();
this.studentEnrollments = new LAD_2009.DataSets.StudentEnrollments();
this.studentenrollmentviewTableAdapter = new LAD_2009.DataSets.StudentEnrollmentsTableAdapters.studentenrollmentviewTableAdapter();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.studentenrollmentviewBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.studentEnrollments)).BeginInit();
this.SuspendLayout();
//
// fielddivision
//
this.fielddivision.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fielddivision.AreaIndex = 0;
this.fielddivision.Caption = "division";
this.fielddivision.FieldName = "division";
this.fielddivision.Name = "fielddivision";
this.fielddivision.SortOrder = DevExpress.XtraPivotGrid.PivotSortOrder.Descending;
//
// fieldCourseName
//
this.fieldCourseName.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldCourseName.AreaIndex = 0;
this.fieldCourseName.Caption = "Course Name";
this.fieldCourseName.FieldName = "CourseName";
this.fieldCourseName.Name = "fieldCourseName";
//
// pivotGridControl1
//
this.pivotGridControl1.Cursor = System.Windows.Forms.Cursors.Default;
this.pivotGridControl1.DataSource = this.studentenrollmentviewBindingSource;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fielddivision,
this.fieldlearnerNumber,
this.fieldName,
this.fieldSurname,
this.fieldMAXeregdate,
this.fieldnumRegistrations,
this.fieldCourseName,
this.fieldlearnerStatus,
this.fieldcompleted});
pivotGridGroup3.Fields.Add(this.fielddivision);
pivotGridGroup3.Hierarchy = null;
pivotGridGroup4.Fields.Add(this.fieldCourseName);
pivotGridGroup4.Hierarchy = null;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup3,
pivotGridGroup4});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OptionsCustomization.AllowFilter = false;
this.pivotGridControl1.Size = new System.Drawing.Size(971, 590);
this.pivotGridControl1.TabIndex = 0;
//
// studentenrollmentviewBindingSource
//
this.studentenrollmentviewBindingSource.DataMember = "studentenrollmentview";
this.studentenrollmentviewBindingSource.DataSource = this.studentEnrollments;
this.studentenrollmentviewBindingSource.CurrentChanged += new System.EventHandler(this.studentenrollmentviewBindingSource_CurrentChanged);
//
// fieldlearnerNumber
//
this.fieldlearnerNumber.AreaIndex = 0;
this.fieldlearnerNumber.Caption = "learner Number";
this.fieldlearnerNumber.FieldName = "learnerNumber";
this.fieldlearnerNumber.Name = "fieldlearnerNumber";
//
// fieldName
//
this.fieldName.AreaIndex = 1;
this.fieldName.Caption = "Name";
this.fieldName.FieldName = "Name";
this.fieldName.Name = "fieldName";
//
// fieldSurname
//
this.fieldSurname.AreaIndex = 2;
this.fieldSurname.Caption = "Surname";
this.fieldSurname.FieldName = "Surname";
this.fieldSurname.Name = "fieldSurname";
//
// fieldMAXeregdate
//
this.fieldMAXeregdate.AreaIndex = 3;
this.fieldMAXeregdate.Caption = "MAX(e_regdate)";
this.fieldMAXeregdate.FieldName = "MAX(e_regdate)";
this.fieldMAXeregdate.Name = "fieldMAXeregdate";
//
// fieldnumRegistrations
//
this.fieldnumRegistrations.AreaIndex = 4;
this.fieldnumRegistrations.Caption = "num Registrations";
this.fieldnumRegistrations.FieldName = "numRegistrations";
this.fieldnumRegistrations.Name = "fieldnumRegistrations";
//
// fieldlearnerStatus
//
this.fieldlearnerStatus.AreaIndex = 5;
this.fieldlearnerStatus.Caption = "learner Status";
this.fieldlearnerStatus.FieldName = "learnerStatus";
this.fieldlearnerStatus.Name = "fieldlearnerStatus";
//
// fieldcompleted
//
this.fieldcompleted.AreaIndex = 6;
this.fieldcompleted.Caption = "completed";
this.fieldcompleted.FieldName = "completed";
this.fieldcompleted.Name = "fieldcompleted";
//
// studentEnrollments
//
this.studentEnrollments.DataSetName = "StudentEnrollments";
this.studentEnrollments.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// studentenrollmentviewTableAdapter
//
this.studentenrollmentviewTableAdapter.ClearBeforeFill = true;
//
// frmStatisticsPivot
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(971, 590);
this.Controls.Add(this.pivotGridControl1);
this.Name = "frmStatisticsPivot";
this.Text = "Statistics Live";
this.Load += new System.EventHandler(this.frmStatisticsPivot_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.studentenrollmentviewBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.studentEnrollments)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FormReporteTiempo));
this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.panel1 = new System.Windows.Forms.Panel();
this.gcDxTiempo = new DevExpress.XtraPivotGrid.PivotGridControl();
this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField5 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField6 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField4 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField12 = new DevExpress.XtraPivotGrid.PivotGridField();
this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.ribbonControl1 = new DevExpress.XtraBars.Ribbon.RibbonControl();
this.barButtonItem1 = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItem2 = new DevExpress.XtraBars.BarButtonItem();
this.bbiDxIniciarCarrera = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItem3 = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItem4 = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItem5 = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItem6 = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItem7 = new DevExpress.XtraBars.BarButtonItem();
this.ribbonPage1 = new DevExpress.XtraBars.Ribbon.RibbonPage();
this.ribbonPageGroup1 = new DevExpress.XtraBars.Ribbon.RibbonPageGroup();
this.pivotGridField7 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField8 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField9 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField10 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField11 = new DevExpress.XtraPivotGrid.PivotGridField();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.gcDxTiempo)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.ribbonControl1)).BeginInit();
this.SuspendLayout();
//
// pivotGridField2
//
this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField2.AreaIndex = 0;
this.pivotGridField2.FieldName = "Vuelta";
this.pivotGridField2.Name = "pivotGridField2";
this.pivotGridField2.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom;
//
// panel1
//
this.panel1.Controls.Add(this.gcDxTiempo);
this.panel1.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel1.Location = new System.Drawing.Point(0, 142);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(885, 312);
this.panel1.TabIndex = 2;
//
// gcDxTiempo
//
this.gcDxTiempo.Appearance.FieldValue.Options.UseTextOptions = true;
this.gcDxTiempo.Dock = System.Windows.Forms.DockStyle.Fill;
this.gcDxTiempo.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.pivotGridField1,
this.pivotGridField2,
this.pivotGridField3,
this.pivotGridField5,
this.pivotGridField6,
this.pivotGridField4,
this.pivotGridField12
});
pivotGridGroup1.Fields.Add(this.pivotGridField2);
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
this.gcDxTiempo.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.gcDxTiempo.Location = new System.Drawing.Point(0, 0);
this.gcDxTiempo.Name = "gcDxTiempo";
this.gcDxTiempo.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemDateEdit1
});
this.gcDxTiempo.Size = new System.Drawing.Size(885, 312);
this.gcDxTiempo.TabIndex = 0;
this.gcDxTiempo.CustomSummary += new DevExpress.XtraPivotGrid.PivotGridCustomSummaryEventHandler(this.gcDxTiempo_CustomSummary);
this.gcDxTiempo.CustomCellValue += new System.EventHandler <DevExpress.XtraPivotGrid.PivotCellValueEventArgs>(this.gcDxTiempo_CustomCellValue);
//
// pivotGridField1
//
this.pivotGridField1.AreaIndex = 0;
this.pivotGridField1.FieldName = "TiempoId";
this.pivotGridField1.Name = "pivotGridField1";
this.pivotGridField1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom;
//
// pivotGridField3
//
this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField3.AreaIndex = 1;
this.pivotGridField3.FieldName = "Nombre";
this.pivotGridField3.Name = "pivotGridField3";
this.pivotGridField3.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Min;
//
// pivotGridField5
//
this.pivotGridField5.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField5.AreaIndex = 2;
this.pivotGridField5.CellFormat.FormatString = "d";
this.pivotGridField5.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.pivotGridField5.FieldName = "TiempoRegistrado";
this.pivotGridField5.Name = "pivotGridField5";
this.pivotGridField5.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Max;
this.pivotGridField5.UnboundFieldName = "pivotGridField5";
this.pivotGridField5.UnboundType = DevExpress.Data.UnboundColumnType.DateTime;
this.pivotGridField5.ValueFormat.FormatString = "d";
this.pivotGridField5.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
//
// pivotGridField6
//
this.pivotGridField6.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField6.AreaIndex = 0;
this.pivotGridField6.FieldName = "Categoria";
this.pivotGridField6.Name = "pivotGridField6";
this.pivotGridField6.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom;
//
// pivotGridField4
//
this.pivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField4.AreaIndex = 1;
this.pivotGridField4.FieldName = "Tiempo";
this.pivotGridField4.Name = "pivotGridField4";
this.pivotGridField4.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Min;
//
// pivotGridField12
//
this.pivotGridField12.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField12.AreaIndex = 0;
this.pivotGridField12.FieldName = "Numero";
this.pivotGridField12.Name = "pivotGridField12";
//
// 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";
//
// ribbonControl1
//
this.ribbonControl1.ExpandCollapseItem.Id = 0;
this.ribbonControl1.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
this.ribbonControl1.ExpandCollapseItem,
this.barButtonItem1,
this.barButtonItem2,
this.bbiDxIniciarCarrera,
this.barButtonItem3,
this.barButtonItem4,
this.barButtonItem5,
this.barButtonItem6,
this.barButtonItem7
});
this.ribbonControl1.Location = new System.Drawing.Point(0, 0);
this.ribbonControl1.MaxItemId = 9;
this.ribbonControl1.Name = "ribbonControl1";
this.ribbonControl1.Pages.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPage[] {
this.ribbonPage1
});
this.ribbonControl1.ShowToolbarCustomizeItem = false;
this.ribbonControl1.Size = new System.Drawing.Size(885, 142);
this.ribbonControl1.Toolbar.ShowCustomizeItem = false;
//
// barButtonItem1
//
this.barButtonItem1.Caption = "F1 - Actualizar";
this.barButtonItem1.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem1.Glyph")));
this.barButtonItem1.Id = 1;
this.barButtonItem1.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F1);
this.barButtonItem1.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem1.LargeGlyph")));
this.barButtonItem1.Name = "barButtonItem1";
this.barButtonItem1.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItem1_ItemClick);
//
// barButtonItem2
//
this.barButtonItem2.Caption = "F2- Crear Corredor";
this.barButtonItem2.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem2.Glyph")));
this.barButtonItem2.Id = 2;
this.barButtonItem2.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F2);
this.barButtonItem2.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem2.LargeGlyph")));
this.barButtonItem2.Name = "barButtonItem2";
//
// bbiDxIniciarCarrera
//
this.bbiDxIniciarCarrera.Caption = "F3 - Iniciar carrera";
this.bbiDxIniciarCarrera.Glyph = ((System.Drawing.Image)(resources.GetObject("bbiDxIniciarCarrera.Glyph")));
this.bbiDxIniciarCarrera.Id = 3;
this.bbiDxIniciarCarrera.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F3);
this.bbiDxIniciarCarrera.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("bbiDxIniciarCarrera.LargeGlyph")));
this.bbiDxIniciarCarrera.Name = "bbiDxIniciarCarrera";
//
// barButtonItem3
//
this.barButtonItem3.Caption = "F5 - Actualizar Datos";
this.barButtonItem3.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem3.Glyph")));
this.barButtonItem3.Id = 4;
this.barButtonItem3.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F5);
this.barButtonItem3.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem3.LargeGlyph")));
this.barButtonItem3.Name = "barButtonItem3";
//
// barButtonItem4
//
this.barButtonItem4.Caption = "F6 - Borrar Tiempo";
this.barButtonItem4.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem4.Glyph")));
this.barButtonItem4.Id = 5;
this.barButtonItem4.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F6);
this.barButtonItem4.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem4.LargeGlyph")));
this.barButtonItem4.Name = "barButtonItem4";
//
// barButtonItem5
//
this.barButtonItem5.Caption = "F7 - Borrar Inicio de carrera";
this.barButtonItem5.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem5.Glyph")));
this.barButtonItem5.Id = 6;
this.barButtonItem5.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F7);
this.barButtonItem5.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem5.LargeGlyph")));
this.barButtonItem5.Name = "barButtonItem5";
//
// barButtonItem6
//
this.barButtonItem6.Caption = "Exportar XLS";
this.barButtonItem6.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem6.Glyph")));
this.barButtonItem6.Id = 7;
this.barButtonItem6.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem6.LargeGlyph")));
this.barButtonItem6.Name = "barButtonItem6";
this.barButtonItem6.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItem6_ItemClick);
//
// barButtonItem7
//
this.barButtonItem7.Caption = "Exportar PDF";
this.barButtonItem7.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem7.Glyph")));
this.barButtonItem7.Id = 8;
this.barButtonItem7.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem7.LargeGlyph")));
this.barButtonItem7.Name = "barButtonItem7";
this.barButtonItem7.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItem7_ItemClick);
//
// ribbonPage1
//
this.ribbonPage1.Groups.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPageGroup[] {
this.ribbonPageGroup1
});
this.ribbonPage1.Name = "ribbonPage1";
this.ribbonPage1.Text = "Opciones";
//
// ribbonPageGroup1
//
this.ribbonPageGroup1.Glyph = ((System.Drawing.Image)(resources.GetObject("ribbonPageGroup1.Glyph")));
this.ribbonPageGroup1.ItemLinks.Add(this.barButtonItem1);
this.ribbonPageGroup1.ItemLinks.Add(this.barButtonItem6);
this.ribbonPageGroup1.ItemLinks.Add(this.barButtonItem7);
this.ribbonPageGroup1.Name = "ribbonPageGroup1";
this.ribbonPageGroup1.Text = "Tiempo";
//
// pivotGridField7
//
this.pivotGridField7.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField7.AreaIndex = 0;
this.pivotGridField7.CellFormat.FormatString = "d";
this.pivotGridField7.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.pivotGridField7.FieldName = "TiempoRegistrado";
this.pivotGridField7.Name = "pivotGridField7";
this.pivotGridField7.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest;
this.pivotGridField7.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom;
this.pivotGridField7.UnboundType = DevExpress.Data.UnboundColumnType.DateTime;
this.pivotGridField7.ValueFormat.FormatString = "d";
this.pivotGridField7.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
//
// pivotGridField8
//
this.pivotGridField8.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField8.AreaIndex = 0;
this.pivotGridField8.CellFormat.FormatString = "d";
this.pivotGridField8.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.pivotGridField8.FieldName = "TiempoRegistrado";
this.pivotGridField8.Name = "pivotGridField8";
this.pivotGridField8.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest;
this.pivotGridField8.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom;
this.pivotGridField8.UnboundType = DevExpress.Data.UnboundColumnType.DateTime;
this.pivotGridField8.ValueFormat.FormatString = "d";
this.pivotGridField8.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
//
// pivotGridField9
//
this.pivotGridField9.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField9.AreaIndex = 0;
this.pivotGridField9.CellFormat.FormatString = "d";
this.pivotGridField9.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.pivotGridField9.FieldName = "TiempoRegistrado";
this.pivotGridField9.Name = "pivotGridField9";
this.pivotGridField9.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest;
this.pivotGridField9.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom;
this.pivotGridField9.UnboundType = DevExpress.Data.UnboundColumnType.DateTime;
this.pivotGridField9.ValueFormat.FormatString = "d";
this.pivotGridField9.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
//
// pivotGridField10
//
this.pivotGridField10.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField10.AreaIndex = 0;
this.pivotGridField10.CellFormat.FormatString = "d";
this.pivotGridField10.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.pivotGridField10.FieldName = "TiempoRegistrado";
this.pivotGridField10.Name = "pivotGridField10";
this.pivotGridField10.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest;
this.pivotGridField10.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom;
this.pivotGridField10.UnboundType = DevExpress.Data.UnboundColumnType.DateTime;
this.pivotGridField10.ValueFormat.FormatString = "d";
this.pivotGridField10.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
//
// pivotGridField11
//
this.pivotGridField11.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField11.AreaIndex = 0;
this.pivotGridField11.CellFormat.FormatString = "d";
this.pivotGridField11.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.pivotGridField11.FieldName = "TiempoRegistrado";
this.pivotGridField11.Name = "pivotGridField11";
this.pivotGridField11.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest;
this.pivotGridField11.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom;
this.pivotGridField11.UnboundType = DevExpress.Data.UnboundColumnType.DateTime;
this.pivotGridField11.ValueFormat.FormatString = "d";
this.pivotGridField11.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
//
// FormReporteTiempo
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(885, 454);
this.Controls.Add(this.panel1);
this.Controls.Add(this.ribbonControl1);
this.Name = "FormReporteTiempo";
this.Text = "FormReporteTiempo";
this.panel1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.gcDxTiempo)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.ribbonControl1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.Col_pe_cedulaRuc = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_pe_nombre = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_es_fecha_registro = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Cargo = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_de_descripcion = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_zo_descripcion = new DevExpress.XtraPivotGrid.PivotGridField();
this.ColDisco = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_ru_descripcion = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_em_status = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Placa = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_fu_descripcion = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Orden = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Valor = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_rubro = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_pe_FechaIni = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Grupo = new DevExpress.XtraPivotGrid.PivotGridField();
this.ucRo_Menu = new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Appearance.FieldHeader.BackColor = System.Drawing.Color.White;
this.pivotGridControl1.Appearance.FieldHeader.BackColor2 = System.Drawing.Color.White;
this.pivotGridControl1.Appearance.FieldHeader.ForeColor = System.Drawing.Color.Red;
this.pivotGridControl1.Appearance.FieldHeader.Options.UseBackColor = true;
this.pivotGridControl1.Appearance.FieldHeader.Options.UseForeColor = true;
this.pivotGridControl1.Appearance.FieldValue.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0)))));
this.pivotGridControl1.Appearance.FieldValue.Options.UseForeColor = true;
this.pivotGridControl1.Appearance.FieldValueTotal.ForeColor = System.Drawing.Color.Black;
this.pivotGridControl1.Appearance.FieldValueTotal.Options.UseForeColor = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor = System.Drawing.Color.Black;
this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor2 = System.Drawing.Color.White;
this.pivotGridControl1.AppearancePrint.FieldHeader.ForeColor = System.Drawing.Color.Red;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBackColor = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBorderColor = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseFont = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseForeColor = true;
this.pivotGridControl1.AppearancePrint.FieldValue.BackColor = System.Drawing.Color.Transparent;
this.pivotGridControl1.AppearancePrint.FieldValue.BackColor2 = System.Drawing.Color.Transparent;
this.pivotGridControl1.AppearancePrint.FieldValue.ForeColor = System.Drawing.Color.Black;
this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseBackColor = true;
this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseForeColor = true;
this.pivotGridControl1.AppearancePrint.FieldValueTotal.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(255)))));
this.pivotGridControl1.AppearancePrint.FieldValueTotal.Options.UseForeColor = true;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.Col_pe_cedulaRuc,
this.Col_pe_nombre,
this.Col_es_fecha_registro,
this.Col_Cargo,
this.Col_de_descripcion,
this.Col_zo_descripcion,
this.ColDisco,
this.Col_ru_descripcion,
this.Col_em_status,
this.Col_Placa,
this.Col_fu_descripcion,
this.Col_Orden,
this.Col_Valor,
this.Col_rubro,
this.Col_pe_FechaIni,
this.Col_Grupo
});
pivotGridGroup1.Caption = "Grupos";
pivotGridGroup1.Fields.Add(this.Col_Grupo);
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 77);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OptionsPrint.MergeRowFieldValues = false;
this.pivotGridControl1.OptionsPrint.PrintHeadersOnEveryPage = true;
this.pivotGridControl1.OptionsPrint.PrintUnusedFilterFields = false;
this.pivotGridControl1.OptionsPrint.UsePrintAppearance = true;
this.pivotGridControl1.OptionsView.ShowColumnGrandTotalHeader = false;
this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = false;
this.pivotGridControl1.OptionsView.ShowColumnTotals = false;
this.pivotGridControl1.OptionsView.ShowRowGrandTotalHeader = false;
this.pivotGridControl1.OptionsView.ShowRowGrandTotals = false;
this.pivotGridControl1.OptionsView.ShowRowTotals = false;
this.pivotGridControl1.Size = new System.Drawing.Size(1090, 441);
this.pivotGridControl1.TabIndex = 151;
//
// Col_pe_cedulaRuc
//
this.Col_pe_cedulaRuc.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_pe_cedulaRuc.AreaIndex = 0;
this.Col_pe_cedulaRuc.Caption = "Cedula";
this.Col_pe_cedulaRuc.FieldName = "pe_cedulaRuc";
this.Col_pe_cedulaRuc.Name = "Col_pe_cedulaRuc";
this.Col_pe_cedulaRuc.Options.ReadOnly = true;
this.Col_pe_cedulaRuc.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Min;
//
// Col_pe_nombre
//
this.Col_pe_nombre.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_pe_nombre.AreaIndex = 1;
this.Col_pe_nombre.Caption = "Empleado";
this.Col_pe_nombre.FieldName = "pe_nombreCompleto";
this.Col_pe_nombre.Name = "Col_pe_nombre";
this.Col_pe_nombre.Options.ReadOnly = true;
//
// Col_es_fecha_registro
//
this.Col_es_fecha_registro.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_es_fecha_registro.AreaIndex = 2;
this.Col_es_fecha_registro.Caption = "Fecha";
this.Col_es_fecha_registro.CellFormat.FormatString = "{0:d}";
this.Col_es_fecha_registro.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.Col_es_fecha_registro.FieldName = "em_fechaIngaRol";
this.Col_es_fecha_registro.Name = "Col_es_fecha_registro";
this.Col_es_fecha_registro.Options.ReadOnly = true;
//
// Col_Cargo
//
this.Col_Cargo.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_Cargo.AreaIndex = 3;
this.Col_Cargo.Caption = "Cargo";
this.Col_Cargo.FieldName = "ca_descripcion";
this.Col_Cargo.Name = "Col_Cargo";
this.Col_Cargo.Options.ReadOnly = true;
//
// Col_de_descripcion
//
this.Col_de_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_de_descripcion.AreaIndex = 4;
this.Col_de_descripcion.Caption = "Departamento";
this.Col_de_descripcion.FieldName = "de_descripcion";
this.Col_de_descripcion.Name = "Col_de_descripcion";
this.Col_de_descripcion.Options.ReadOnly = true;
//
// Col_zo_descripcion
//
this.Col_zo_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_zo_descripcion.AreaIndex = 5;
this.Col_zo_descripcion.Caption = "Zona";
this.Col_zo_descripcion.FieldName = "zo_descripcion";
this.Col_zo_descripcion.Name = "Col_zo_descripcion";
//
// ColDisco
//
this.ColDisco.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.ColDisco.AreaIndex = 6;
this.ColDisco.Caption = "Disco";
this.ColDisco.FieldName = "Disco";
this.ColDisco.Name = "ColDisco";
//
// Col_ru_descripcion
//
this.Col_ru_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_ru_descripcion.AreaIndex = 7;
this.Col_ru_descripcion.Caption = "Ruta";
this.Col_ru_descripcion.FieldName = "ru_descripcion";
this.Col_ru_descripcion.Name = "Col_ru_descripcion";
//
// Col_em_status
//
this.Col_em_status.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_em_status.AreaIndex = 8;
this.Col_em_status.Caption = "Estado";
this.Col_em_status.FieldName = "em_status";
this.Col_em_status.Name = "Col_em_status";
//
// Col_Placa
//
this.Col_Placa.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_Placa.AreaIndex = 9;
this.Col_Placa.Caption = "Placa";
this.Col_Placa.FieldName = "Placa";
this.Col_Placa.Name = "Col_Placa";
//
// Col_fu_descripcion
//
this.Col_fu_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_fu_descripcion.AreaIndex = 10;
this.Col_fu_descripcion.Caption = "Fuerza";
this.Col_fu_descripcion.FieldName = "fu_descripcion";
this.Col_fu_descripcion.Name = "Col_fu_descripcion";
//
// Col_Orden
//
this.Col_Orden.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.Col_Orden.AreaIndex = 1;
this.Col_Orden.Caption = "Orden";
this.Col_Orden.FieldName = "Orden";
this.Col_Orden.Name = "Col_Orden";
//
// Col_Valor
//
this.Col_Valor.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.Col_Valor.AreaIndex = 0;
this.Col_Valor.Caption = "Valor";
this.Col_Valor.FieldName = "Valor";
this.Col_Valor.Name = "Col_Valor";
//
// Col_rubro
//
this.Col_rubro.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.Col_rubro.AreaIndex = 2;
this.Col_rubro.Caption = "Rubro";
this.Col_rubro.FieldName = "Descripcion";
this.Col_rubro.Name = "Col_rubro";
//
// Col_pe_FechaIni
//
this.Col_pe_FechaIni.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_pe_FechaIni.AreaIndex = 11;
this.Col_pe_FechaIni.Caption = "Fecha Mes";
this.Col_pe_FechaIni.CellFormat.FormatString = "{0:d}";
this.Col_pe_FechaIni.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.Col_pe_FechaIni.FieldName = "pe_FechaIni";
this.Col_pe_FechaIni.Name = "Col_pe_FechaIni";
//
// Col_Grupo
//
this.Col_Grupo.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.Col_Grupo.AreaIndex = 0;
this.Col_Grupo.Caption = "Grupo";
this.Col_Grupo.FieldName = "Grupo";
this.Col_Grupo.Name = "Col_Grupo";
//
// ucRo_Menu
//
this.ucRo_Menu.Dock = System.Windows.Forms.DockStyle.Top;
this.ucRo_Menu.EnableBotonImprimir = true;
this.ucRo_Menu.Location = new System.Drawing.Point(0, 0);
this.ucRo_Menu.Name = "ucRo_Menu";
this.ucRo_Menu.Size = new System.Drawing.Size(1090, 77);
this.ucRo_Menu.TabIndex = 150;
this.ucRo_Menu.VisibleCmbCentroCosto = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbDivision = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbEmpleado = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbNominaTipo = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleCmbNominaTipoLiqui = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleCmbPeriodo = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleCmbRubro = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleGrupoFecha = false;
this.ucRo_Menu.VisibleGrupoFiltro1 = true;
this.ucRo_Menu.VisibleGrupoFiltro2 = false;
//
// XFACT_FJ_Rpt008_frm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1090, 518);
this.Controls.Add(this.pivotGridControl1);
this.Controls.Add(this.ucRo_Menu);
this.Name = "XFACT_FJ_Rpt008_frm";
this.Text = "XFACT_FJ_Rpt006_frm";
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.Col_pe_cedulaRuc = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_zo_descripcion = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_fu_descripcion = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_DISCO = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_Placa = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_ru_descripcion = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_em_fechaIngaRol = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_pe_FechaIni = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_em_fechaSalida = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_Cedula = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOLNombres = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_ca_descripcion = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_ca_orden = new DevExpress.XtraPivotGrid.PivotGridField();
this.cOL_Descripcion = new DevExpress.XtraPivotGrid.PivotGridField();
this.COL_Valor = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Catalogo = new DevExpress.XtraPivotGrid.PivotGridField();
this.ucRo_Menu = new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes();
this.Col_Dias_vacaciones = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Appearance.FieldHeader.BackColor = System.Drawing.Color.White;
this.pivotGridControl1.Appearance.FieldHeader.BackColor2 = System.Drawing.Color.White;
this.pivotGridControl1.Appearance.FieldHeader.ForeColor = System.Drawing.Color.Red;
this.pivotGridControl1.Appearance.FieldHeader.Options.UseBackColor = true;
this.pivotGridControl1.Appearance.FieldHeader.Options.UseForeColor = true;
this.pivotGridControl1.Appearance.FieldValue.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0)))));
this.pivotGridControl1.Appearance.FieldValue.Options.UseForeColor = true;
this.pivotGridControl1.Appearance.FieldValueTotal.ForeColor = System.Drawing.Color.Black;
this.pivotGridControl1.Appearance.FieldValueTotal.Options.UseForeColor = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor = System.Drawing.Color.Black;
this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor2 = System.Drawing.Color.White;
this.pivotGridControl1.AppearancePrint.FieldHeader.ForeColor = System.Drawing.Color.Red;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBackColor = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBorderColor = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseFont = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseForeColor = true;
this.pivotGridControl1.AppearancePrint.FieldValue.BackColor = System.Drawing.Color.Transparent;
this.pivotGridControl1.AppearancePrint.FieldValue.BackColor2 = System.Drawing.Color.Transparent;
this.pivotGridControl1.AppearancePrint.FieldValue.ForeColor = System.Drawing.Color.Black;
this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseBackColor = true;
this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseForeColor = true;
this.pivotGridControl1.AppearancePrint.FieldValueTotal.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(255)))));
this.pivotGridControl1.AppearancePrint.FieldValueTotal.Options.UseForeColor = true;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.Col_pe_cedulaRuc,
this.Col_zo_descripcion,
this.cOL_fu_descripcion,
this.cOL_DISCO,
this.cOL_Placa,
this.cOL_ru_descripcion,
this.cOL_em_fechaIngaRol,
this.cOL_pe_FechaIni,
this.cOL_em_fechaSalida,
this.cOL_Cedula,
this.cOLNombres,
this.cOL_ca_descripcion,
this.cOL_ca_orden,
this.cOL_Descripcion,
this.COL_Valor,
this.Col_Catalogo,
this.Col_Dias_vacaciones
});
pivotGridGroup1.Caption = "Grupos";
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 74);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OptionsBehavior.HorizontalScrolling = DevExpress.XtraPivotGrid.PivotGridScrolling.Control;
this.pivotGridControl1.OptionsPrint.MergeColumnFieldValues = false;
this.pivotGridControl1.OptionsPrint.MergeRowFieldValues = false;
this.pivotGridControl1.OptionsPrint.PrintHeadersOnEveryPage = true;
this.pivotGridControl1.OptionsPrint.PrintUnusedFilterFields = false;
this.pivotGridControl1.OptionsPrint.UsePrintAppearance = true;
this.pivotGridControl1.OptionsView.ShowColumnGrandTotalHeader = false;
this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = false;
this.pivotGridControl1.OptionsView.ShowColumnTotals = false;
this.pivotGridControl1.OptionsView.ShowRowGrandTotalHeader = false;
this.pivotGridControl1.OptionsView.ShowRowGrandTotals = false;
this.pivotGridControl1.OptionsView.ShowRowTotals = false;
this.pivotGridControl1.Size = new System.Drawing.Size(1284, 417);
this.pivotGridControl1.TabIndex = 149;
this.pivotGridControl1.Click += new System.EventHandler(this.pivotGridControl1_Click);
//
// Col_pe_cedulaRuc
//
this.Col_pe_cedulaRuc.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_pe_cedulaRuc.AreaIndex = 0;
this.Col_pe_cedulaRuc.Caption = "Cedula";
this.Col_pe_cedulaRuc.FieldName = "pe_cedulaRuc";
this.Col_pe_cedulaRuc.Name = "Col_pe_cedulaRuc";
this.Col_pe_cedulaRuc.Options.ReadOnly = true;
this.Col_pe_cedulaRuc.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// Col_zo_descripcion
//
this.Col_zo_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_zo_descripcion.AreaIndex = 1;
this.Col_zo_descripcion.Caption = "ZONA";
this.Col_zo_descripcion.FieldName = "zo_descripcion";
this.Col_zo_descripcion.Name = "Col_zo_descripcion";
//
// cOL_fu_descripcion
//
this.cOL_fu_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOL_fu_descripcion.AreaIndex = 2;
this.cOL_fu_descripcion.Caption = "FUERZA";
this.cOL_fu_descripcion.FieldName = "fu_descripcion";
this.cOL_fu_descripcion.Name = "cOL_fu_descripcion";
//
// cOL_DISCO
//
this.cOL_DISCO.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOL_DISCO.AreaIndex = 3;
this.cOL_DISCO.Caption = "DISCO";
this.cOL_DISCO.FieldName = "Disco";
this.cOL_DISCO.Name = "cOL_DISCO";
//
// cOL_Placa
//
this.cOL_Placa.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOL_Placa.AreaIndex = 4;
this.cOL_Placa.Caption = "PLACA";
this.cOL_Placa.FieldName = "Placa";
this.cOL_Placa.Name = "cOL_Placa";
//
// cOL_ru_descripcion
//
this.cOL_ru_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOL_ru_descripcion.AreaIndex = 5;
this.cOL_ru_descripcion.Caption = "RUTA";
this.cOL_ru_descripcion.FieldName = "ru_descripcion";
this.cOL_ru_descripcion.Name = "cOL_ru_descripcion";
//
// cOL_em_fechaIngaRol
//
this.cOL_em_fechaIngaRol.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOL_em_fechaIngaRol.AreaIndex = 6;
this.cOL_em_fechaIngaRol.Caption = "FECHA INGRESO";
this.cOL_em_fechaIngaRol.FieldName = "em_fechaIngaRol";
this.cOL_em_fechaIngaRol.Name = "cOL_em_fechaIngaRol";
//
// cOL_pe_FechaIni
//
this.cOL_pe_FechaIni.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOL_pe_FechaIni.AreaIndex = 7;
this.cOL_pe_FechaIni.Caption = "FECHA MES";
this.cOL_pe_FechaIni.FieldName = "pe_FechaIni";
this.cOL_pe_FechaIni.Name = "cOL_pe_FechaIni";
//
// cOL_em_fechaSalida
//
this.cOL_em_fechaSalida.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOL_em_fechaSalida.AreaIndex = 8;
this.cOL_em_fechaSalida.Caption = "FECHA SALIDA";
this.cOL_em_fechaSalida.FieldName = "em_fechaSalida";
this.cOL_em_fechaSalida.Name = "cOL_em_fechaSalida";
//
// cOL_Cedula
//
this.cOL_Cedula.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOL_Cedula.AreaIndex = 9;
this.cOL_Cedula.Caption = "CEDULA";
this.cOL_Cedula.FieldName = "pe_cedulaRuc";
this.cOL_Cedula.Name = "cOL_Cedula";
//
// cOLNombres
//
this.cOLNombres.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOLNombres.AreaIndex = 10;
this.cOLNombres.Caption = "APELLIDOS Y NOMBRES";
this.cOLNombres.FieldName = "Nombres";
this.cOLNombres.Name = "cOLNombres";
//
// cOL_ca_descripcion
//
this.cOL_ca_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.cOL_ca_descripcion.AreaIndex = 11;
this.cOL_ca_descripcion.Caption = "CARGO";
this.cOL_ca_descripcion.FieldName = "ca_descripcion";
this.cOL_ca_descripcion.Name = "cOL_ca_descripcion";
//
// cOL_ca_orden
//
this.cOL_ca_orden.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.cOL_ca_orden.AreaIndex = 1;
this.cOL_ca_orden.Caption = "ORDEN2";
this.cOL_ca_orden.FieldName = "Orden";
this.cOL_ca_orden.Name = "cOL_ca_orden";
//
// cOL_Descripcion
//
this.cOL_Descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.cOL_Descripcion.AreaIndex = 2;
this.cOL_Descripcion.Caption = "RUBRO";
this.cOL_Descripcion.FieldName = "Descripcion";
this.cOL_Descripcion.Name = "cOL_Descripcion";
//
// COL_Valor
//
this.COL_Valor.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.COL_Valor.AreaIndex = 0;
this.COL_Valor.Caption = "VALOR";
this.COL_Valor.FieldName = "Valor";
this.COL_Valor.Name = "COL_Valor";
//
// Col_Catalogo
//
this.Col_Catalogo.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.Col_Catalogo.AreaIndex = 0;
this.Col_Catalogo.Caption = "ORDEN1";
this.Col_Catalogo.FieldName = "Catalogo";
this.Col_Catalogo.Name = "Col_Catalogo";
//
// ucRo_Menu
//
this.ucRo_Menu.caption_bei_check1 = "Check";
this.ucRo_Menu.Dock = System.Windows.Forms.DockStyle.Top;
this.ucRo_Menu.EnableBotonImprimir = true;
this.ucRo_Menu.Location = new System.Drawing.Point(0, 0);
this.ucRo_Menu.Name = "ucRo_Menu";
this.ucRo_Menu.Size = new System.Drawing.Size(1284, 74);
this.ucRo_Menu.TabIndex = 148;
this.ucRo_Menu.Visible_bei_check1 = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbCentroCosto = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbDivision = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbEmpleado = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbNominaTipo = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleCmbNominaTipoLiqui = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleCmbPeriodo = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleCmbRubro = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleDepartamento = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleEstado = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleGrupoFecha = false;
this.ucRo_Menu.VisibleGrupoFiltro1 = true;
this.ucRo_Menu.VisibleGrupoFiltro2 = false;
this.ucRo_Menu.VisubleArea = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.event_cmdCargar_ItemClick += new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes.delegate_cmdCargar_ItemClick(this.ucRo_Menu_event_cmdCargar_ItemClick);
this.ucRo_Menu.event_btnsalir_ItemClick += new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes.delegate_btnsalir_ItemClick(this.ucRo_Menu_event_btnsalir_ItemClick);
//
// Col_Dias_vacaciones
//
this.Col_Dias_vacaciones.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_Dias_vacaciones.AreaIndex = 12;
this.Col_Dias_vacaciones.Caption = "Días vacaciones";
this.Col_Dias_vacaciones.FieldName = "Dias_vacaciones";
this.Col_Dias_vacaciones.Name = "Col_Dias_vacaciones";
//
// XROLES_Rpt012_frm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1284, 491);
this.Controls.Add(this.pivotGridControl1);
this.Controls.Add(this.ucRo_Menu);
this.Name = "XROLES_Rpt012_frm";
this.Text = "XROLES_Rpt012_frm";
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).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.Utils.SerializableAppearanceObject serializableAppearanceObject1 = new DevExpress.Utils.SerializableAppearanceObject();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.dockManagerMain = new DevExpress.XtraBars.Docking.DockManager(this.components);
this.barManager1 = new DevExpress.XtraBars.BarManager(this.components);
this.bar2 = new DevExpress.XtraBars.Bar();
this.bbiExcelPivot = new DevExpress.XtraBars.BarButtonItem();
this.bbiExportRow = new DevExpress.XtraBars.BarButtonItem();
this.bbiPrint = new DevExpress.XtraBars.BarButtonItem();
this.bar3 = new DevExpress.XtraBars.Bar();
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.bbiExcelDynamicUpdate = new DevExpress.XtraBars.BarButtonItem();
this.panelContainerMain = new DevExpress.XtraBars.Docking.DockPanel();
this.dockPanelDashboard = new DevExpress.XtraBars.Docking.DockPanel();
this.dockPanel2_Container = new DevExpress.XtraBars.Docking.ControlContainer();
this.layoutControlParamter = new DevExpress.XtraLayout.LayoutControl();
this.layoutControlGroup2 = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlGroupParamters = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlDatasource = new DevExpress.XtraLayout.LayoutControl();
this.btnDeleteLayout = new DevExpress.XtraEditors.SimpleButton();
this.btnSaveAsLayout = new DevExpress.XtraEditors.SimpleButton();
this.btnLoadLayout = new DevExpress.XtraEditors.SimpleButton();
this.btnSaveLayout = new DevExpress.XtraEditors.SimpleButton();
this.lueLayout = new DevExpress.XtraEditors.GridLookUpEdit();
this.LSMSLayout = new DevExpress.Data.Linq.LinqServerModeSource();
this.gridView2 = new DevExpress.XtraGrid.Views.Grid.GridView();
this.colDatasourceLayoutName = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn5 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn();
this.ppWait = new DevExpress.XtraWaitForm.ProgressPanel();
this.btnLoadDashboard = new DevExpress.XtraEditors.SimpleButton();
this.layoutControlGroupDatasource = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlItem2 = new DevExpress.XtraLayout.LayoutControlItem();
this.layoutControlItemLoadLayout = new DevExpress.XtraLayout.LayoutControlItem();
this.layoutControlItemSave = new DevExpress.XtraLayout.LayoutControlItem();
this.lciWait = new DevExpress.XtraLayout.LayoutControlItem();
this.layoutControlItemSaveAs = new DevExpress.XtraLayout.LayoutControlItem();
this.layoutControlItemDelete = new DevExpress.XtraLayout.LayoutControlItem();
this.layoutControlItemLoad = new DevExpress.XtraLayout.LayoutControlItem();
this.dockPanelProperties = new DevExpress.XtraBars.Docking.DockPanel();
this.dockPanel1_Container = new DevExpress.XtraBars.Docking.ControlContainer();
this.layoutControl1 = new DevExpress.XtraLayout.LayoutControl();
this.pgcProperties = new DevExpress.XtraVerticalGrid.PropertyGridControl();
this.layoutControlGroup3 = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlItemPropertiesControl = new DevExpress.XtraLayout.LayoutControlItem();
this.LSMSDatasource = new DevExpress.Data.Linq.LinqServerModeSource();
this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl();
this.get_sp_PramTableAdapter = new NICSQLTools.Data.dsQryTableAdapters.Get_sp_PramTableAdapter();
this.appDatasourceLayoutTableAdapter = new NICSQLTools.Data.dsDataTableAdapters.AppDatasourceLayoutTableAdapter();
this.appDashboardDSTableAdapter = new NICSQLTools.Data.dsDataSourceTableAdapters.AppDatasourceTableAdapter();
this.appDashboardDSPramTableAdapter = new NICSQLTools.Data.dsDataSourceTableAdapters.AppDatasourceParamTableAdapter();
this.sfd = new System.Windows.Forms.SaveFileDialog();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dockManagerMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.barManager1)).BeginInit();
this.panelContainerMain.SuspendLayout();
this.dockPanelDashboard.SuspendLayout();
this.dockPanel2_Container.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.layoutControlParamter)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupParamters)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlDatasource)).BeginInit();
this.layoutControlDatasource.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.lueLayout.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.LSMSLayout)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridView2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupDatasource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemLoadLayout)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemSave)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.lciWait)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemSaveAs)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemDelete)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemLoad)).BeginInit();
this.dockPanelProperties.SuspendLayout();
this.dockPanel1_Container.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit();
this.layoutControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.pgcProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemPropertiesControl)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.LSMSDatasource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit();
this.SuspendLayout();
//
// 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.DisplayFormat.FormatString = "d/M/yyyy hh:mm:ss";
this.repositoryItemDateEdit1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.repositoryItemDateEdit1.EditFormat.FormatString = "d/M/yyyy hh:mm:ss";
this.repositoryItemDateEdit1.EditFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.repositoryItemDateEdit1.Mask.EditMask = "d/M/yyyy hh:mm:ss";
this.repositoryItemDateEdit1.Name = "repositoryItemDateEdit1";
//
// dockManagerMain
//
this.dockManagerMain.Form = this;
this.dockManagerMain.MenuManager = this.barManager1;
this.dockManagerMain.RootPanels.AddRange(new DevExpress.XtraBars.Docking.DockPanel[] {
this.panelContainerMain});
this.dockManagerMain.TopZIndexControls.AddRange(new string[] {
"DevExpress.XtraBars.BarDockControl",
"DevExpress.XtraBars.StandaloneBarDockControl",
"System.Windows.Forms.StatusBar",
"System.Windows.Forms.MenuStrip",
"System.Windows.Forms.StatusStrip",
"DevExpress.XtraBars.Ribbon.RibbonStatusBar",
"DevExpress.XtraBars.Ribbon.RibbonControl"});
//
// barManager1
//
this.barManager1.Bars.AddRange(new DevExpress.XtraBars.Bar[] {
this.bar2,
this.bar3});
this.barManager1.DockControls.Add(this.barDockControlTop);
this.barManager1.DockControls.Add(this.barDockControlBottom);
this.barManager1.DockControls.Add(this.barDockControlLeft);
this.barManager1.DockControls.Add(this.barDockControlRight);
this.barManager1.DockManager = this.dockManagerMain;
this.barManager1.Form = this;
this.barManager1.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
this.bbiExcelPivot,
this.bbiPrint,
this.bbiExportRow,
this.bbiExcelDynamicUpdate});
this.barManager1.MainMenu = this.bar2;
this.barManager1.MaxItemId = 8;
this.barManager1.StatusBar = this.bar3;
//
// bar2
//
this.bar2.BarName = "Main menu";
this.bar2.DockCol = 0;
this.bar2.DockRow = 0;
this.bar2.DockStyle = DevExpress.XtraBars.BarDockStyle.Top;
this.bar2.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
new DevExpress.XtraBars.LinkPersistInfo(this.bbiExcelPivot),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiExportRow),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiPrint)});
this.bar2.OptionsBar.MultiLine = true;
this.bar2.OptionsBar.UseWholeRow = true;
this.bar2.Text = "Main menu";
//
// bbiExcelPivot
//
this.bbiExcelPivot.Caption = "Excel Pivot";
this.bbiExcelPivot.Glyph = global::NICSQLTools.Properties.Resources.Export;
this.bbiExcelPivot.Id = 0;
this.bbiExcelPivot.Name = "bbiExcelPivot";
this.bbiExcelPivot.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
this.bbiExcelPivot.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExcelPivot_ItemClick);
//
// bbiExportRow
//
this.bbiExportRow.Caption = "Export Table";
this.bbiExportRow.Glyph = global::NICSQLTools.Properties.Resources.grid_16x16;
this.bbiExportRow.Id = 6;
this.bbiExportRow.LargeGlyph = global::NICSQLTools.Properties.Resources.grid_32x32;
this.bbiExportRow.Name = "bbiExportRow";
this.bbiExportRow.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
this.bbiExportRow.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExportRow_ItemClick);
//
// bbiPrint
//
this.bbiPrint.Caption = "Print Pivot";
this.bbiPrint.Glyph = global::NICSQLTools.Properties.Resources.print_16x16;
this.bbiPrint.Id = 4;
this.bbiPrint.Name = "bbiPrint";
this.bbiPrint.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
this.bbiPrint.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiPrint_ItemClick);
//
// bar3
//
this.bar3.BarName = "Status bar";
this.bar3.CanDockStyle = DevExpress.XtraBars.BarCanDockStyle.Bottom;
this.bar3.DockCol = 0;
this.bar3.DockRow = 0;
this.bar3.DockStyle = DevExpress.XtraBars.BarDockStyle.Bottom;
this.bar3.OptionsBar.AllowQuickCustomization = false;
this.bar3.OptionsBar.DrawDragBorder = false;
this.bar3.OptionsBar.UseWholeRow = true;
this.bar3.Text = "Status bar";
//
// 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(757, 24);
//
// barDockControlBottom
//
this.barDockControlBottom.CausesValidation = false;
this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
this.barDockControlBottom.Location = new System.Drawing.Point(0, 463);
this.barDockControlBottom.Size = new System.Drawing.Size(757, 23);
//
// barDockControlLeft
//
this.barDockControlLeft.CausesValidation = false;
this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
this.barDockControlLeft.Location = new System.Drawing.Point(0, 24);
this.barDockControlLeft.Size = new System.Drawing.Size(0, 439);
//
// barDockControlRight
//
this.barDockControlRight.CausesValidation = false;
this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
this.barDockControlRight.Location = new System.Drawing.Point(757, 24);
this.barDockControlRight.Size = new System.Drawing.Size(0, 439);
//
// bbiExcelDynamicUpdate
//
this.bbiExcelDynamicUpdate.Caption = "Excel Dynamic Update";
this.bbiExcelDynamicUpdate.Glyph = global::NICSQLTools.Properties.Resources.Excel16;
this.bbiExcelDynamicUpdate.Id = 7;
this.bbiExcelDynamicUpdate.Name = "bbiExcelDynamicUpdate";
this.bbiExcelDynamicUpdate.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
//
// panelContainerMain
//
this.panelContainerMain.ActiveChild = this.dockPanelDashboard;
this.panelContainerMain.Controls.Add(this.dockPanelDashboard);
this.panelContainerMain.Controls.Add(this.dockPanelProperties);
this.panelContainerMain.Dock = DevExpress.XtraBars.Docking.DockingStyle.Left;
this.panelContainerMain.ID = new System.Guid("b03cb66a-f343-43c5-9f00-cc38f1b88658");
this.panelContainerMain.Location = new System.Drawing.Point(0, 24);
this.panelContainerMain.Name = "panelContainerMain";
this.panelContainerMain.OriginalSize = new System.Drawing.Size(363, 200);
this.panelContainerMain.Size = new System.Drawing.Size(363, 439);
this.panelContainerMain.Tabbed = true;
this.panelContainerMain.Text = "panelContainer1";
//
// dockPanelDashboard
//
this.dockPanelDashboard.Controls.Add(this.dockPanel2_Container);
this.dockPanelDashboard.Dock = DevExpress.XtraBars.Docking.DockingStyle.Fill;
this.dockPanelDashboard.FloatVertical = true;
this.dockPanelDashboard.ID = new System.Guid("2fa5a753-1d56-4b04-8069-bd742a7da53c");
this.dockPanelDashboard.Image = global::NICSQLTools.Properties.Resources.properties_32x32;
this.dockPanelDashboard.Location = new System.Drawing.Point(4, 23);
this.dockPanelDashboard.Name = "dockPanelDashboard";
this.dockPanelDashboard.Options.ShowCloseButton = false;
this.dockPanelDashboard.OriginalSize = new System.Drawing.Size(350, 368);
this.dockPanelDashboard.Size = new System.Drawing.Size(355, 368);
this.dockPanelDashboard.Text = "Control Panal";
//
// dockPanel2_Container
//
this.dockPanel2_Container.Controls.Add(this.layoutControlParamter);
this.dockPanel2_Container.Controls.Add(this.layoutControlDatasource);
this.dockPanel2_Container.Location = new System.Drawing.Point(0, 0);
this.dockPanel2_Container.Name = "dockPanel2_Container";
this.dockPanel2_Container.Size = new System.Drawing.Size(355, 368);
this.dockPanel2_Container.TabIndex = 0;
//
// layoutControlParamter
//
this.layoutControlParamter.Dock = System.Windows.Forms.DockStyle.Fill;
this.layoutControlParamter.Location = new System.Drawing.Point(0, 157);
this.layoutControlParamter.Name = "layoutControlParamter";
this.layoutControlParamter.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(406, 100, 434, 493);
this.layoutControlParamter.Root = this.layoutControlGroup2;
this.layoutControlParamter.Size = new System.Drawing.Size(355, 211);
this.layoutControlParamter.TabIndex = 1;
this.layoutControlParamter.Text = "layoutControl2";
//
// layoutControlGroup2
//
this.layoutControlGroup2.CustomizationFormText = "Root";
this.layoutControlGroup2.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;
this.layoutControlGroup2.GroupBordersVisible = false;
this.layoutControlGroup2.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
this.layoutControlGroupParamters});
this.layoutControlGroup2.Location = new System.Drawing.Point(0, 0);
this.layoutControlGroup2.Name = "Root";
this.layoutControlGroup2.Size = new System.Drawing.Size(355, 211);
this.layoutControlGroup2.TextVisible = false;
//
// layoutControlGroupParamters
//
this.layoutControlGroupParamters.CustomizationFormText = "Paramters";
this.layoutControlGroupParamters.Location = new System.Drawing.Point(0, 0);
this.layoutControlGroupParamters.Name = "layoutControlGroupParamters";
this.layoutControlGroupParamters.Size = new System.Drawing.Size(335, 191);
this.layoutControlGroupParamters.Text = "Paramters";
//
// layoutControlDatasource
//
this.layoutControlDatasource.Controls.Add(this.btnDeleteLayout);
this.layoutControlDatasource.Controls.Add(this.btnSaveAsLayout);
this.layoutControlDatasource.Controls.Add(this.btnLoadLayout);
this.layoutControlDatasource.Controls.Add(this.btnSaveLayout);
this.layoutControlDatasource.Controls.Add(this.lueLayout);
this.layoutControlDatasource.Controls.Add(this.ppWait);
this.layoutControlDatasource.Controls.Add(this.btnLoadDashboard);
this.layoutControlDatasource.Dock = System.Windows.Forms.DockStyle.Top;
this.layoutControlDatasource.Location = new System.Drawing.Point(0, 0);
this.layoutControlDatasource.Name = "layoutControlDatasource";
this.layoutControlDatasource.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(569, 119, 328, 452);
this.layoutControlDatasource.Root = this.layoutControlGroupDatasource;
this.layoutControlDatasource.Size = new System.Drawing.Size(355, 157);
this.layoutControlDatasource.TabIndex = 0;
this.layoutControlDatasource.Text = "layoutControl1";
//
// btnDeleteLayout
//
this.btnDeleteLayout.Image = global::NICSQLTools.Properties.Resources.delete_16x16;
this.btnDeleteLayout.Location = new System.Drawing.Point(262, 123);
this.btnDeleteLayout.Name = "btnDeleteLayout";
this.btnDeleteLayout.Size = new System.Drawing.Size(81, 22);
this.btnDeleteLayout.StyleController = this.layoutControlDatasource;
this.btnDeleteLayout.TabIndex = 8;
this.btnDeleteLayout.Text = "Delete";
this.btnDeleteLayout.Click += new System.EventHandler(this.btnDeleteLayout_Click);
//
// btnSaveAsLayout
//
this.btnSaveAsLayout.Image = global::NICSQLTools.Properties.Resources.saveall_16x16;
this.btnSaveAsLayout.Location = new System.Drawing.Point(96, 123);
this.btnSaveAsLayout.Name = "btnSaveAsLayout";
this.btnSaveAsLayout.Size = new System.Drawing.Size(89, 22);
this.btnSaveAsLayout.StyleController = this.layoutControlDatasource;
this.btnSaveAsLayout.TabIndex = 7;
this.btnSaveAsLayout.Text = "Save As";
this.btnSaveAsLayout.Click += new System.EventHandler(this.btnSaveAsLayout_Click);
//
// btnLoadLayout
//
this.btnLoadLayout.Image = global::NICSQLTools.Properties.Resources.loadfrom_16x16;
this.btnLoadLayout.Location = new System.Drawing.Point(189, 123);
this.btnLoadLayout.Name = "btnLoadLayout";
this.btnLoadLayout.Size = new System.Drawing.Size(69, 22);
this.btnLoadLayout.StyleController = this.layoutControlDatasource;
this.btnLoadLayout.TabIndex = 6;
this.btnLoadLayout.Text = "Load";
this.btnLoadLayout.Click += new System.EventHandler(this.btnLoadLayout_Click);
//
// btnSaveLayout
//
this.btnSaveLayout.Image = global::NICSQLTools.Properties.Resources.save_16x16;
this.btnSaveLayout.Location = new System.Drawing.Point(12, 123);
this.btnSaveLayout.Name = "btnSaveLayout";
this.btnSaveLayout.Size = new System.Drawing.Size(80, 22);
this.btnSaveLayout.StyleController = this.layoutControlDatasource;
this.btnSaveLayout.TabIndex = 5;
this.btnSaveLayout.Text = "Save";
this.btnSaveLayout.Click += new System.EventHandler(this.btnSaveLayout_Click);
//
// lueLayout
//
this.lueLayout.EditValue = "";
this.lueLayout.Location = new System.Drawing.Point(48, 97);
this.lueLayout.Name = "lueLayout";
this.lueLayout.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
this.lueLayout.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo),
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph, "", -1, true, true, false, DevExpress.XtraEditors.ImageLocation.MiddleCenter, global::NICSQLTools.Properties.Resources.refresh_16x16, new DevExpress.Utils.KeyShortcut(System.Windows.Forms.Keys.None), serializableAppearanceObject1, "", null, null, true)});
this.lueLayout.Properties.DataSource = this.LSMSLayout;
this.lueLayout.Properties.DisplayMember = "DatasourceLayoutName";
this.lueLayout.Properties.NullText = "";
this.lueLayout.Properties.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.StartsWith;
this.lueLayout.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
this.lueLayout.Properties.ValueMember = "DatasourceLayoutId";
this.lueLayout.Properties.View = this.gridView2;
this.lueLayout.Properties.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.lueLayout_Properties_ButtonClick);
this.lueLayout.Size = new System.Drawing.Size(295, 22);
this.lueLayout.StyleController = this.layoutControlDatasource;
this.lueLayout.TabIndex = 4;
//
// LSMSLayout
//
this.LSMSLayout.ElementType = typeof(NICSQLTools.Data.Linq.vAppDatasourceLayout_LUE);
this.LSMSLayout.KeyExpression = "[DatasourceLayoutId]";
//
// gridView2
//
this.gridView2.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
this.colDatasourceLayoutName,
this.gridColumn4,
this.gridColumn5,
this.gridColumn3});
this.gridView2.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
this.gridView2.Name = "gridView2";
this.gridView2.OptionsSelection.EnableAppearanceFocusedCell = false;
this.gridView2.OptionsView.AnimationType = DevExpress.XtraGrid.Views.Base.GridAnimationType.AnimateAllContent;
this.gridView2.OptionsView.ColumnAutoWidth = false;
this.gridView2.OptionsView.EnableAppearanceEvenRow = true;
this.gridView2.OptionsView.EnableAppearanceOddRow = true;
this.gridView2.OptionsView.ShowAutoFilterRow = true;
this.gridView2.OptionsView.ShowGroupPanel = false;
this.gridView2.OptionsView.ShowIndicator = false;
this.gridView2.OptionsView.WaitAnimationOptions = DevExpress.XtraEditors.WaitAnimationOptions.Panel;
//
// colDatasourceLayoutName
//
this.colDatasourceLayoutName.Caption = "Dashboard Schema Name";
this.colDatasourceLayoutName.FieldName = "DatasourceLayoutName";
this.colDatasourceLayoutName.Name = "colDatasourceLayoutName";
this.colDatasourceLayoutName.Visible = true;
this.colDatasourceLayoutName.VisibleIndex = 0;
this.colDatasourceLayoutName.Width = 132;
//
// gridColumn4
//
this.gridColumn4.Caption = "Last Edit";
this.gridColumn4.ColumnEdit = this.repositoryItemDateEdit1;
this.gridColumn4.FieldName = "DateIn";
this.gridColumn4.Name = "gridColumn4";
this.gridColumn4.Visible = true;
this.gridColumn4.VisibleIndex = 1;
//
// gridColumn5
//
this.gridColumn5.Caption = "Edit User";
this.gridColumn5.FieldName = "RealName";
this.gridColumn5.Name = "gridColumn5";
this.gridColumn5.Visible = true;
this.gridColumn5.VisibleIndex = 2;
//
// gridColumn3
//
this.gridColumn3.Caption = "Data Source";
this.gridColumn3.FieldName = "DatasourceName";
this.gridColumn3.Name = "gridColumn3";
this.gridColumn3.Visible = true;
this.gridColumn3.VisibleIndex = 3;
//
// ppWait
//
this.ppWait.Appearance.BackColor = System.Drawing.Color.Transparent;
this.ppWait.Appearance.Options.UseBackColor = true;
this.ppWait.AppearanceCaption.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F);
this.ppWait.AppearanceCaption.Options.UseFont = true;
this.ppWait.AppearanceDescription.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F);
this.ppWait.AppearanceDescription.Options.UseFont = true;
this.ppWait.Location = new System.Drawing.Point(12, 12);
this.ppWait.Name = "ppWait";
this.ppWait.Size = new System.Drawing.Size(331, 46);
this.ppWait.StyleController = this.layoutControlDatasource;
this.ppWait.TabIndex = 2;
this.ppWait.Text = "Loading ...";
//
// btnLoadDashboard
//
this.btnLoadDashboard.Image = global::NICSQLTools.Properties.Resources.technology_32x32;
this.btnLoadDashboard.Location = new System.Drawing.Point(12, 62);
this.btnLoadDashboard.Name = "btnLoadDashboard";
this.btnLoadDashboard.Size = new System.Drawing.Size(331, 31);
this.btnLoadDashboard.StyleController = this.layoutControlDatasource;
this.btnLoadDashboard.TabIndex = 1;
this.btnLoadDashboard.Text = "Load Datasource";
this.btnLoadDashboard.Click += new System.EventHandler(this.btnLoadDatasource_Click);
//
// layoutControlGroupDatasource
//
this.layoutControlGroupDatasource.CustomizationFormText = "layoutControlGroup Datasource";
this.layoutControlGroupDatasource.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;
this.layoutControlGroupDatasource.GroupBordersVisible = false;
this.layoutControlGroupDatasource.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
this.layoutControlItem2,
this.layoutControlItemLoadLayout,
this.layoutControlItemSave,
this.lciWait,
this.layoutControlItemSaveAs,
this.layoutControlItemDelete,
this.layoutControlItemLoad});
this.layoutControlGroupDatasource.Location = new System.Drawing.Point(0, 0);
this.layoutControlGroupDatasource.Name = "Root";
this.layoutControlGroupDatasource.Size = new System.Drawing.Size(355, 157);
this.layoutControlGroupDatasource.Text = "Datasource";
this.layoutControlGroupDatasource.TextVisible = false;
//
// layoutControlItem2
//
this.layoutControlItem2.Control = this.btnLoadDashboard;
this.layoutControlItem2.CustomizationFormText = "btnLoad";
this.layoutControlItem2.Location = new System.Drawing.Point(0, 50);
this.layoutControlItem2.MaxSize = new System.Drawing.Size(0, 35);
this.layoutControlItem2.MinSize = new System.Drawing.Size(128, 30);
this.layoutControlItem2.Name = "layoutControlItem2";
this.layoutControlItem2.Size = new System.Drawing.Size(335, 35);
this.layoutControlItem2.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;
this.layoutControlItem2.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItem2.TextVisible = false;
//
// layoutControlItemLoadLayout
//
this.layoutControlItemLoadLayout.Control = this.lueLayout;
this.layoutControlItemLoadLayout.CustomizationFormText = "Layout";
this.layoutControlItemLoadLayout.Location = new System.Drawing.Point(0, 85);
this.layoutControlItemLoadLayout.Name = "layoutControlItemLoadLayout";
this.layoutControlItemLoadLayout.Size = new System.Drawing.Size(335, 26);
this.layoutControlItemLoadLayout.Text = "Layout";
this.layoutControlItemLoadLayout.TextSize = new System.Drawing.Size(33, 13);
//
// layoutControlItemSave
//
this.layoutControlItemSave.Control = this.btnSaveLayout;
this.layoutControlItemSave.CustomizationFormText = "Save";
this.layoutControlItemSave.Location = new System.Drawing.Point(0, 111);
this.layoutControlItemSave.Name = "layoutControlItemSave";
this.layoutControlItemSave.Size = new System.Drawing.Size(84, 26);
this.layoutControlItemSave.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItemSave.TextVisible = false;
//
// lciWait
//
this.lciWait.Control = this.ppWait;
this.lciWait.CustomizationFormText = "lciWait";
this.lciWait.Location = new System.Drawing.Point(0, 0);
this.lciWait.MaxSize = new System.Drawing.Size(0, 50);
this.lciWait.MinSize = new System.Drawing.Size(54, 50);
this.lciWait.Name = "lciWait";
this.lciWait.Size = new System.Drawing.Size(335, 50);
this.lciWait.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;
this.lciWait.TextSize = new System.Drawing.Size(0, 0);
this.lciWait.TextVisible = false;
this.lciWait.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
//
// layoutControlItemSaveAs
//
this.layoutControlItemSaveAs.Control = this.btnSaveAsLayout;
this.layoutControlItemSaveAs.CustomizationFormText = "Save As";
this.layoutControlItemSaveAs.Location = new System.Drawing.Point(84, 111);
this.layoutControlItemSaveAs.Name = "layoutControlItemSaveAs";
this.layoutControlItemSaveAs.Size = new System.Drawing.Size(93, 26);
this.layoutControlItemSaveAs.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItemSaveAs.TextVisible = false;
//
// layoutControlItemDelete
//
this.layoutControlItemDelete.Control = this.btnDeleteLayout;
this.layoutControlItemDelete.CustomizationFormText = "Delete";
this.layoutControlItemDelete.Location = new System.Drawing.Point(250, 111);
this.layoutControlItemDelete.Name = "layoutControlItemDelete";
this.layoutControlItemDelete.Size = new System.Drawing.Size(85, 26);
this.layoutControlItemDelete.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItemDelete.TextVisible = false;
//
// layoutControlItemLoad
//
this.layoutControlItemLoad.Control = this.btnLoadLayout;
this.layoutControlItemLoad.CustomizationFormText = "Load";
this.layoutControlItemLoad.Location = new System.Drawing.Point(177, 111);
this.layoutControlItemLoad.Name = "layoutControlItemLoad";
this.layoutControlItemLoad.Size = new System.Drawing.Size(73, 26);
this.layoutControlItemLoad.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItemLoad.TextVisible = false;
//
// dockPanelProperties
//
this.dockPanelProperties.Controls.Add(this.dockPanel1_Container);
this.dockPanelProperties.Dock = DevExpress.XtraBars.Docking.DockingStyle.Fill;
this.dockPanelProperties.ID = new System.Guid("634f77b0-9bd0-4566-89ca-9c7d09a3bde3");
this.dockPanelProperties.Image = global::NICSQLTools.Properties.Resources.pagesetup_32x32;
this.dockPanelProperties.Location = new System.Drawing.Point(4, 23);
this.dockPanelProperties.Name = "dockPanelProperties";
this.dockPanelProperties.Options.ShowCloseButton = false;
this.dockPanelProperties.OriginalSize = new System.Drawing.Size(350, 368);
this.dockPanelProperties.Size = new System.Drawing.Size(355, 368);
this.dockPanelProperties.Text = "Properties";
//
// dockPanel1_Container
//
this.dockPanel1_Container.Controls.Add(this.layoutControl1);
this.dockPanel1_Container.Location = new System.Drawing.Point(0, 0);
this.dockPanel1_Container.Name = "dockPanel1_Container";
this.dockPanel1_Container.Size = new System.Drawing.Size(355, 368);
this.dockPanel1_Container.TabIndex = 0;
//
// layoutControl1
//
this.layoutControl1.Controls.Add(this.pgcProperties);
this.layoutControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.layoutControl1.Location = new System.Drawing.Point(0, 0);
this.layoutControl1.Name = "layoutControl1";
this.layoutControl1.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(541, 139, 250, 350);
this.layoutControl1.Root = this.layoutControlGroup3;
this.layoutControl1.Size = new System.Drawing.Size(355, 368);
this.layoutControl1.TabIndex = 1;
this.layoutControl1.Text = "layoutControl1";
//
// pgcProperties
//
this.pgcProperties.AutoGenerateRows = true;
this.pgcProperties.Location = new System.Drawing.Point(12, 12);
this.pgcProperties.Name = "pgcProperties";
this.pgcProperties.Size = new System.Drawing.Size(331, 344);
this.pgcProperties.TabIndex = 0;
//
// layoutControlGroup3
//
this.layoutControlGroup3.CustomizationFormText = "layoutControlGroup3";
this.layoutControlGroup3.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;
this.layoutControlGroup3.GroupBordersVisible = false;
this.layoutControlGroup3.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
this.layoutControlItemPropertiesControl});
this.layoutControlGroup3.Location = new System.Drawing.Point(0, 0);
this.layoutControlGroup3.Name = "layoutControlGroup3";
this.layoutControlGroup3.Size = new System.Drawing.Size(355, 368);
this.layoutControlGroup3.TextVisible = false;
//
// layoutControlItemPropertiesControl
//
this.layoutControlItemPropertiesControl.Control = this.pgcProperties;
this.layoutControlItemPropertiesControl.CustomizationFormText = "Properties Control";
this.layoutControlItemPropertiesControl.Location = new System.Drawing.Point(0, 0);
this.layoutControlItemPropertiesControl.Name = "layoutControlItemPropertiesControl";
this.layoutControlItemPropertiesControl.Size = new System.Drawing.Size(335, 348);
this.layoutControlItemPropertiesControl.Text = "Properties Control";
this.layoutControlItemPropertiesControl.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItemPropertiesControl.TextVisible = false;
//
// LSMSDatasource
//
this.LSMSDatasource.ElementType = typeof(NICSQLTools.Data.Linq.vAppDatasource_LUE);
this.LSMSDatasource.KeyExpression = "[DatasourceID]";
//
// pivotGridControlMain
//
this.pivotGridControlMain.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 10F);
this.pivotGridControlMain.Appearance.Cell.Options.UseFont = true;
this.pivotGridControlMain.Appearance.FieldHeader.Font = new System.Drawing.Font("Tahoma", 10F);
this.pivotGridControlMain.Appearance.FieldHeader.Options.UseFont = true;
this.pivotGridControlMain.Appearance.FieldValue.Font = new System.Drawing.Font("Tahoma", 10F);
this.pivotGridControlMain.Appearance.FieldValue.Options.UseFont = true;
this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill;
pivotGridGroup1.Caption = "Sales District Level";
pivotGridGroup1.Hierarchy = "[Route].[Sales District Level]";
pivotGridGroup1.ShowNewValues = true;
this.pivotGridControlMain.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1});
this.pivotGridControlMain.Location = new System.Drawing.Point(363, 24);
this.pivotGridControlMain.Name = "pivotGridControlMain";
this.pivotGridControlMain.OLAPConnectionString = "";
this.pivotGridControlMain.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.OleDb;
this.pivotGridControlMain.OptionsData.DataFieldUnboundExpressionMode = DevExpress.XtraPivotGrid.DataFieldUnboundExpressionMode.UseSummaryValues;
this.pivotGridControlMain.OptionsLayout.AddNewGroups = true;
this.pivotGridControlMain.OptionsLayout.Columns.RemoveOldColumns = false;
this.pivotGridControlMain.OptionsLayout.Columns.StoreAllOptions = true;
this.pivotGridControlMain.OptionsLayout.Columns.StoreAppearance = true;
this.pivotGridControlMain.OptionsLayout.StoreAllOptions = true;
this.pivotGridControlMain.OptionsLayout.StoreAppearance = true;
this.pivotGridControlMain.OptionsLayout.StoreLayoutOptions = true;
this.pivotGridControlMain.Size = new System.Drawing.Size(394, 439);
this.pivotGridControlMain.TabIndex = 2;
this.pivotGridControlMain.PopupMenuShowing += new DevExpress.XtraPivotGrid.PopupMenuShowingEventHandler(this.pivotGridControlMain_PopupMenuShowing);
//
// get_sp_PramTableAdapter
//
this.get_sp_PramTableAdapter.ClearBeforeFill = true;
//
// appDatasourceLayoutTableAdapter
//
this.appDatasourceLayoutTableAdapter.ClearBeforeFill = true;
//
// appDashboardDSTableAdapter
//
this.appDashboardDSTableAdapter.ClearBeforeFill = true;
//
// appDashboardDSPramTableAdapter
//
this.appDashboardDSPramTableAdapter.ClearBeforeFill = true;
//
// sfd
//
this.sfd.Filter = "excel workbook (*.xlsx)|*.xlsx";
this.sfd.Title = "export to excel file (xlsx)";
//
// QryPivotUC
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.Controls.Add(this.pivotGridControlMain);
this.Controls.Add(this.panelContainerMain);
this.Controls.Add(this.barDockControlLeft);
this.Controls.Add(this.barDockControlRight);
this.Controls.Add(this.barDockControlBottom);
this.Controls.Add(this.barDockControlTop);
this.Name = "QryPivotUC";
this.Size = new System.Drawing.Size(757, 486);
this.Load += new System.EventHandler(this.QryPivotUC_Load);
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dockManagerMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.barManager1)).EndInit();
this.panelContainerMain.ResumeLayout(false);
this.dockPanelDashboard.ResumeLayout(false);
this.dockPanel2_Container.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.layoutControlParamter)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupParamters)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlDatasource)).EndInit();
this.layoutControlDatasource.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.lueLayout.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.LSMSLayout)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridView2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupDatasource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemLoadLayout)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemSave)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.lciWait)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemSaveAs)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemDelete)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemLoad)).EndInit();
this.dockPanelProperties.ResumeLayout(false);
this.dockPanel1_Container.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).EndInit();
this.layoutControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.pgcProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItemPropertiesControl)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.LSMSDatasource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
DevExpress.DataAccess.Excel.FieldInfo fieldInfo1 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo2 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo3 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo4 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo5 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo6 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo7 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo8 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo9 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo10 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo11 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo12 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.ExcelWorksheetSettings excelWorksheetSettings1 = new DevExpress.DataAccess.Excel.ExcelWorksheetSettings();
DevExpress.DataAccess.Excel.ExcelSourceOptions excelSourceOptions1 = new DevExpress.DataAccess.Excel.ExcelSourceOptions(excelWorksheetSettings1);
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.excelDataSource1 = new DevExpress.DataAccess.Excel.ExcelDataSource();
this.btnSave = new DevExpress.XtraEditors.SimpleButton();
this.btnLoad = new DevExpress.XtraEditors.SimpleButton();
this.fieldFirstName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.btnClear = new DevExpress.XtraEditors.SimpleButton();
this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.pivotGridControl1.DataSource = this.excelDataSource1;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldCategoryName1,
this.fieldProductName1,
this.fieldSalesPerson1,
this.fieldExtendedPrice1
});
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(12, 41);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.Size = new System.Drawing.Size(727, 416);
this.pivotGridControl1.TabIndex = 0;
//
// excelDataSource1
//
this.excelDataSource1.Name = "excelDataSource1";
this.excelDataSource1.ResultSchemaSerializable = resources.GetString("excelDataSource1.ResultSchemaSerializable");
fieldInfo1.Name = "CategoryName";
fieldInfo1.Type = typeof(string);
fieldInfo2.Name = "Country";
fieldInfo2.Type = typeof(string);
fieldInfo3.Name = "FirstName";
fieldInfo3.Type = typeof(string);
fieldInfo4.Name = "LastName";
fieldInfo4.Type = typeof(string);
fieldInfo5.Name = "ProductName";
fieldInfo5.Type = typeof(string);
fieldInfo6.Name = "Sales Person";
fieldInfo6.Type = typeof(string);
fieldInfo7.Name = "OrderDate";
fieldInfo7.Type = typeof(System.DateTime);
fieldInfo8.Name = "OrderID";
fieldInfo8.Type = typeof(double);
fieldInfo9.Name = "Quantity";
fieldInfo9.Type = typeof(double);
fieldInfo10.Name = "Discount";
fieldInfo10.Type = typeof(double);
fieldInfo11.Name = "Extended Price";
fieldInfo11.Type = typeof(double);
fieldInfo12.Name = "UnitPrice";
fieldInfo12.Type = typeof(double);
this.excelDataSource1.Schema.AddRange(new DevExpress.DataAccess.Excel.FieldInfo[] {
fieldInfo1,
fieldInfo2,
fieldInfo3,
fieldInfo4,
fieldInfo5,
fieldInfo6,
fieldInfo7,
fieldInfo8,
fieldInfo9,
fieldInfo10,
fieldInfo11,
fieldInfo12
});
excelWorksheetSettings1.CellRange = null;
excelWorksheetSettings1.WorksheetName = "Data";
excelSourceOptions1.ImportSettings = excelWorksheetSettings1;
this.excelDataSource1.SourceOptions = excelSourceOptions1;
//
// btnSave
//
this.btnSave.Location = new System.Drawing.Point(13, 12);
this.btnSave.Name = "btnSave";
this.btnSave.Size = new System.Drawing.Size(75, 23);
this.btnSave.TabIndex = 1;
this.btnSave.Text = "Save";
this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
//
// btnLoad
//
this.btnLoad.Location = new System.Drawing.Point(94, 12);
this.btnLoad.Name = "btnLoad";
this.btnLoad.Size = new System.Drawing.Size(75, 23);
this.btnLoad.TabIndex = 2;
this.btnLoad.Text = "Load";
this.btnLoad.Click += new System.EventHandler(this.btnLoad_Click);
//
// fieldFirstName1
//
this.fieldFirstName1.AreaIndex = 0;
this.fieldFirstName1.Caption = "First Name";
this.fieldFirstName1.FieldName = "FirstName";
this.fieldFirstName1.Name = "fieldFirstName1";
//
// btnClear
//
this.btnClear.Location = new System.Drawing.Point(175, 12);
this.btnClear.Name = "btnClear";
this.btnClear.Size = new System.Drawing.Size(75, 23);
this.btnClear.TabIndex = 3;
this.btnClear.Text = "Clear";
this.btnClear.Click += new System.EventHandler(this.btnClear_Click);
//
// fieldCategoryName1
//
this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCategoryName1.AreaIndex = 0;
this.fieldCategoryName1.Caption = "Category Name";
this.fieldCategoryName1.FieldName = "CategoryName";
this.fieldCategoryName1.Name = "fieldCategoryName1";
//
// fieldProductName1
//
this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldProductName1.AreaIndex = 1;
this.fieldProductName1.Caption = "Product Name";
this.fieldProductName1.FieldName = "ProductName";
this.fieldProductName1.Name = "fieldProductName1";
//
// fieldSalesPerson1
//
this.fieldSalesPerson1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldSalesPerson1.AreaIndex = 0;
this.fieldSalesPerson1.Caption = "Sales Person";
this.fieldSalesPerson1.FieldName = "Sales Person";
this.fieldSalesPerson1.Name = "fieldSalesPerson1";
//
// fieldExtendedPrice1
//
this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldExtendedPrice1.AreaIndex = 0;
this.fieldExtendedPrice1.Caption = "Extended Price";
this.fieldExtendedPrice1.FieldName = "Extended Price";
this.fieldExtendedPrice1.Name = "fieldExtendedPrice1";
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(751, 469);
this.Controls.Add(this.btnClear);
this.Controls.Add(this.btnLoad);
this.Controls.Add(this.btnSave);
this.Controls.Add(this.pivotGridControl1);
this.Name = "Form1";
this.Text = "RestoreLayoutExample";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).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.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding1 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding2 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding3 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding4 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding5 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding6 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding7 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding8 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding9 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding10 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding11 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding12 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding13 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding14 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding();
this.roomBookingCollection = new DevExpress.Xpo.XPCollection(this.components);
this.session = new DevExpress.Xpo.Session(this.components);
this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.fieldCapacityRequirementName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCapacityRequirementCapacity1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCapacityRequirementRoomSetup1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCapacityRequirementEventName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCapacityRequirementEventStartDate1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCapacityRequirementEventEndDate1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCapacityRequirementEventVenueName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCapacityRequirementEventCustomerName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldRoomName2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldStartTime3 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldEndTime3 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCapacityRequirementCapacity2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.ribbonControl1 = new DevExpress.XtraBars.Ribbon.RibbonControl();
this.printExportItem = new DevExpress.XtraBars.BarButtonItem();
this.ribbonPageCategory1 = new DevExpress.XtraBars.Ribbon.RibbonPageCategory();
this.ribbonPage1 = new DevExpress.XtraBars.Ribbon.RibbonPage();
this.ribbonPageGroup1 = new DevExpress.XtraBars.Ribbon.RibbonPageGroup();
((System.ComponentModel.ISupportInitialize)(this.roomBookingCollection)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.session)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit();
this.splitContainerControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.ribbonControl1)).BeginInit();
this.SuspendLayout();
//
// roomBookingCollection
//
this.roomBookingCollection.ObjectType = typeof(EventsDB.RoomBooking);
this.roomBookingCollection.Session = this.session;
//
// splitContainerControl1
//
this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.splitContainerControl1.FixedPanel = DevExpress.XtraEditors.SplitFixedPanel.Panel2;
this.splitContainerControl1.Horizontal = false;
this.splitContainerControl1.Location = new System.Drawing.Point(0, 150);
this.splitContainerControl1.Name = "splitContainerControl1";
this.splitContainerControl1.Panel1.Controls.Add(this.pivotGridControl1);
this.splitContainerControl1.Panel1.Text = "Panel1";
this.splitContainerControl1.Panel2.Text = "Panel2";
this.splitContainerControl1.Size = new System.Drawing.Size(1000, 550);
this.splitContainerControl1.SplitterPosition = 156;
this.splitContainerControl1.TabIndex = 1;
this.splitContainerControl1.Text = "splitContainerControl1";
//
// pivotGridControl1
//
this.pivotGridControl1.DataSource = this.roomBookingCollection;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldCapacityRequirementName1,
this.fieldCapacityRequirementCapacity1,
this.fieldCapacityRequirementRoomSetup1,
this.fieldCapacityRequirementEventName1,
this.fieldCapacityRequirementEventStartDate1,
this.fieldCapacityRequirementEventEndDate1,
this.fieldCapacityRequirementEventVenueName1,
this.fieldCapacityRequirementEventCustomerName1,
this.fieldRoomName2,
this.fieldStartTime3,
this.fieldEndTime3,
this.fieldCapacityRequirementCapacity2,
this.pivotGridField1,
this.pivotGridField2
});
pivotGridGroup1.Caption = "Event Start";
pivotGridGroup1.Fields.Add(this.pivotGridField2);
pivotGridGroup1.Fields.Add(this.pivotGridField1);
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.MenuManager = this.ribbonControl1;
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007;
this.pivotGridControl1.OptionsData.DataProcessingEngine = DevExpress.XtraPivotGrid.PivotDataProcessingEngine.Optimized;
this.pivotGridControl1.OptionsData.RetrieveNestedFields = DevExpress.Utils.DefaultBoolean.True;
this.pivotGridControl1.OptionsMenu.ShowDateTimeGroupIntervalItems = DevExpress.XtraPivotGrid.DateTimeGroupIntervals.ExtendedIntervals;
this.pivotGridControl1.Size = new System.Drawing.Size(1000, 384);
this.pivotGridControl1.TabIndex = 0;
//
// fieldCapacityRequirementName1
//
this.fieldCapacityRequirementName1.AreaIndex = 3;
this.fieldCapacityRequirementName1.Caption = "CapReq";
dataSourceColumnBinding1.ColumnName = "CapacityRequirement.Name";
this.fieldCapacityRequirementName1.DataBinding = dataSourceColumnBinding1;
this.fieldCapacityRequirementName1.DisplayFolder = "CapacityRequirement";
this.fieldCapacityRequirementName1.FieldName = "CapacityRequirement.Name";
this.fieldCapacityRequirementName1.Name = "fieldCapacityRequirementName1";
this.fieldCapacityRequirementName1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldCapacityRequirementCapacity1
//
this.fieldCapacityRequirementCapacity1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldCapacityRequirementCapacity1.AreaIndex = 1;
this.fieldCapacityRequirementCapacity1.Caption = "Capacity";
this.fieldCapacityRequirementCapacity1.CellFormat.FormatString = "n2";
this.fieldCapacityRequirementCapacity1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
dataSourceColumnBinding2.ColumnName = "CapacityRequirement.Capacity";
this.fieldCapacityRequirementCapacity1.DataBinding = dataSourceColumnBinding2;
this.fieldCapacityRequirementCapacity1.DisplayFolder = "CapacityRequirement";
this.fieldCapacityRequirementCapacity1.FieldName = "CapacityRequirement.Capacity";
this.fieldCapacityRequirementCapacity1.Name = "fieldCapacityRequirementCapacity1";
this.fieldCapacityRequirementCapacity1.Options.AllowRunTimeSummaryChange = true;
this.fieldCapacityRequirementCapacity1.Options.ShowSummaryTypeName = true;
//
// fieldCapacityRequirementRoomSetup1
//
this.fieldCapacityRequirementRoomSetup1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCapacityRequirementRoomSetup1.AreaIndex = 1;
this.fieldCapacityRequirementRoomSetup1.Caption = "Room Setup";
dataSourceColumnBinding3.ColumnName = "CapacityRequirement.RoomSetup";
this.fieldCapacityRequirementRoomSetup1.DataBinding = dataSourceColumnBinding3;
this.fieldCapacityRequirementRoomSetup1.DisplayFolder = "CapacityRequirement";
this.fieldCapacityRequirementRoomSetup1.FieldName = "CapacityRequirement.RoomSetup";
this.fieldCapacityRequirementRoomSetup1.Name = "fieldCapacityRequirementRoomSetup1";
this.fieldCapacityRequirementRoomSetup1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldCapacityRequirementEventName1
//
this.fieldCapacityRequirementEventName1.AreaIndex = 2;
this.fieldCapacityRequirementEventName1.Caption = "Event";
dataSourceColumnBinding4.ColumnName = "CapacityRequirement.Event.Name";
this.fieldCapacityRequirementEventName1.DataBinding = dataSourceColumnBinding4;
this.fieldCapacityRequirementEventName1.DisplayFolder = "CapacityRequirement\\Event";
this.fieldCapacityRequirementEventName1.FieldName = "CapacityRequirement.Event.Name";
this.fieldCapacityRequirementEventName1.Name = "fieldCapacityRequirementEventName1";
this.fieldCapacityRequirementEventName1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldCapacityRequirementEventStartDate1
//
this.fieldCapacityRequirementEventStartDate1.AreaIndex = 4;
this.fieldCapacityRequirementEventStartDate1.Caption = "Event Start";
dataSourceColumnBinding5.ColumnName = "CapacityRequirement.Event.StartDate";
this.fieldCapacityRequirementEventStartDate1.DataBinding = dataSourceColumnBinding5;
this.fieldCapacityRequirementEventStartDate1.DisplayFolder = "CapacityRequirement\\Event";
this.fieldCapacityRequirementEventStartDate1.FieldName = "CapacityRequirement.Event.StartDate";
this.fieldCapacityRequirementEventStartDate1.Name = "fieldCapacityRequirementEventStartDate1";
this.fieldCapacityRequirementEventStartDate1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldCapacityRequirementEventEndDate1
//
this.fieldCapacityRequirementEventEndDate1.AreaIndex = 5;
this.fieldCapacityRequirementEventEndDate1.Caption = "Event End";
dataSourceColumnBinding6.ColumnName = "CapacityRequirement.Event.EndDate";
this.fieldCapacityRequirementEventEndDate1.DataBinding = dataSourceColumnBinding6;
this.fieldCapacityRequirementEventEndDate1.DisplayFolder = "CapacityRequirement\\Event";
this.fieldCapacityRequirementEventEndDate1.FieldName = "CapacityRequirement.Event.EndDate";
this.fieldCapacityRequirementEventEndDate1.Name = "fieldCapacityRequirementEventEndDate1";
this.fieldCapacityRequirementEventEndDate1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldCapacityRequirementEventVenueName1
//
this.fieldCapacityRequirementEventVenueName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCapacityRequirementEventVenueName1.AreaIndex = 0;
this.fieldCapacityRequirementEventVenueName1.Caption = "Venue";
dataSourceColumnBinding7.ColumnName = "CapacityRequirement.Event.Venue.Name";
this.fieldCapacityRequirementEventVenueName1.DataBinding = dataSourceColumnBinding7;
this.fieldCapacityRequirementEventVenueName1.DisplayFolder = "CapacityRequirement\\Event\\Venue";
this.fieldCapacityRequirementEventVenueName1.FieldName = "CapacityRequirement.Event.Venue.Name";
this.fieldCapacityRequirementEventVenueName1.Name = "fieldCapacityRequirementEventVenueName1";
this.fieldCapacityRequirementEventVenueName1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldCapacityRequirementEventCustomerName1
//
this.fieldCapacityRequirementEventCustomerName1.AreaIndex = 6;
this.fieldCapacityRequirementEventCustomerName1.Caption = "Customer";
dataSourceColumnBinding8.ColumnName = "CapacityRequirement.Event.Customer.Name";
this.fieldCapacityRequirementEventCustomerName1.DataBinding = dataSourceColumnBinding8;
this.fieldCapacityRequirementEventCustomerName1.DisplayFolder = "CapacityRequirement\\Event\\Customer";
this.fieldCapacityRequirementEventCustomerName1.FieldName = "CapacityRequirement.Event.Customer.Name";
this.fieldCapacityRequirementEventCustomerName1.Name = "fieldCapacityRequirementEventCustomerName1";
this.fieldCapacityRequirementEventCustomerName1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldRoomName2
//
this.fieldRoomName2.AreaIndex = 7;
this.fieldRoomName2.Caption = "Room";
dataSourceColumnBinding9.ColumnName = "CapacityRequirement.RoomBooking.Room.Name";
this.fieldRoomName2.DataBinding = dataSourceColumnBinding9;
this.fieldRoomName2.DisplayFolder = "Room";
this.fieldRoomName2.FieldName = "Room.Name";
this.fieldRoomName2.Name = "fieldRoomName2";
this.fieldRoomName2.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldStartTime3
//
this.fieldStartTime3.AreaIndex = 0;
this.fieldStartTime3.Caption = "Room Booking Start Time";
dataSourceColumnBinding10.ColumnName = "StartTime";
this.fieldStartTime3.DataBinding = dataSourceColumnBinding10;
this.fieldStartTime3.FieldName = "StartTime";
this.fieldStartTime3.Name = "fieldStartTime3";
this.fieldStartTime3.Options.AllowRunTimeSummaryChange = true;
this.fieldStartTime3.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldEndTime3
//
this.fieldEndTime3.AreaIndex = 1;
this.fieldEndTime3.Caption = "Room Booking End Time";
dataSourceColumnBinding11.ColumnName = "EndTime";
this.fieldEndTime3.DataBinding = dataSourceColumnBinding11;
this.fieldEndTime3.FieldName = "EndTime";
this.fieldEndTime3.Name = "fieldEndTime3";
this.fieldEndTime3.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
//
// fieldCapacityRequirementCapacity2
//
this.fieldCapacityRequirementCapacity2.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldCapacityRequirementCapacity2.AreaIndex = 0;
this.fieldCapacityRequirementCapacity2.Caption = "Capacity";
this.fieldCapacityRequirementCapacity2.CellFormat.FormatString = "n2";
this.fieldCapacityRequirementCapacity2.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
dataSourceColumnBinding12.ColumnName = "CapacityRequirement.Capacity";
this.fieldCapacityRequirementCapacity2.DataBinding = dataSourceColumnBinding12;
this.fieldCapacityRequirementCapacity2.FieldName = "CapacityRequirement.Capacity";
this.fieldCapacityRequirementCapacity2.Name = "fieldCapacityRequirementCapacity2";
this.fieldCapacityRequirementCapacity2.Options.AllowRunTimeSummaryChange = true;
this.fieldCapacityRequirementCapacity2.Options.ShowSummaryTypeName = true;
this.fieldCapacityRequirementCapacity2.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
//
// pivotGridField1
//
this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField1.AreaIndex = 1;
this.pivotGridField1.Caption = "Event Start Month";
dataSourceColumnBinding13.ColumnName = "CapacityRequirement.Event.StartDate";
dataSourceColumnBinding13.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
this.pivotGridField1.DataBinding = dataSourceColumnBinding13;
this.pivotGridField1.Name = "pivotGridField1";
this.pivotGridField1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
this.pivotGridField1.Visible = false;
//
// pivotGridField2
//
this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField2.AreaIndex = 0;
this.pivotGridField2.Caption = "Event Start Year";
dataSourceColumnBinding14.ColumnName = "CapacityRequirement.Event.StartDate";
dataSourceColumnBinding14.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.pivotGridField2.DataBinding = dataSourceColumnBinding14;
this.pivotGridField2.ExpandedInFieldsGroup = false;
this.pivotGridField2.Name = "pivotGridField2";
//
// ribbonControl1
//
this.ribbonControl1.ExpandCollapseItem.Id = 0;
this.ribbonControl1.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
this.ribbonControl1.ExpandCollapseItem,
this.ribbonControl1.SearchEditItem,
this.printExportItem
});
this.ribbonControl1.Location = new System.Drawing.Point(0, 0);
this.ribbonControl1.MaxItemId = 1;
this.ribbonControl1.Name = "ribbonControl1";
this.ribbonControl1.PageCategories.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPageCategory[] {
this.ribbonPageCategory1
});
this.ribbonControl1.Size = new System.Drawing.Size(1000, 150);
//
// printExportItem
//
this.printExportItem.Caption = "Print && Export";
this.printExportItem.Id = 0;
this.printExportItem.ImageOptions.SvgImage = global::sample_5_14.Properties.Resources.printexport;
this.printExportItem.Name = "printExportItem";
//
// ribbonPageCategory1
//
this.ribbonPageCategory1.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0)))));
this.ribbonPageCategory1.Appearance.Options.UseBackColor = true;
this.ribbonPageCategory1.Name = "ribbonPageCategory1";
this.ribbonPageCategory1.Pages.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPage[] {
this.ribbonPage1
});
this.ribbonPageCategory1.Text = "Pivot Overview";
//
// ribbonPage1
//
this.ribbonPage1.Groups.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPageGroup[] {
this.ribbonPageGroup1
});
this.ribbonPage1.Name = "ribbonPage1";
this.ribbonPage1.Text = "Data Operations";
//
// ribbonPageGroup1
//
this.ribbonPageGroup1.ItemLinks.Add(this.printExportItem);
this.ribbonPageGroup1.Name = "ribbonPageGroup1";
this.ribbonPageGroup1.Text = "Tools";
//
// PivotOverview
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.Controls.Add(this.splitContainerControl1);
this.Controls.Add(this.ribbonControl1);
this.Name = "PivotOverview";
this.Size = new System.Drawing.Size(1000, 700);
((System.ComponentModel.ISupportInitialize)(this.roomBookingCollection)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.session)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit();
this.splitContainerControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.ribbonControl1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.btnBegin = new DevExpress.XtraEditors.SimpleButton();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.rbUnlocked = new System.Windows.Forms.RadioButton();
this.rbLocked = new System.Windows.Forms.RadioButton();
this.label3 = new System.Windows.Forms.Label();
this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.pivotGridField1,
this.pivotGridField2,
this.pivotGridField3
});
pivotGridGroup1.Hierarchy = null;
pivotGridGroup2.Hierarchy = null;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1,
pivotGridGroup2
});
this.pivotGridControl1.Location = new System.Drawing.Point(12, 84);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.Size = new System.Drawing.Size(423, 417);
this.pivotGridControl1.TabIndex = 0;
//
// btnBegin
//
this.btnBegin.Location = new System.Drawing.Point(12, 55);
this.btnBegin.Name = "btnBegin";
this.btnBegin.Size = new System.Drawing.Size(75, 23);
this.btnBegin.TabIndex = 1;
this.btnBegin.Text = "Transpose";
this.btnBegin.Click += new System.EventHandler(this.btnBegin_Click);
//
// groupBox1
//
this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.groupBox1.Controls.Add(this.rbUnlocked);
this.groupBox1.Controls.Add(this.rbLocked);
this.groupBox1.Location = new System.Drawing.Point(207, 12);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(228, 66);
this.groupBox1.TabIndex = 2;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "Pivot Grid Locking Options";
//
// rbUnlocked
//
this.rbUnlocked.AutoSize = true;
this.rbUnlocked.Location = new System.Drawing.Point(6, 42);
this.rbUnlocked.Name = "rbUnlocked";
this.rbUnlocked.Size = new System.Drawing.Size(153, 17);
this.rbUnlocked.TabIndex = 1;
this.rbUnlocked.Text = "Do Not Lock the Pivot Grid";
this.rbUnlocked.UseVisualStyleBackColor = true;
//
// rbLocked
//
this.rbLocked.AutoSize = true;
this.rbLocked.Checked = true;
this.rbLocked.Location = new System.Drawing.Point(6, 19);
this.rbLocked.Name = "rbLocked";
this.rbLocked.Size = new System.Drawing.Size(116, 17);
this.rbLocked.TabIndex = 0;
this.rbLocked.TabStop = true;
this.rbLocked.Text = "Lock the Pivot Grid";
this.rbLocked.UseVisualStyleBackColor = true;
//
// label3
//
this.label3.Location = new System.Drawing.Point(12, 12);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(189, 40);
this.label3.TabIndex = 8;
this.label3.Text = "Try transposing the pivot grid with and without locking it, to see the difference" +
" in performance.";
//
// pivotGridField1
//
this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField1.AreaIndex = 0;
this.pivotGridField1.FieldName = "A";
this.pivotGridField1.Name = "pivotGridField1";
//
// pivotGridField2
//
this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField2.AreaIndex = 0;
this.pivotGridField2.FieldName = "B";
this.pivotGridField2.Name = "pivotGridField2";
//
// pivotGridField3
//
this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField3.AreaIndex = 0;
this.pivotGridField3.FieldName = "Data";
this.pivotGridField3.Name = "pivotGridField3";
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(447, 513);
this.Controls.Add(this.label3);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.btnBegin);
this.Controls.Add(this.pivotGridControl1);
this.MinimumSize = new System.Drawing.Size(463, 310);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
DevExpress.DataAccess.Excel.FieldInfo fieldInfo1 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo2 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo3 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo4 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo5 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo6 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo7 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo8 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo9 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo10 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo11 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.FieldInfo fieldInfo12 = new DevExpress.DataAccess.Excel.FieldInfo();
DevExpress.DataAccess.Excel.ExcelWorksheetSettings excelWorksheetSettings1 = new DevExpress.DataAccess.Excel.ExcelWorksheetSettings();
DevExpress.DataAccess.Excel.ExcelSourceOptions excelSourceOptions1 = new DevExpress.DataAccess.Excel.ExcelSourceOptions(excelWorksheetSettings1);
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.excelDataSource1 = new DevExpress.DataAccess.Excel.ExcelDataSource();
this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl();
this.gridControl1 = new DevExpress.XtraGrid.GridControl();
this.gridView1 = new DevExpress.XtraGrid.Views.Grid.GridView();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit();
this.splitContainerControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.DataSource = this.excelDataSource1;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldCategoryName1,
this.fieldProductName1,
this.fieldSalesPerson1,
this.fieldOrderDate1,
this.fieldExtendedPrice1
});
pivotGridGroup1.Caption = "Calendar";
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.Size = new System.Drawing.Size(590, 406);
this.pivotGridControl1.TabIndex = 0;
this.pivotGridControl1.CellDoubleClick += new DevExpress.XtraPivotGrid.PivotCellEventHandler(this.pivotGridControl1_CellDoubleClick);
//
// excelDataSource1
//
this.excelDataSource1.FileName = "C:\\Data\\SalesPerson.xlsx";
this.excelDataSource1.Name = "excelDataSource1";
this.excelDataSource1.ResultSchemaSerializable = resources.GetString("excelDataSource1.ResultSchemaSerializable");
fieldInfo1.Name = "CategoryName";
fieldInfo1.Type = typeof(string);
fieldInfo2.Name = "Country";
fieldInfo2.Type = typeof(string);
fieldInfo3.Name = "FirstName";
fieldInfo3.Type = typeof(string);
fieldInfo4.Name = "LastName";
fieldInfo4.Type = typeof(string);
fieldInfo5.Name = "ProductName";
fieldInfo5.Type = typeof(string);
fieldInfo6.Name = "Sales Person";
fieldInfo6.Type = typeof(string);
fieldInfo7.Name = "OrderDate";
fieldInfo7.Type = typeof(System.DateTime);
fieldInfo8.Name = "OrderID";
fieldInfo8.Type = typeof(double);
fieldInfo9.Name = "Quantity";
fieldInfo9.Type = typeof(double);
fieldInfo10.Name = "Discount";
fieldInfo10.Type = typeof(double);
fieldInfo11.Name = "Extended Price";
fieldInfo11.Type = typeof(double);
fieldInfo12.Name = "UnitPrice";
fieldInfo12.Type = typeof(double);
this.excelDataSource1.Schema.AddRange(new DevExpress.DataAccess.Excel.FieldInfo[] {
fieldInfo1,
fieldInfo2,
fieldInfo3,
fieldInfo4,
fieldInfo5,
fieldInfo6,
fieldInfo7,
fieldInfo8,
fieldInfo9,
fieldInfo10,
fieldInfo11,
fieldInfo12
});
excelWorksheetSettings1.CellRange = null;
excelWorksheetSettings1.WorksheetName = "Data";
excelSourceOptions1.ImportSettings = excelWorksheetSettings1;
this.excelDataSource1.SourceOptions = excelSourceOptions1;
//
// fieldCategoryName1
//
this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCategoryName1.AreaIndex = 0;
this.fieldCategoryName1.Caption = "Category Name";
this.fieldCategoryName1.FieldName = "CategoryName";
this.fieldCategoryName1.Name = "fieldCategoryName1";
//
// fieldProductName1
//
this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldProductName1.AreaIndex = 1;
this.fieldProductName1.Caption = "Product Name";
this.fieldProductName1.FieldName = "ProductName";
this.fieldProductName1.Name = "fieldProductName1";
//
// fieldSalesPerson1
//
this.fieldSalesPerson1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldSalesPerson1.AreaIndex = 1;
this.fieldSalesPerson1.Caption = "Sales Person";
this.fieldSalesPerson1.FieldName = "Sales Person";
this.fieldSalesPerson1.Name = "fieldSalesPerson1";
//
// fieldOrderDate1
//
this.fieldOrderDate1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate1.AreaIndex = 0;
this.fieldOrderDate1.Caption = "OrderDate";
this.fieldOrderDate1.FieldName = "OrderDate";
this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.fieldOrderDate1.Name = "fieldOrderDate1";
this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1";
//
// fieldExtendedPrice1
//
this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldExtendedPrice1.AreaIndex = 0;
this.fieldExtendedPrice1.Caption = "Extended Price";
this.fieldExtendedPrice1.FieldName = "Extended Price";
this.fieldExtendedPrice1.Name = "fieldExtendedPrice1";
//
// pivotGridField1
//
this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField1.AreaIndex = 0;
this.pivotGridField1.Caption = "Year";
this.pivotGridField1.FieldName = "OrderDate";
this.pivotGridField1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.pivotGridField1.Name = "pivotGridField1";
this.pivotGridField1.UnboundFieldName = "fieldOrderDate";
//
// splitContainerControl1
//
this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.splitContainerControl1.Location = new System.Drawing.Point(0, 0);
this.splitContainerControl1.Name = "splitContainerControl1";
this.splitContainerControl1.Panel1.Controls.Add(this.pivotGridControl1);
this.splitContainerControl1.Panel1.Text = "Panel1";
this.splitContainerControl1.Panel2.Controls.Add(this.gridControl1);
this.splitContainerControl1.Panel2.Text = "Panel2";
this.splitContainerControl1.Size = new System.Drawing.Size(887, 406);
this.splitContainerControl1.SplitterPosition = 590;
this.splitContainerControl1.TabIndex = 2;
this.splitContainerControl1.Text = "splitContainerControl1";
//
// gridControl1
//
this.gridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.gridControl1.Location = new System.Drawing.Point(0, 0);
this.gridControl1.MainView = this.gridView1;
this.gridControl1.Name = "gridControl1";
this.gridControl1.Size = new System.Drawing.Size(287, 406);
this.gridControl1.TabIndex = 0;
this.gridControl1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
this.gridView1
});
//
// gridView1
//
this.gridView1.GridControl = this.gridControl1;
this.gridView1.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always;
this.gridView1.Name = "gridView1";
this.gridView1.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.False;
this.gridView1.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.False;
this.gridView1.OptionsBehavior.Editable = false;
this.gridView1.OptionsBehavior.ReadOnly = true;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(887, 406);
this.Controls.Add(this.splitContainerControl1);
this.Name = "Form1";
this.Text = "Double click a cell to display the same level data";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit();
this.splitContainerControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridView1)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.dtspstk01 = new BeSmartMRP.Report.LocalDataSet.DTSPSTK01();
this.fieldCIOTYPE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCLOT = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQCFRWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQCPDGRP = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQCPDTYPE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQCPROD = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQCSECT = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQCSUBCOOR = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQCTOWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQCWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQN2SUBCOOR = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQNFRWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQNPDGRP = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQNPDTYPE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQNPROD = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQNSECT = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQNSUBCOOR = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQNTOWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQNUM = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCQNWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCREFNO = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCSERIALNO = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCWHTYPE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDDATE = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNQTY = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNQTYIN = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNQTYOUT = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldQCWHLOCA = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldQNWHLOCA = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dtspstk01)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.pivotGridControl1.DataMember = "XRPSTMOVE";
this.pivotGridControl1.DataSource = this.dtspstk01;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldCIOTYPE,
this.fieldCLOT,
this.fieldCQCFRWHOUSE,
this.fieldCQCPDGRP,
this.fieldCQCPDTYPE,
this.fieldCQCPROD,
this.fieldCQCSECT,
this.fieldCQCSUBCOOR,
this.fieldCQCTOWHOUSE,
this.fieldCQCWHOUSE,
this.fieldCQN2SUBCOOR,
this.fieldCQNFRWHOUSE,
this.fieldCQNPDGRP,
this.fieldCQNPDTYPE,
this.fieldCQNPROD,
this.fieldCQNSECT,
this.fieldCQNSUBCOOR,
this.fieldCQNTOWHOUSE,
this.fieldCQNUM,
this.fieldCQNWHOUSE,
this.fieldCREFNO,
this.fieldCSERIALNO,
this.fieldCWHTYPE,
this.fieldDDATE,
this.fieldNQTY,
this.fieldNQTYIN,
this.fieldNQTYOUT,
this.fieldQCWHLOCA,
this.fieldQNWHLOCA
});
pivotGridGroup1.Fields.Add(this.fieldCQCPROD);
pivotGridGroup1.Fields.Add(this.fieldCQNPROD);
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(12, 61);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.Size = new System.Drawing.Size(741, 281);
this.pivotGridControl1.TabIndex = 0;
//
// dtspstk01
//
this.dtspstk01.DataSetName = "DTSPSTK01";
this.dtspstk01.Locale = new System.Globalization.CultureInfo("en-US");
this.dtspstk01.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// fieldCIOTYPE
//
this.fieldCIOTYPE.AreaIndex = 28;
this.fieldCIOTYPE.Caption = "IO";
this.fieldCIOTYPE.FieldName = "CIOTYPE";
this.fieldCIOTYPE.Name = "fieldCIOTYPE";
//
// fieldCLOT
//
this.fieldCLOT.AreaIndex = 0;
this.fieldCLOT.Caption = "Lot";
this.fieldCLOT.FieldName = "CLOT";
this.fieldCLOT.Name = "fieldCLOT";
//
// fieldCQCFRWHOUSE
//
this.fieldCQCFRWHOUSE.AreaIndex = 1;
this.fieldCQCFRWHOUSE.Caption = "รหัสคลังสินค้าต้นทาง";
this.fieldCQCFRWHOUSE.FieldName = "CQCFRWHOUSE";
this.fieldCQCFRWHOUSE.Name = "fieldCQCFRWHOUSE";
//
// fieldCQCPDGRP
//
this.fieldCQCPDGRP.AreaIndex = 2;
this.fieldCQCPDGRP.Caption = "รหัสกลุ่มสินค้า";
this.fieldCQCPDGRP.FieldName = "CQCPDGRP";
this.fieldCQCPDGRP.Name = "fieldCQCPDGRP";
//
// fieldCQCPDTYPE
//
this.fieldCQCPDTYPE.AreaIndex = 3;
this.fieldCQCPDTYPE.Caption = "รหัสชนิดสินค้า";
this.fieldCQCPDTYPE.FieldName = "CQCPDTYPE";
this.fieldCQCPDTYPE.Name = "fieldCQCPDTYPE";
//
// fieldCQCPROD
//
this.fieldCQCPROD.AreaIndex = 4;
this.fieldCQCPROD.Caption = "รหัสสินค้า";
this.fieldCQCPROD.FieldName = "CQCPROD";
this.fieldCQCPROD.Name = "fieldCQCPROD";
//
// fieldCQCSECT
//
this.fieldCQCSECT.AreaIndex = 6;
this.fieldCQCSECT.Caption = "รหัสแผนก";
this.fieldCQCSECT.FieldName = "CQCSECT";
this.fieldCQCSECT.Name = "fieldCQCSECT";
//
// fieldCQCSUBCOOR
//
this.fieldCQCSUBCOOR.AreaIndex = 7;
this.fieldCQCSUBCOOR.FieldName = "CQCSUBCOOR";
this.fieldCQCSUBCOOR.Name = "fieldCQCSUBCOOR";
//
// fieldCQCTOWHOUSE
//
this.fieldCQCTOWHOUSE.AreaIndex = 8;
this.fieldCQCTOWHOUSE.Caption = "รหัสคลังปลายทาง";
this.fieldCQCTOWHOUSE.FieldName = "CQCTOWHOUSE";
this.fieldCQCTOWHOUSE.Name = "fieldCQCTOWHOUSE";
//
// fieldCQCWHOUSE
//
this.fieldCQCWHOUSE.AreaIndex = 9;
this.fieldCQCWHOUSE.Caption = "รหัสคลังสินค้า";
this.fieldCQCWHOUSE.FieldName = "CQCWHOUSE";
this.fieldCQCWHOUSE.Name = "fieldCQCWHOUSE";
//
// fieldCQN2SUBCOOR
//
this.fieldCQN2SUBCOOR.AreaIndex = 10;
this.fieldCQN2SUBCOOR.FieldName = "CQN2SUBCOOR";
this.fieldCQN2SUBCOOR.Name = "fieldCQN2SUBCOOR";
//
// fieldCQNFRWHOUSE
//
this.fieldCQNFRWHOUSE.AreaIndex = 11;
this.fieldCQNFRWHOUSE.Caption = "ชื่อคลังสินค้าต้นทาง";
this.fieldCQNFRWHOUSE.FieldName = "CQNFRWHOUSE";
this.fieldCQNFRWHOUSE.Name = "fieldCQNFRWHOUSE";
//
// fieldCQNPDGRP
//
this.fieldCQNPDGRP.AreaIndex = 12;
this.fieldCQNPDGRP.Caption = "ชื่อกลุ่มสินค้า";
this.fieldCQNPDGRP.FieldName = "CQNPDGRP";
this.fieldCQNPDGRP.Name = "fieldCQNPDGRP";
//
// fieldCQNPDTYPE
//
this.fieldCQNPDTYPE.AreaIndex = 13;
this.fieldCQNPDTYPE.Caption = "ชื่อประเภทสินค้า";
this.fieldCQNPDTYPE.FieldName = "CQNPDTYPE";
this.fieldCQNPDTYPE.Name = "fieldCQNPDTYPE";
//
// fieldCQNPROD
//
this.fieldCQNPROD.AreaIndex = 5;
this.fieldCQNPROD.Caption = "ชื่อสินค้า";
this.fieldCQNPROD.FieldName = "CQNPROD";
this.fieldCQNPROD.Name = "fieldCQNPROD";
//
// fieldCQNSECT
//
this.fieldCQNSECT.AreaIndex = 14;
this.fieldCQNSECT.Caption = "ชื่อแผนก";
this.fieldCQNSECT.FieldName = "CQNSECT";
this.fieldCQNSECT.Name = "fieldCQNSECT";
//
// fieldCQNSUBCOOR
//
this.fieldCQNSUBCOOR.AreaIndex = 15;
this.fieldCQNSUBCOOR.FieldName = "CQNSUBCOOR";
this.fieldCQNSUBCOOR.Name = "fieldCQNSUBCOOR";
//
// fieldCQNTOWHOUSE
//
this.fieldCQNTOWHOUSE.AreaIndex = 16;
this.fieldCQNTOWHOUSE.Caption = "ชื่อคลังสินค้าปลายทาง";
this.fieldCQNTOWHOUSE.FieldName = "CQNTOWHOUSE";
this.fieldCQNTOWHOUSE.Name = "fieldCQNTOWHOUSE";
//
// fieldCQNUM
//
this.fieldCQNUM.AreaIndex = 17;
this.fieldCQNUM.Caption = "ชื่อหน่วยนับ";
this.fieldCQNUM.FieldName = "CQNUM";
this.fieldCQNUM.Name = "fieldCQNUM";
//
// fieldCQNWHOUSE
//
this.fieldCQNWHOUSE.AreaIndex = 18;
this.fieldCQNWHOUSE.Caption = "ชื่อคลังสินค้า";
this.fieldCQNWHOUSE.FieldName = "CQNWHOUSE";
this.fieldCQNWHOUSE.Name = "fieldCQNWHOUSE";
//
// fieldCREFNO
//
this.fieldCREFNO.AreaIndex = 19;
this.fieldCREFNO.Caption = "เลขที่อ้างอิง";
this.fieldCREFNO.FieldName = "CREFNO";
this.fieldCREFNO.Name = "fieldCREFNO";
//
// fieldCSERIALNO
//
this.fieldCSERIALNO.AreaIndex = 20;
this.fieldCSERIALNO.Caption = "SERIAL NO.";
this.fieldCSERIALNO.FieldName = "CSERIALNO";
this.fieldCSERIALNO.Name = "fieldCSERIALNO";
//
// fieldCWHTYPE
//
this.fieldCWHTYPE.AreaIndex = 21;
this.fieldCWHTYPE.Caption = "ประเภทคลังสินค้า";
this.fieldCWHTYPE.FieldName = "CWHTYPE";
this.fieldCWHTYPE.Name = "fieldCWHTYPE";
//
// fieldDDATE
//
this.fieldDDATE.AreaIndex = 22;
this.fieldDDATE.Caption = "วันที่เอกสาร";
this.fieldDDATE.FieldName = "DDATE";
this.fieldDDATE.Name = "fieldDDATE";
//
// fieldNQTY
//
this.fieldNQTY.AreaIndex = 23;
this.fieldNQTY.Caption = "จำนวน";
this.fieldNQTY.FieldName = "NQTY";
this.fieldNQTY.Name = "fieldNQTY";
//
// fieldNQTYIN
//
this.fieldNQTYIN.AreaIndex = 24;
this.fieldNQTYIN.Caption = "จำนวน รับ";
this.fieldNQTYIN.FieldName = "NQTY_IN";
this.fieldNQTYIN.Name = "fieldNQTYIN";
//
// fieldNQTYOUT
//
this.fieldNQTYOUT.AreaIndex = 25;
this.fieldNQTYOUT.Caption = "จำนวนจ่าย";
this.fieldNQTYOUT.FieldName = "NQTY_OUT";
this.fieldNQTYOUT.Name = "fieldNQTYOUT";
//
// fieldQCWHLOCA
//
this.fieldQCWHLOCA.AreaIndex = 26;
this.fieldQCWHLOCA.Caption = "รหัสที่เก็บสินค้า";
this.fieldQCWHLOCA.FieldName = "QCWHLOCA";
this.fieldQCWHLOCA.Name = "fieldQCWHLOCA";
//
// fieldQNWHLOCA
//
this.fieldQNWHLOCA.AreaIndex = 27;
this.fieldQNWHLOCA.Caption = "ชื่อที่เก็บสินค้า";
this.fieldQNWHLOCA.FieldName = "QNWHLOCA";
this.fieldQNWHLOCA.Name = "fieldQNWHLOCA";
//
// frmStockQuery1
//
this.Appearance.BackColor = System.Drawing.Color.SkyBlue;
this.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
this.Appearance.Options.UseBackColor = true;
this.Appearance.Options.UseFont = true;
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(765, 370);
this.Controls.Add(this.pivotGridControl1);
this.Name = "frmStockQuery1";
this.Text = "STOCK INQUIRY";
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dtspstk01)).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.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.salesPersonBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.nwindDataSet = new GroupFilter.nwindDataSet();
this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.salesPersonTableAdapter = new GroupFilter.nwindDataSetTableAdapters.SalesPersonTableAdapter();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.salesPersonBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit();
this.SuspendLayout();
//
// fieldOrderDate1
//
this.fieldOrderDate1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldOrderDate1.AreaIndex = 0;
this.fieldOrderDate1.Caption = "Year";
this.fieldOrderDate1.FieldName = "OrderDate";
this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.fieldOrderDate1.Name = "fieldOrderDate1";
this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1";
//
// fieldOrderDate
//
this.fieldOrderDate.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldOrderDate.AreaIndex = 1;
this.fieldOrderDate.Caption = "Month";
this.fieldOrderDate.FieldName = "OrderDate";
this.fieldOrderDate.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
this.fieldOrderDate.Name = "fieldOrderDate";
this.fieldOrderDate.UnboundFieldName = "fieldOrderDate";
//
// pivotGridControl1
//
this.pivotGridControl1.DataSource = this.salesPersonBindingSource;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldProductName1,
this.fieldExtendedPrice1,
this.fieldCategoryName1,
this.fieldOrderDate1,
this.fieldOrderDate
});
pivotGridGroup1.Caption = "OrderDateGroup";
pivotGridGroup1.Fields.Add(this.fieldOrderDate1);
pivotGridGroup1.Fields.Add(this.fieldOrderDate);
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.LookAndFeel.SkinName = "Office 2010 Silver";
this.pivotGridControl1.LookAndFeel.UseDefaultLookAndFeel = false;
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.Size = new System.Drawing.Size(598, 310);
this.pivotGridControl1.TabIndex = 0;
//
// salesPersonBindingSource
//
this.salesPersonBindingSource.DataMember = "SalesPerson";
this.salesPersonBindingSource.DataSource = this.nwindDataSet;
//
// nwindDataSet
//
this.nwindDataSet.DataSetName = "nwindDataSet";
this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// fieldProductName1
//
this.fieldProductName1.AreaIndex = 0;
this.fieldProductName1.Caption = "Product Name";
this.fieldProductName1.FieldName = "ProductName";
this.fieldProductName1.Name = "fieldProductName1";
//
// fieldExtendedPrice1
//
this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldExtendedPrice1.AreaIndex = 0;
this.fieldExtendedPrice1.Caption = "Extended Price";
this.fieldExtendedPrice1.FieldName = "Extended Price";
this.fieldExtendedPrice1.Name = "fieldExtendedPrice1";
//
// fieldCategoryName1
//
this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldCategoryName1.AreaIndex = 0;
this.fieldCategoryName1.Caption = "Category Name";
this.fieldCategoryName1.FieldName = "CategoryName";
this.fieldCategoryName1.Name = "fieldCategoryName1";
//
// salesPersonTableAdapter
//
this.salesPersonTableAdapter.ClearBeforeFill = true;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(598, 310);
this.Controls.Add(this.pivotGridControl1);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.salesPersonBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.fieldCategory = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProduct = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSubcategory = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTotalProductCost = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCalendarYear = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSalesTerritoryCountry = new DevExpress.XtraPivotGrid.PivotGridField();
this.button1 = new System.Windows.Forms.Button();
this.fieldSalesAmount = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldCategory,
this.fieldProduct,
this.fieldSubcategory,
this.fieldTotalProductCost,
this.fieldCalendarYear,
this.fieldSalesTerritoryCountry,
this.fieldSalesAmount
});
pivotGridGroup1.Caption = "Product Categories";
pivotGridGroup1.Fields.Add(this.fieldCategory);
pivotGridGroup1.Fields.Add(this.fieldSubcategory);
pivotGridGroup1.Fields.Add(this.fieldProduct);
pivotGridGroup1.Hierarchy = "[Product].[Product Categories]";
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OLAPConnectionString = "provider=MSOLAP;data source=local;initial catalog=\"Adventure Works DW Standard Ed" +
"ition\";cube name=\"Adventure Works\"";
this.pivotGridControl1.Size = new System.Drawing.Size(648, 386);
this.pivotGridControl1.TabIndex = 0;
//
// fieldCategory
//
this.fieldCategory.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCategory.AreaIndex = 0;
this.fieldCategory.Caption = "Category";
this.fieldCategory.FieldName = "[Product].[Product Categories].[Category]";
this.fieldCategory.Name = "fieldCategory";
//
// fieldProduct
//
this.fieldProduct.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldProduct.AreaIndex = 2;
this.fieldProduct.Caption = "Product";
this.fieldProduct.FieldName = "[Product].[Product Categories].[Product]";
this.fieldProduct.Name = "fieldProduct";
//
// fieldSubcategory
//
this.fieldSubcategory.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldSubcategory.AreaIndex = 1;
this.fieldSubcategory.Caption = "Subcategory";
this.fieldSubcategory.FieldName = "[Product].[Product Categories].[Subcategory]";
this.fieldSubcategory.Name = "fieldSubcategory";
//
// fieldTotalProductCost
//
this.fieldTotalProductCost.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTotalProductCost.AreaIndex = 0;
this.fieldTotalProductCost.Caption = "Total Product Cost";
this.fieldTotalProductCost.CellFormat.FormatString = "c";
this.fieldTotalProductCost.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldTotalProductCost.FieldName = "[Measures].[Total Product Cost]";
this.fieldTotalProductCost.Name = "fieldTotalProductCost";
//
// fieldCalendarYear
//
this.fieldCalendarYear.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldCalendarYear.AreaIndex = 0;
this.fieldCalendarYear.Caption = "Calendar Year";
this.fieldCalendarYear.FieldName = "[Date].[Calendar Year].[Calendar Year]";
this.fieldCalendarYear.Name = "fieldCalendarYear";
//
// fieldSalesTerritoryCountry
//
this.fieldSalesTerritoryCountry.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldSalesTerritoryCountry.AreaIndex = 1;
this.fieldSalesTerritoryCountry.Caption = "Sales Territory Country";
this.fieldSalesTerritoryCountry.FieldName = "[Sales Territory].[Sales Territory Country].[Sales Territory Country]";
this.fieldSalesTerritoryCountry.Name = "fieldSalesTerritoryCountry";
//
// button1
//
this.button1.Location = new System.Drawing.Point(536, 0);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(112, 23);
this.button1.TabIndex = 1;
this.button1.Text = "Query Server";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// fieldSalesAmount
//
this.fieldSalesAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldSalesAmount.AreaIndex = 1;
this.fieldSalesAmount.Caption = "Sales Amount";
this.fieldSalesAmount.CellFormat.FormatString = "c";
this.fieldSalesAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldSalesAmount.FieldName = "[Measures].[Sales Amount]";
this.fieldSalesAmount.Name = "fieldSalesAmount";
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(648, 386);
this.Controls.Add(this.button1);
this.Controls.Add(this.pivotGridControl1);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).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.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(xFrmUrunRapor));
this.fieldFiyat1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTutar = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldKarOran = new DevExpress.XtraPivotGrid.PivotGridField();
this.urunlerPivotGridControl = new DevExpress.XtraPivotGrid.PivotGridControl();
this.urunRaporBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.fieldFirmaKod1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldUrunAdi1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldKategoriAdi1 = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.urunlerPivotGridControl)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.urunRaporBindingSource)).BeginInit();
this.SuspendLayout();
//
// fieldFiyat1
//
this.fieldFiyat1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea)));
this.fieldFiyat1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldFiyat1.AreaIndex = 0;
this.fieldFiyat1.Caption = "Alış Fiyatı";
this.fieldFiyat1.CellFormat.FormatString = "###,###,##0.00";
this.fieldFiyat1.CellFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.fieldFiyat1.FieldName = "Fiyat";
this.fieldFiyat1.Name = "fieldFiyat1";
this.fieldFiyat1.Options.AllowEdit = false;
this.fieldFiyat1.Options.ShowCustomTotals = false;
this.fieldFiyat1.Options.ShowGrandTotal = false;
this.fieldFiyat1.Options.ShowTotals = false;
this.fieldFiyat1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
this.fieldFiyat1.Width = 65;
//
// fieldTutar
//
this.fieldTutar.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
this.fieldTutar.Appearance.Cell.Options.UseFont = true;
this.fieldTutar.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTutar.AreaIndex = 1;
this.fieldTutar.Caption = "Satış Fiyatı";
this.fieldTutar.CellFormat.FormatString = "###,###,##0.00";
this.fieldTutar.CellFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.fieldTutar.FieldName = "Tutar";
this.fieldTutar.Name = "fieldTutar";
this.fieldTutar.Width = 65;
//
// fieldKarOran
//
this.fieldKarOran.AreaIndex = 0;
this.fieldKarOran.FieldName = "KarOran";
this.fieldKarOran.Name = "fieldKarOran";
this.fieldKarOran.Visible = false;
//
// urunlerPivotGridControl
//
this.urunlerPivotGridControl.Appearance.ColumnHeaderArea.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
this.urunlerPivotGridControl.Appearance.ColumnHeaderArea.Options.UseFont = true;
this.urunlerPivotGridControl.DataSource = this.urunRaporBindingSource;
this.urunlerPivotGridControl.Dock = System.Windows.Forms.DockStyle.Fill;
this.urunlerPivotGridControl.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldFiyat1,
this.fieldKarOran,
this.fieldTutar,
this.fieldFirmaKod1,
this.fieldUrunAdi1,
this.fieldKategoriAdi1
});
pivotGridGroup1.Caption = "Fiyatlar";
pivotGridGroup1.Fields.Add(this.fieldFiyat1);
pivotGridGroup1.Fields.Add(this.fieldTutar);
pivotGridGroup1.Hierarchy = null;
this.urunlerPivotGridControl.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.urunlerPivotGridControl.Location = new System.Drawing.Point(0, 0);
this.urunlerPivotGridControl.Name = "urunlerPivotGridControl";
this.urunlerPivotGridControl.OptionsView.ShowColumnGrandTotalHeader = false;
this.urunlerPivotGridControl.OptionsView.ShowColumnGrandTotals = false;
this.urunlerPivotGridControl.OptionsView.ShowColumnHeaders = false;
this.urunlerPivotGridControl.OptionsView.ShowColumnTotals = false;
this.urunlerPivotGridControl.OptionsView.ShowDataHeaders = false;
this.urunlerPivotGridControl.OptionsView.ShowFilterHeaders = false;
this.urunlerPivotGridControl.OptionsView.ShowFilterSeparatorBar = false;
this.urunlerPivotGridControl.OptionsView.ShowRowGrandTotalHeader = false;
this.urunlerPivotGridControl.OptionsView.ShowRowGrandTotals = false;
this.urunlerPivotGridControl.OptionsView.ShowRowHeaders = false;
this.urunlerPivotGridControl.OptionsView.ShowRowTotals = false;
this.urunlerPivotGridControl.Size = new System.Drawing.Size(641, 360);
this.urunlerPivotGridControl.TabIndex = 0;
//
// urunRaporBindingSource
//
this.urunRaporBindingSource.DataSource = typeof(EasySupply.UrunRapor);
//
// fieldFirmaKod1
//
this.fieldFirmaKod1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldFirmaKod1.AreaIndex = 0;
this.fieldFirmaKod1.Caption = "Firma Kod";
this.fieldFirmaKod1.FieldName = "FirmaKod";
this.fieldFirmaKod1.Name = "fieldFirmaKod1";
//
// fieldUrunAdi1
//
this.fieldUrunAdi1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldUrunAdi1.AreaIndex = 1;
this.fieldUrunAdi1.Caption = "Urun Adi";
this.fieldUrunAdi1.FieldName = "UrunAdi";
this.fieldUrunAdi1.Name = "fieldUrunAdi1";
this.fieldUrunAdi1.Options.AllowEdit = false;
this.fieldUrunAdi1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
this.fieldUrunAdi1.Width = 275;
//
// fieldKategoriAdi1
//
this.fieldKategoriAdi1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldKategoriAdi1.AreaIndex = 0;
this.fieldKategoriAdi1.Caption = "Kategori Adi";
this.fieldKategoriAdi1.FieldName = "KategoriAdi";
this.fieldKategoriAdi1.Name = "fieldKategoriAdi1";
this.fieldKategoriAdi1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
this.fieldKategoriAdi1.Width = 20;
//
// xFrmUrunRapor
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(641, 360);
this.Controls.Add(this.urunlerPivotGridControl);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.Name = "xFrmUrunRapor";
this.Text = "Ürün Raporu";
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.xFrmUrunRapor_FormClosing);
this.Load += new System.EventHandler(this.xFrmUrunRapor_Load);
((System.ComponentModel.ISupportInitialize)(this.urunlerPivotGridControl)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.urunRaporBindingSource)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.fieldInternetSalesAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCountry = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldYear = new DevExpress.XtraPivotGrid.PivotGridField();
this.repositoryItemProgressBar1 = new DevExpress.XtraEditors.Repository.RepositoryItemProgressBar();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemProgressBar1)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldInternetSalesAmount,
this.fieldCountry,
this.fieldYear
});
pivotGridGroup1.Caption = "Year - Month";
pivotGridGroup1.Hierarchy = null;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(12, 12);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemProgressBar1
});
this.pivotGridControl1.Size = new System.Drawing.Size(651, 281);
this.pivotGridControl1.TabIndex = 0;
//
// fieldInternetSalesAmount
//
this.fieldInternetSalesAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldInternetSalesAmount.AreaIndex = 0;
this.fieldInternetSalesAmount.Caption = "Sales";
this.fieldInternetSalesAmount.FieldName = "[Measures].[Internet Sales Amount]";
this.fieldInternetSalesAmount.Name = "fieldInternetSalesAmount";
//
// fieldCountry
//
this.fieldCountry.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCountry.AreaIndex = 0;
this.fieldCountry.Caption = "Country";
this.fieldCountry.FieldName = "[Customer].[Country].[Country]";
this.fieldCountry.Name = "fieldCountry";
//
// fieldYear
//
this.fieldYear.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldYear.AreaIndex = 0;
this.fieldYear.Caption = "Year";
this.fieldYear.FieldName = "[Date].[Fiscal].[Fiscal Year]";
this.fieldYear.Name = "fieldYear";
//
// repositoryItemProgressBar1
//
this.repositoryItemProgressBar1.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
this.repositoryItemProgressBar1.DisplayFormat.FormatString = "{0}%";
this.repositoryItemProgressBar1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.repositoryItemProgressBar1.Name = "repositoryItemProgressBar1";
this.repositoryItemProgressBar1.ShowTitle = true;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(675, 305);
this.Controls.Add(this.pivotGridControl1);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemProgressBar1)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.fieldYear = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldQuarter = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldMonth = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.fieldProductName = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductSales = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCategoryName = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.SuspendLayout();
//
// fieldYear
//
this.fieldYear.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldYear.AreaIndex = 0;
this.fieldYear.Caption = "Year";
this.fieldYear.FieldName = "ShippedDate";
this.fieldYear.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.fieldYear.Name = "fieldYear";
this.fieldYear.UnboundFieldName = "fieldYear";
//
// fieldQuarter
//
this.fieldQuarter.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldQuarter.AreaIndex = 1;
this.fieldQuarter.Caption = "Quarter";
this.fieldQuarter.FieldName = "ShippedDate";
this.fieldQuarter.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter;
this.fieldQuarter.Name = "fieldQuarter";
this.fieldQuarter.UnboundFieldName = "fieldQuarter";
//
// fieldMonth
//
this.fieldMonth.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldMonth.AreaIndex = 2;
this.fieldMonth.Caption = "Month";
this.fieldMonth.FieldName = "ShippedDate";
this.fieldMonth.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
this.fieldMonth.Name = "fieldMonth";
this.fieldMonth.UnboundFieldName = "fieldMonth";
//
// pivotGridControl1
//
this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldYear,
this.fieldProductName,
this.fieldProductSales,
this.fieldCategoryName,
this.fieldQuarter,
this.fieldMonth
});
pivotGridGroup1.Fields.Add(this.fieldYear);
pivotGridGroup1.Fields.Add(this.fieldQuarter);
pivotGridGroup1.Fields.Add(this.fieldMonth);
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
pivotGridGroup2.Caption = "Category - Product";
pivotGridGroup2.Fields.Add(this.fieldCategoryName);
pivotGridGroup2.Fields.Add(this.fieldProductName);
pivotGridGroup2.Hierarchy = null;
pivotGridGroup2.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1,
pivotGridGroup2
});
this.pivotGridControl1.Location = new System.Drawing.Point(12, 12);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.Size = new System.Drawing.Size(726, 452);
this.pivotGridControl1.TabIndex = 0;
this.pivotGridControl1.CustomCellValue += new System.EventHandler <DevExpress.XtraPivotGrid.PivotCellValueEventArgs>(this.pivotGridControl1_CustomCellValue);
//
// fieldProductName
//
this.fieldProductName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldProductName.AreaIndex = 1;
this.fieldProductName.Caption = "Product Name";
this.fieldProductName.FieldName = "ProductName";
this.fieldProductName.Name = "fieldProductName";
//
// fieldProductSales
//
this.fieldProductSales.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldProductSales.AreaIndex = 0;
this.fieldProductSales.Caption = "Sales";
this.fieldProductSales.FieldName = "ProductSales";
this.fieldProductSales.Name = "fieldProductSales";
//
// fieldCategoryName
//
this.fieldCategoryName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCategoryName.AreaIndex = 0;
this.fieldCategoryName.Caption = "Category Name";
this.fieldCategoryName.FieldName = "CategoryName";
this.fieldCategoryName.Name = "fieldCategoryName";
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(750, 476);
this.Controls.Add(this.pivotGridControl1);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.Col_Grupo = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.Col_pe_cedulaRuc = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_pe_nombre = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Cargo = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_em_status = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Orden = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Valor = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_rubro = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_pe_FechaIni = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Centro_costo = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_FechaInicio = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Antiguedad = new DevExpress.XtraPivotGrid.PivotGridField();
this.Col_Af_DescripcionCorta = new DevExpress.XtraPivotGrid.PivotGridField();
this.ucRo_Menu = new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.SuspendLayout();
//
// Col_Grupo
//
this.Col_Grupo.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.Col_Grupo.AreaIndex = 0;
this.Col_Grupo.Caption = "Grupo";
this.Col_Grupo.FieldName = "Grupo";
this.Col_Grupo.Name = "Col_Grupo";
//
// pivotGridControl1
//
this.pivotGridControl1.Appearance.FieldHeader.BackColor = System.Drawing.Color.White;
this.pivotGridControl1.Appearance.FieldHeader.BackColor2 = System.Drawing.Color.White;
this.pivotGridControl1.Appearance.FieldHeader.ForeColor = System.Drawing.Color.Red;
this.pivotGridControl1.Appearance.FieldHeader.Options.UseBackColor = true;
this.pivotGridControl1.Appearance.FieldHeader.Options.UseForeColor = true;
this.pivotGridControl1.Appearance.FieldValue.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0)))));
this.pivotGridControl1.Appearance.FieldValue.Options.UseForeColor = true;
this.pivotGridControl1.Appearance.FieldValueTotal.ForeColor = System.Drawing.Color.Black;
this.pivotGridControl1.Appearance.FieldValueTotal.Options.UseForeColor = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor = System.Drawing.Color.Black;
this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor2 = System.Drawing.Color.White;
this.pivotGridControl1.AppearancePrint.FieldHeader.ForeColor = System.Drawing.Color.Red;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBackColor = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBorderColor = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseFont = true;
this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseForeColor = true;
this.pivotGridControl1.AppearancePrint.FieldValue.BackColor = System.Drawing.Color.Transparent;
this.pivotGridControl1.AppearancePrint.FieldValue.BackColor2 = System.Drawing.Color.Transparent;
this.pivotGridControl1.AppearancePrint.FieldValue.ForeColor = System.Drawing.Color.Black;
this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseBackColor = true;
this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseForeColor = true;
this.pivotGridControl1.AppearancePrint.FieldValueTotal.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(255)))));
this.pivotGridControl1.AppearancePrint.FieldValueTotal.Options.UseForeColor = true;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.Col_pe_cedulaRuc,
this.Col_pe_nombre,
this.Col_Cargo,
this.Col_em_status,
this.Col_Orden,
this.Col_Valor,
this.Col_rubro,
this.Col_pe_FechaIni,
this.Col_Grupo,
this.Col_Centro_costo,
this.Col_FechaInicio,
this.Col_Antiguedad,
this.Col_Af_DescripcionCorta
});
pivotGridGroup1.Caption = "Grupos";
pivotGridGroup1.Fields.Add(this.Col_Grupo);
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 74);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OptionsBehavior.HorizontalScrolling = DevExpress.XtraPivotGrid.PivotGridScrolling.Control;
this.pivotGridControl1.OptionsPrint.MergeRowFieldValues = false;
this.pivotGridControl1.OptionsPrint.PrintHeadersOnEveryPage = true;
this.pivotGridControl1.OptionsPrint.PrintUnusedFilterFields = false;
this.pivotGridControl1.OptionsPrint.UsePrintAppearance = true;
this.pivotGridControl1.OptionsView.ShowColumnGrandTotalHeader = false;
this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = false;
this.pivotGridControl1.OptionsView.ShowColumnTotals = false;
this.pivotGridControl1.OptionsView.ShowRowGrandTotalHeader = false;
this.pivotGridControl1.OptionsView.ShowRowGrandTotals = false;
this.pivotGridControl1.OptionsView.ShowRowTotals = false;
this.pivotGridControl1.Size = new System.Drawing.Size(1284, 417);
this.pivotGridControl1.TabIndex = 149;
this.pivotGridControl1.Click += new System.EventHandler(this.pivotGridControl1_Click);
//
// Col_pe_cedulaRuc
//
this.Col_pe_cedulaRuc.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_pe_cedulaRuc.AreaIndex = 0;
this.Col_pe_cedulaRuc.Caption = "Cedula";
this.Col_pe_cedulaRuc.FieldName = "pe_cedulaRuc";
this.Col_pe_cedulaRuc.Name = "Col_pe_cedulaRuc";
this.Col_pe_cedulaRuc.Options.ReadOnly = true;
this.Col_pe_cedulaRuc.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Min;
//
// Col_pe_nombre
//
this.Col_pe_nombre.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_pe_nombre.AreaIndex = 1;
this.Col_pe_nombre.Caption = "Empleado";
this.Col_pe_nombre.FieldName = "pe_apellido";
this.Col_pe_nombre.Name = "Col_pe_nombre";
this.Col_pe_nombre.Options.ReadOnly = true;
//
// Col_Cargo
//
this.Col_Cargo.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_Cargo.AreaIndex = 2;
this.Col_Cargo.Caption = "Cargo";
this.Col_Cargo.FieldName = "ca_descripcion";
this.Col_Cargo.Name = "Col_Cargo";
this.Col_Cargo.Options.ReadOnly = true;
//
// Col_em_status
//
this.Col_em_status.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_em_status.AreaIndex = 7;
this.Col_em_status.Caption = "Fecha Salida";
this.Col_em_status.FieldName = "EstadoEmpleado";
this.Col_em_status.Name = "Col_em_status";
//
// Col_Orden
//
this.Col_Orden.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.Col_Orden.AreaIndex = 1;
this.Col_Orden.Caption = "Orden";
this.Col_Orden.FieldName = "Orden";
this.Col_Orden.Name = "Col_Orden";
//
// Col_Valor
//
this.Col_Valor.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.Col_Valor.AreaIndex = 0;
this.Col_Valor.Caption = "Valor";
this.Col_Valor.FieldName = "Valor";
this.Col_Valor.Name = "Col_Valor";
//
// Col_rubro
//
this.Col_rubro.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.Col_rubro.AreaIndex = 2;
this.Col_rubro.Caption = "Rubro";
this.Col_rubro.FieldName = "Descripcion";
this.Col_rubro.Name = "Col_rubro";
//
// Col_pe_FechaIni
//
this.Col_pe_FechaIni.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_pe_FechaIni.AreaIndex = 6;
this.Col_pe_FechaIni.Caption = "Fecha Mes";
this.Col_pe_FechaIni.CellFormat.FormatString = "{0:d}";
this.Col_pe_FechaIni.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.Col_pe_FechaIni.FieldName = "pe_FechaIni";
this.Col_pe_FechaIni.Name = "Col_pe_FechaIni";
//
// Col_Centro_costo
//
this.Col_Centro_costo.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_Centro_costo.AreaIndex = 3;
this.Col_Centro_costo.Caption = "Ubicacion";
this.Col_Centro_costo.FieldName = "Centro_costo";
this.Col_Centro_costo.Name = "Col_Centro_costo";
this.Col_Centro_costo.SortOrder = DevExpress.XtraPivotGrid.PivotSortOrder.Descending;
//
// Col_FechaInicio
//
this.Col_FechaInicio.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_FechaInicio.AreaIndex = 5;
this.Col_FechaInicio.Caption = "Fecha Ingreso";
this.Col_FechaInicio.FieldName = "FechaInicio";
this.Col_FechaInicio.Name = "Col_FechaInicio";
//
// Col_Antiguedad
//
this.Col_Antiguedad.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_Antiguedad.AreaIndex = 8;
this.Col_Antiguedad.Caption = "Antiguedad";
this.Col_Antiguedad.FieldName = "Antiguedad";
this.Col_Antiguedad.Name = "Col_Antiguedad";
//
// Col_Af_DescripcionCorta
//
this.Col_Af_DescripcionCorta.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.Col_Af_DescripcionCorta.AreaIndex = 4;
this.Col_Af_DescripcionCorta.Caption = "Maquina";
this.Col_Af_DescripcionCorta.FieldName = "Af_DescripcionCorta";
this.Col_Af_DescripcionCorta.Name = "Col_Af_DescripcionCorta";
//
// ucRo_Menu
//
this.ucRo_Menu.Dock = System.Windows.Forms.DockStyle.Top;
this.ucRo_Menu.EnableBotonImprimir = true;
this.ucRo_Menu.Location = new System.Drawing.Point(0, 0);
this.ucRo_Menu.Name = "ucRo_Menu";
this.ucRo_Menu.Size = new System.Drawing.Size(1284, 74);
this.ucRo_Menu.TabIndex = 148;
this.ucRo_Menu.VisibleCmbCentroCosto = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbDivision = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbEmpleado = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleCmbNominaTipo = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleCmbNominaTipoLiqui = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleCmbPeriodo = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleCmbRubro = DevExpress.XtraBars.BarItemVisibility.Never;
this.ucRo_Menu.VisibleDepartamento = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleEstado = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.VisibleGrupoFecha = false;
this.ucRo_Menu.VisibleGrupoFiltro1 = true;
this.ucRo_Menu.VisibleGrupoFiltro2 = false;
this.ucRo_Menu.VisubleArea = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucRo_Menu.event_cmdCargar_ItemClick += new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes.delegate_cmdCargar_ItemClick(this.ucRo_Menu_event_cmdCargar_ItemClick);
this.ucRo_Menu.event_btnsalir_ItemClick += new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes.delegate_btnsalir_ItemClick(this.ucRo_Menu_event_btnsalir_ItemClick);
//
// XROLES_Rpt009_frm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1284, 491);
this.Controls.Add(this.pivotGridControl1);
this.Controls.Add(this.ucRo_Menu);
this.Name = "XROLES_Rpt009_frm";
this.Text = "XROLES_Rpt009_frm";
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).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.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup4 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.pivotGridField4 = new DevExpress.XtraPivotGrid.PivotGridField();
this.nwindDataSet = new PivotSample.nwindDataSet();
this.customerReportsBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.customerReportsTableAdapter = new PivotSample.nwindDataSetTableAdapters.CustomerReportsTableAdapter();
this.popupControlContainer1 = new DevExpress.XtraBars.PopupControlContainer(this.components);
this.customFieldFilterControl1 = new PivotSample.CustomFieldFilterControl();
this.panelControl1 = new DevExpress.XtraEditors.PanelControl();
this.simpleButton3 = new DevExpress.XtraEditors.SimpleButton();
this.simpleButton4 = new DevExpress.XtraEditors.SimpleButton();
this.barManager1 = new DevExpress.XtraBars.BarManager(this.components);
this.barDockControlTop = new DevExpress.XtraBars.BarDockControl();
this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl();
this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl();
this.barDockControlRight = new DevExpress.XtraBars.BarDockControl();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.customerReportsBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.popupControlContainer1)).BeginInit();
this.popupControlContainer1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
this.panelControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.barManager1)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192)))));
pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition1.ApplyToCell = false;
pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Greater;
pivotGridStyleFormatCondition1.FieldName = "";
pivotGridStyleFormatCondition1.Value1 = new decimal(new int[] {
0,
0,
0,
0
});
this.pivotGridControl1.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1
});
pivotGridGroup1.Caption = "Category Name";
pivotGridGroup1.Hierarchy = "[Categories].[Category Name]";
pivotGridGroup1.ShowNewValues = true;
pivotGridGroup2.Caption = "City";
pivotGridGroup2.Hierarchy = "[Customers].[City]";
pivotGridGroup2.ShowNewValues = true;
pivotGridGroup3.Caption = "Country";
pivotGridGroup3.Hierarchy = "[Customers].[Country]";
pivotGridGroup3.ShowNewValues = true;
pivotGridGroup4.Caption = "Products";
pivotGridGroup4.Hierarchy = "[Products].[Products]";
pivotGridGroup4.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1,
pivotGridGroup2,
pivotGridGroup3,
pivotGridGroup4
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.LookAndFeel.UseDefaultLookAndFeel = false;
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OLAPConnectionString = "";
this.pivotGridControl1.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007;
this.pivotGridControl1.OptionsDataField.Area = DevExpress.XtraPivotGrid.PivotDataArea.ColumnArea;
this.pivotGridControl1.OptionsDataField.AreaIndex = 0;
this.pivotGridControl1.OptionsView.RowTreeWidth = 238;
this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = false;
this.pivotGridControl1.OptionsView.ShowRowGrandTotals = false;
this.pivotGridControl1.OptionsView.ShowTotalsForSingleValues = true;
this.pivotGridControl1.Size = new System.Drawing.Size(593, 500);
this.pivotGridControl1.TabIndex = 0;
this.pivotGridControl1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.pivotGridControl1_MouseDown);
//
// pivotGridField4
//
this.pivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField4.AreaIndex = 0;
this.pivotGridField4.FieldName = "Date";
this.pivotGridField4.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
this.pivotGridField4.Name = "pivotGridField4";
this.pivotGridField4.UnboundFieldName = "pivotGridField3";
//
// nwindDataSet
//
this.nwindDataSet.DataSetName = "nwindDataSet";
this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// customerReportsBindingSource
//
this.customerReportsBindingSource.DataMember = "CustomerReports";
this.customerReportsBindingSource.DataSource = this.nwindDataSet;
//
// customerReportsTableAdapter
//
this.customerReportsTableAdapter.ClearBeforeFill = true;
//
// popupControlContainer1
//
this.popupControlContainer1.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
this.popupControlContainer1.Controls.Add(this.customFieldFilterControl1);
this.popupControlContainer1.Controls.Add(this.panelControl1);
this.popupControlContainer1.Location = new System.Drawing.Point(139, 189);
this.popupControlContainer1.Manager = this.barManager1;
this.popupControlContainer1.Name = "popupControlContainer1";
this.popupControlContainer1.Size = new System.Drawing.Size(404, 287);
this.popupControlContainer1.TabIndex = 3;
this.popupControlContainer1.Visible = false;
//
// customFieldFilterControl1
//
this.customFieldFilterControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.customFieldFilterControl1.Field = null;
this.customFieldFilterControl1.Location = new System.Drawing.Point(0, 0);
this.customFieldFilterControl1.Name = "customFieldFilterControl1";
this.customFieldFilterControl1.Size = new System.Drawing.Size(404, 261);
this.customFieldFilterControl1.TabIndex = 0;
//
// panelControl1
//
this.panelControl1.Controls.Add(this.simpleButton3);
this.panelControl1.Controls.Add(this.simpleButton4);
this.panelControl1.Dock = System.Windows.Forms.DockStyle.Bottom;
this.panelControl1.Location = new System.Drawing.Point(0, 261);
this.panelControl1.Name = "panelControl1";
this.panelControl1.Size = new System.Drawing.Size(404, 26);
this.panelControl1.TabIndex = 2;
//
// simpleButton3
//
this.simpleButton3.Dock = System.Windows.Forms.DockStyle.Right;
this.simpleButton3.Location = new System.Drawing.Point(252, 2);
this.simpleButton3.Name = "simpleButton3";
this.simpleButton3.Size = new System.Drawing.Size(75, 22);
this.simpleButton3.TabIndex = 1;
this.simpleButton3.Text = "Ok";
this.simpleButton3.Click += new System.EventHandler(this.simpleButton3_Click);
//
// simpleButton4
//
this.simpleButton4.Dock = System.Windows.Forms.DockStyle.Right;
this.simpleButton4.Location = new System.Drawing.Point(327, 2);
this.simpleButton4.Name = "simpleButton4";
this.simpleButton4.Size = new System.Drawing.Size(75, 22);
this.simpleButton4.TabIndex = 0;
this.simpleButton4.Text = "Cancel";
this.simpleButton4.Click += new System.EventHandler(this.simpleButton4_Click);
//
// barManager1
//
this.barManager1.DockControls.Add(this.barDockControlTop);
this.barManager1.DockControls.Add(this.barDockControlBottom);
this.barManager1.DockControls.Add(this.barDockControlLeft);
this.barManager1.DockControls.Add(this.barDockControlRight);
this.barManager1.Form = this;
this.barManager1.MaxItemId = 0;
//
// 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(593, 0);
//
// barDockControlBottom
//
this.barDockControlBottom.CausesValidation = false;
this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
this.barDockControlBottom.Location = new System.Drawing.Point(0, 500);
this.barDockControlBottom.Size = new System.Drawing.Size(593, 0);
//
// barDockControlLeft
//
this.barDockControlLeft.CausesValidation = false;
this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
this.barDockControlLeft.Location = new System.Drawing.Point(0, 0);
this.barDockControlLeft.Size = new System.Drawing.Size(0, 500);
//
// barDockControlRight
//
this.barDockControlRight.CausesValidation = false;
this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
this.barDockControlRight.Location = new System.Drawing.Point(593, 0);
this.barDockControlRight.Size = new System.Drawing.Size(0, 500);
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(593, 500);
this.Controls.Add(this.popupControlContainer1);
this.Controls.Add(this.pivotGridControl1);
this.Controls.Add(this.barDockControlLeft);
this.Controls.Add(this.barDockControlRight);
this.Controls.Add(this.barDockControlBottom);
this.Controls.Add(this.barDockControlTop);
this.Name = "Form1";
this.Text = "Form1";
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.customerReportsBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.popupControlContainer1)).EndInit();
this.popupControlContainer1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
this.panelControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.barManager1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <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.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup();
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.fieldOrderDate = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate3 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldShipCountry1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldShipCity1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.xtraPivotGridTutorialBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.nwindDataSet = new NwindDataSet.nwindDataSet();
this.fieldUnitPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldQuantity1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldFreight1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldShipperCompany1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldOrderDate4 = new DevExpress.XtraPivotGrid.PivotGridField();
this.xtraPivotGridTutorialViewTableAdapter = new NwindDataSet.nwindDataSetTableAdapters.XtraPivotGridTutorialViewTableAdapter();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit();
this.SuspendLayout();
//
// fieldOrderDate
//
this.fieldOrderDate.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate.AreaIndex = 0;
this.fieldOrderDate.Caption = "Year";
this.fieldOrderDate.FieldName = "OrderDate";
this.fieldOrderDate.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.fieldOrderDate.Name = "fieldOrderDate";
this.fieldOrderDate.UnboundFieldName = "fieldOrderDate";
//
// fieldOrderDate1
//
this.fieldOrderDate1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate1.AreaIndex = 1;
this.fieldOrderDate1.Caption = "Quarter";
this.fieldOrderDate1.ExpandedInFieldsGroup = false;
this.fieldOrderDate1.FieldName = "OrderDate";
this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter;
this.fieldOrderDate1.Name = "fieldOrderDate1";
this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1";
this.fieldOrderDate1.ValueFormat.FormatString = "Quarter {0}";
this.fieldOrderDate1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// fieldOrderDate2
//
this.fieldOrderDate2.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate2.AreaIndex = 2;
this.fieldOrderDate2.Caption = "Month";
this.fieldOrderDate2.ExpandedInFieldsGroup = false;
this.fieldOrderDate2.FieldName = "OrderDate";
this.fieldOrderDate2.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
this.fieldOrderDate2.Name = "fieldOrderDate2";
this.fieldOrderDate2.UnboundFieldName = "fieldOrderDate2";
this.fieldOrderDate2.Visible = false;
//
// fieldOrderDate3
//
this.fieldOrderDate3.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate3.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate3.AreaIndex = 3;
this.fieldOrderDate3.Caption = "Day";
this.fieldOrderDate3.FieldName = "OrderDate";
this.fieldOrderDate3.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateDay;
this.fieldOrderDate3.Name = "fieldOrderDate3";
this.fieldOrderDate3.UnboundFieldName = "fieldOrderDate3";
this.fieldOrderDate3.Visible = false;
//
// fieldShipCountry1
//
this.fieldShipCountry1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldShipCountry1.AreaIndex = 0;
this.fieldShipCountry1.Caption = "Ship Country";
this.fieldShipCountry1.FieldName = "ShipCountry";
this.fieldShipCountry1.Name = "fieldShipCountry1";
this.fieldShipCountry1.Visible = false;
//
// fieldShipCity1
//
this.fieldShipCity1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldShipCity1.AreaIndex = 1;
this.fieldShipCity1.Caption = "Ship City";
this.fieldShipCity1.FieldName = "ShipCity";
this.fieldShipCity1.Name = "fieldShipCity1";
this.fieldShipCity1.Visible = false;
//
// fieldCategoryName1
//
this.fieldCategoryName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCategoryName1.AreaIndex = 0;
this.fieldCategoryName1.Caption = "Category";
this.fieldCategoryName1.FieldName = "CategoryName";
this.fieldCategoryName1.Name = "fieldCategoryName1";
//
// fieldProductName1
//
this.fieldProductName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldProductName1.AreaIndex = 1;
this.fieldProductName1.Caption = "Product";
this.fieldProductName1.FieldName = "ProductName";
this.fieldProductName1.Name = "fieldProductName1";
//
// pivotGridControl1
//
this.pivotGridControl1.DataSource = this.xtraPivotGridTutorialBindingSource;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldCategoryName1,
this.fieldProductName1,
this.fieldUnitPrice1,
this.fieldQuantity1,
this.fieldPrice1,
this.fieldExtendedPrice1,
this.fieldFreight1,
this.fieldSalesPerson1,
this.fieldShipCountry1,
this.fieldShipCity1,
this.fieldShipperCompany1,
this.fieldOrderDate,
this.fieldOrderDate1,
this.fieldOrderDate2,
this.fieldOrderDate3,
this.fieldOrderDate4
});
pivotGridGroup1.Caption = "Calendar";
pivotGridGroup1.Fields.Add(this.fieldOrderDate);
pivotGridGroup1.Fields.Add(this.fieldOrderDate1);
pivotGridGroup1.Fields.Add(this.fieldOrderDate2);
pivotGridGroup1.Fields.Add(this.fieldOrderDate3);
pivotGridGroup1.Hierarchy = null;
pivotGridGroup1.ShowNewValues = true;
pivotGridGroup2.Caption = "Ship Info";
pivotGridGroup2.Fields.Add(this.fieldShipCountry1);
pivotGridGroup2.Fields.Add(this.fieldShipCity1);
pivotGridGroup2.Hierarchy = null;
pivotGridGroup2.ShowNewValues = true;
pivotGridGroup3.Caption = "Product Info";
pivotGridGroup3.Fields.Add(this.fieldCategoryName1);
pivotGridGroup3.Fields.Add(this.fieldProductName1);
pivotGridGroup3.Hierarchy = null;
pivotGridGroup3.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1,
pivotGridGroup2,
pivotGridGroup3
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.Size = new System.Drawing.Size(1012, 541);
this.pivotGridControl1.TabIndex = 0;
//
// xtraPivotGridTutorialBindingSource
//
this.xtraPivotGridTutorialBindingSource.DataMember = "XtraPivotGridTutorialView";
this.xtraPivotGridTutorialBindingSource.DataSource = this.nwindDataSet;
//
// nwindDataSet
//
this.nwindDataSet.DataSetName = "nwindDataSet";
this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// fieldUnitPrice1
//
this.fieldUnitPrice1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldUnitPrice1.AreaIndex = 0;
this.fieldUnitPrice1.Caption = "Unit Price";
this.fieldUnitPrice1.FieldName = "UnitPrice";
this.fieldUnitPrice1.Name = "fieldUnitPrice1";
this.fieldUnitPrice1.Visible = false;
//
// fieldQuantity1
//
this.fieldQuantity1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldQuantity1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldQuantity1.AreaIndex = 1;
this.fieldQuantity1.Caption = "Quantity";
this.fieldQuantity1.FieldName = "Quantity";
this.fieldQuantity1.Name = "fieldQuantity1";
//
// fieldPrice1
//
this.fieldPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldPrice1.AreaIndex = 0;
this.fieldPrice1.Caption = "Amount";
this.fieldPrice1.CellFormat.FormatString = "C0";
this.fieldPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldPrice1.FieldName = "Price";
this.fieldPrice1.Name = "fieldPrice1";
//
// fieldExtendedPrice1
//
this.fieldExtendedPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldExtendedPrice1.AreaIndex = 0;
this.fieldExtendedPrice1.Caption = "Extended Amount";
this.fieldExtendedPrice1.CellFormat.FormatString = "C0";
this.fieldExtendedPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldExtendedPrice1.FieldName = "ExtendedPrice";
this.fieldExtendedPrice1.Name = "fieldExtendedPrice1";
this.fieldExtendedPrice1.Visible = false;
//
// fieldFreight1
//
this.fieldFreight1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.fieldFreight1.AreaIndex = 0;
this.fieldFreight1.Caption = "Freight";
this.fieldFreight1.CellFormat.FormatString = "C0";
this.fieldFreight1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldFreight1.FieldName = "Freight";
this.fieldFreight1.Name = "fieldFreight1";
this.fieldFreight1.Visible = false;
//
// fieldSalesPerson1
//
this.fieldSalesPerson1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldSalesPerson1.AreaIndex = 0;
this.fieldSalesPerson1.Caption = "Sales Person";
this.fieldSalesPerson1.FieldName = "SalesPerson";
this.fieldSalesPerson1.Name = "fieldSalesPerson1";
this.fieldSalesPerson1.Visible = false;
//
// fieldShipperCompany1
//
this.fieldShipperCompany1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldShipperCompany1.AreaIndex = 0;
this.fieldShipperCompany1.Caption = "Shipper Company";
this.fieldShipperCompany1.FieldName = "ShipperCompany";
this.fieldShipperCompany1.Name = "fieldShipperCompany1";
this.fieldShipperCompany1.Visible = false;
//
// fieldOrderDate4
//
this.fieldOrderDate4.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.fieldOrderDate4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldOrderDate4.AreaIndex = 4;
this.fieldOrderDate4.Caption = "Date";
this.fieldOrderDate4.FieldName = "OrderDate";
this.fieldOrderDate4.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.Date;
this.fieldOrderDate4.Name = "fieldOrderDate4";
this.fieldOrderDate4.UnboundFieldName = "fieldOrderDate4";
this.fieldOrderDate4.Visible = false;
//
// xtraPivotGridTutorialViewTableAdapter
//
this.xtraPivotGridTutorialViewTableAdapter.ClearBeforeFill = true;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1012, 541);
this.Controls.Add(this.pivotGridControl1);
this.Name = "Form1";
this.Text = "XtraPivotGridTutorial.Step2";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField4 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField5 = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.pivotGridField1,
this.pivotGridField2,
this.pivotGridField3,
this.pivotGridField4,
this.pivotGridField5
});
pivotGridGroup1.Caption = "Date.Fiscal";
pivotGridGroup1.Fields.Add(this.pivotGridField3);
pivotGridGroup1.Fields.Add(this.pivotGridField4);
pivotGridGroup1.Hierarchy = "[Date].[Fiscal]";
pivotGridGroup1.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OLAPConnectionString = "provider=MSOLAP;data source=https://demos.devexpress.com/Services/OLAP/msmdpump.d" +
"ll;initial catalog=\"Adventure Works DW Standard Edition\";cube name=\"Adventure Wo" +
"rks\"";
this.pivotGridControl1.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.Adomd;
this.pivotGridControl1.OptionsData.DataProcessingEngine = DevExpress.XtraPivotGrid.PivotDataProcessingEngine.LegacyOptimized;
this.pivotGridControl1.Size = new System.Drawing.Size(768, 362);
this.pivotGridControl1.TabIndex = 0;
//
// pivotGridField1
//
this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField1.AreaIndex = 0;
this.pivotGridField1.Caption = "Country";
this.pivotGridField1.DisplayFolder = "Location";
this.pivotGridField1.FieldName = "[Customer].[Country].[Country]";
this.pivotGridField1.Name = "pivotGridField1";
//
// pivotGridField2
//
this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField2.AreaIndex = 1;
this.pivotGridField2.Caption = "City";
this.pivotGridField2.DisplayFolder = "Location";
this.pivotGridField2.FieldName = "[Customer].[City].[City]";
this.pivotGridField2.Name = "pivotGridField2";
//
// pivotGridField3
//
this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField3.AreaIndex = 0;
this.pivotGridField3.Caption = "Fiscal Year";
this.pivotGridField3.DisplayFolder = "Fiscal";
this.pivotGridField3.FieldName = "[Date].[Fiscal].[Fiscal Year]";
this.pivotGridField3.Name = "pivotGridField3";
//
// pivotGridField4
//
this.pivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField4.AreaIndex = 1;
this.pivotGridField4.Caption = "Fiscal Quarter";
this.pivotGridField4.DisplayFolder = "Fiscal";
this.pivotGridField4.FieldName = "[Date].[Fiscal].[Fiscal Quarter]";
this.pivotGridField4.Name = "pivotGridField4";
//
// pivotGridField5
//
this.pivotGridField5.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField5.AreaIndex = 0;
this.pivotGridField5.Caption = "Internet Sales Amount";
this.pivotGridField5.DisplayFolder = "Internet Sales";
this.pivotGridField5.FieldName = "[Measures].[Internet Sales Amount]";
this.pivotGridField5.Name = "pivotGridField5";
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(768, 362);
this.Controls.Add(this.pivotGridControl1);
this.Name = "Form1";
this.Text = "Form1";
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.fieldYear = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldMonth = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDay = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.fieldName = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPrice = new DevExpress.XtraPivotGrid.PivotGridField();
this.radioGroup1 = new DevExpress.XtraEditors.RadioGroup();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.radioGroup1.Properties)).BeginInit();
this.SuspendLayout();
//
// fieldYear
//
this.fieldYear.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldYear.AreaIndex = 0;
this.fieldYear.FieldName = "Year";
this.fieldYear.Name = "fieldYear";
//
// fieldMonth
//
this.fieldMonth.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldMonth.AreaIndex = 1;
this.fieldMonth.FieldName = "Month";
this.fieldMonth.Name = "fieldMonth";
//
// fieldDay
//
this.fieldDay.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldDay.AreaIndex = 2;
this.fieldDay.FieldName = "Day";
this.fieldDay.Name = "fieldDay";
//
// pivotGridControl1
//
this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldName,
this.fieldPrice,
this.fieldYear,
this.fieldMonth,
this.fieldDay
});
pivotGridGroup1.Fields.Add(this.fieldYear);
pivotGridGroup1.Fields.Add(this.fieldMonth);
pivotGridGroup1.Fields.Add(this.fieldDay);
pivotGridGroup1.Hierarchy = null;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(12, 92);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OptionsView.RowTotalsLocation = DevExpress.XtraPivotGrid.PivotRowTotalsLocation.Tree;
this.pivotGridControl1.OptionsView.ShowTotalsForSingleValues = true;
this.pivotGridControl1.Size = new System.Drawing.Size(719, 367);
this.pivotGridControl1.TabIndex = 0;
this.pivotGridControl1.FieldValueDisplayText += new DevExpress.XtraPivotGrid.PivotFieldDisplayTextEventHandler(this.pivotGridControl1_FieldValueDisplayText);
//
// fieldName
//
this.fieldName.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldName.AreaIndex = 0;
this.fieldName.FieldName = "Name";
this.fieldName.Name = "fieldName";
//
// fieldPrice
//
this.fieldPrice.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldPrice.AreaIndex = 0;
this.fieldPrice.FieldName = "Price";
this.fieldPrice.Name = "fieldPrice";
//
// radioGroup1
//
this.radioGroup1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.radioGroup1.EditValue = 1;
this.radioGroup1.Location = new System.Drawing.Point(12, 12);
this.radioGroup1.Name = "radioGroup1";
this.radioGroup1.Properties.Columns = 2;
this.radioGroup1.Properties.Items.AddRange(new DevExpress.XtraEditors.Controls.RadioGroupItem[] {
new DevExpress.XtraEditors.Controls.RadioGroupItem(1, "Show all data"),
new DevExpress.XtraEditors.Controls.RadioGroupItem(2, "Show December 2009 and January 2010 only"),
new DevExpress.XtraEditors.Controls.RadioGroupItem(2, "Hide 2009 year"),
new DevExpress.XtraEditors.Controls.RadioGroupItem(3, "Show first days of months only")
});
this.radioGroup1.Size = new System.Drawing.Size(719, 74);
this.radioGroup1.TabIndex = 5;
this.radioGroup1.SelectedIndexChanged += new System.EventHandler(this.radioGroup1_SelectedIndexChanged);
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(743, 471);
this.Controls.Add(this.radioGroup1);
this.Controls.Add(this.pivotGridControl1);
this.Name = "Form1";
this.Text = "Hierarchical Filters";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.radioGroup1.Properties)).EndInit();
this.ResumeLayout(false);
}
//通过配置的PivotList 设置PivotField 的信息
private Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> setPivotFieldByCfg(ColPivotList xmlCfgLst, DevExpress.XtraPivotGrid.PivotGridControl gridCtl,
MB.WinBase.Common.ColumnPropertyInfo fieldInfo)
{
if (xmlCfgLst == null)
{
return(null);
}
if (xmlCfgLst.Columns.Count == 0 && !xmlCfgLst.AutoCreatedGridField)
{
return(null);
}
IList <MB.XWinLib.PivotGrid.ColPivotInfo> infos = xmlCfgLst.GetColPivotInfos(fieldInfo.Name);
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup = null;
if (infos.Count > 1 && xmlCfgLst.SameFieldGroup)
{
pivotGridGroup = new DevExpress.XtraPivotGrid.PivotGridGroup();
gridCtl.Groups.Add(pivotGridGroup);
}
if (infos.Count == 0)
{
createNewPivotField(fieldInfo.Name, fieldInfo.Description, gridCtl);
//add by aifang 去掉汇总后金额显示格式（原来不管是金额还是数量都显示￥前缀）begin
if (fieldInfo.DataType.Equals("System.Decimal"))
{
gridCtl.Fields[fieldInfo.Name].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
}
//add by aifang end
return(null);
}
else
{
Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> expressionFields =
new Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo>();
//处理一个字段对应多个分组的情况
foreach (ColPivotInfo info in infos)
{
DevExpress.XtraPivotGrid.PivotGridField pivField = createNewPivotField(fieldInfo.Name, fieldInfo.Description, gridCtl);
//如果定义了Expression则表示该列的值是通过其他列或其他手段推算而出的
if (!string.IsNullOrEmpty(info.Expression))
{
expressionFields.Add(pivField, info);
}
if (info.Description != null && info.Description.Length > 0)
{
pivField.Caption = info.Description;
}
pivField.Area = info.IniArea;
pivField.AreaIndex = info.AreaIndex;
pivField.AllowedAreas = info.AllowedAreas;
pivField.TopValueCount = info.TopValueCount;
pivField.GroupInterval = info.GroupInterval;
if (info.SummaryItemType != null && info.SummaryItemType.Length > 0)
{
pivField.SummaryType = (DevExpress.Data.PivotGrid.PivotSummaryType)Enum.Parse(typeof(DevExpress.Data.PivotGrid.PivotSummaryType), info.SummaryItemType);
}
//setDefaultFormatByGroup(pivField);
//格式化显示数据。
if (info.CellFormat != DevExpress.Utils.FormatInfo.Empty)
{
pivField.CellFormat.Format = info.CellFormat.Format;
pivField.CellFormat.FormatType = info.CellFormat.FormatType;
pivField.CellFormat.FormatString = info.CellFormat.FormatString;
}
if (info.ValueFormat != DevExpress.Utils.FormatInfo.Empty)
{
pivField.ValueFormat.Format = info.CellFormat.Format;
pivField.ValueFormat.FormatType = info.CellFormat.FormatType;
pivField.ValueFormat.FormatString = info.CellFormat.FormatString;
}
//加入字段绑定分组。
if (pivotGridGroup != null)
{
pivotGridGroup.Add(pivField);
}
//DevExpress.XtraPivotGrid.PivotGroupInterval.DateDayOfWeek
}
return(expressionFields);
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.fieldFiscalYear = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.fieldSalesAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProduct = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
this.SuspendLayout();
//
// fieldFiscalYear
//
this.fieldFiscalYear.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldFiscalYear.AreaIndex = 0;
this.fieldFiscalYear.Caption = "Year";
this.fieldFiscalYear.DisplayFolder = "Fiscal";
this.fieldFiscalYear.FieldName = "[Date].[Fiscal].[Fiscal Year]";
this.fieldFiscalYear.Name = "fieldFiscalYear";
//
// pivotGridControl1
//
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldSalesAmount,
this.fieldProduct,
this.fieldFiscalYear
});
pivotGridGroup1.Caption = "Date.Fiscal";
pivotGridGroup1.Fields.Add(this.fieldFiscalYear);
pivotGridGroup1.Hierarchy = "[Date].[Fiscal]";
pivotGridGroup1.ShowNewValues = true;
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup1
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OLAPConnectionString = "provider=MSOLAP;data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dl" +
"l;initial catalog=\"Adventure Works DW Standard Edition\";cube name=\"Adventure Wor" +
"ks\"";
this.pivotGridControl1.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.Adomd;
this.pivotGridControl1.Size = new System.Drawing.Size(719, 466);
this.pivotGridControl1.TabIndex = 0;
this.pivotGridControl1.CustomServerModeSort += new System.EventHandler <DevExpress.XtraPivotGrid.CustomServerModeSortEventArgs>(this.pivotGridControl1_CustomServerModeSort);
this.pivotGridControl1.FieldValueDisplayText += new DevExpress.XtraPivotGrid.PivotFieldDisplayTextEventHandler(this.pivotGridControl1_FieldValueDisplayText);
//
// fieldSalesAmount
//
this.fieldSalesAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldSalesAmount.AreaIndex = 0;
this.fieldSalesAmount.Caption = "Sales Amount";
this.fieldSalesAmount.DisplayFolder = "Sales Summary";
this.fieldSalesAmount.FieldName = "[Measures].[Sales Amount]";
this.fieldSalesAmount.Name = "fieldSalesAmount";
//
// fieldProduct
//
this.fieldProduct.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldProduct.AreaIndex = 0;
this.fieldProduct.Caption = "Product";
this.fieldProduct.FieldName = "[Product].[Product].[Product]";
this.fieldProduct.Name = "fieldProduct";
this.fieldProduct.Width = 200;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(719, 466);
this.Controls.Add(this.pivotGridControl1);
this.Name = "Form1";
this.Text = "Custom OLAP Sorting";
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).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()
{
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.panelControl1 = new DevExpress.XtraEditors.PanelControl();
this.btnRetrieveFields = new DevExpress.XtraEditors.SimpleButton();
this.btnCreateUnboundFields = new DevExpress.XtraEditors.SimpleButton();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
this.panelControl1.SuspendLayout();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
pivotGridGroup2.Caption = "Date.Fiscal";
pivotGridGroup2.Hierarchy = "[Date].[Fiscal]";
this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] {
pivotGridGroup2
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 52);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.OLAPConnectionString = "";
this.pivotGridControl1.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.Adomd;
this.pivotGridControl1.Size = new System.Drawing.Size(755, 387);
this.pivotGridControl1.TabIndex = 0;
//
// panelControl1
//
this.panelControl1.Controls.Add(this.btnCreateUnboundFields);
this.panelControl1.Controls.Add(this.btnRetrieveFields);
this.panelControl1.Dock = System.Windows.Forms.DockStyle.Top;
this.panelControl1.Location = new System.Drawing.Point(0, 0);
this.panelControl1.Name = "panelControl1";
this.panelControl1.Size = new System.Drawing.Size(755, 52);
this.panelControl1.TabIndex = 1;
//
// btnRetrieveFields
//
this.btnRetrieveFields.AccessibleDescription = " pivotGridControl1.Fields[\"[Customer].[Country].[Country]\"]";
this.btnRetrieveFields.Location = new System.Drawing.Point(30, 12);
this.btnRetrieveFields.Name = "btnRetrieveFields";
this.btnRetrieveFields.Size = new System.Drawing.Size(107, 23);
this.btnRetrieveFields.TabIndex = 0;
this.btnRetrieveFields.Text = "Retrieve Fields";
this.btnRetrieveFields.Click += new System.EventHandler(this.btnRetrieveFields_Click);
//
// btnCreateUnboundFields
//
this.btnCreateUnboundFields.AccessibleDescription = "";
this.btnCreateUnboundFields.Location = new System.Drawing.Point(174, 12);
this.btnCreateUnboundFields.Name = "btnCreateUnboundFields";
this.btnCreateUnboundFields.Size = new System.Drawing.Size(107, 23);
this.btnCreateUnboundFields.TabIndex = 1;
this.btnCreateUnboundFields.Text = "Create Fields";
this.btnCreateUnboundFields.Click += new System.EventHandler(this.btnCreateFields_Click);
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(755, 439);
this.Controls.Add(this.pivotGridControl1);
this.Controls.Add(this.panelControl1);
this.Name = "Form1";
this.Text = "WinForms Pivot Grid OLAP Example";
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
this.panelControl1.ResumeLayout(false);
this.ResumeLayout(false);
}
