void ConfigureSummaryDisplayTypeComboBox(SummaryDisplayTypeGroup typeGroup) { List <PivotSummaryDisplayType> types = new List <PivotSummaryDisplayType>(); switch (typeGroup) { case SummaryDisplayTypeGroup.Variation: types.Add(PivotSummaryDisplayType.AbsoluteVariation); types.Add(PivotSummaryDisplayType.PercentVariation); break; case SummaryDisplayTypeGroup.Percentage: types.Add(PivotSummaryDisplayType.PercentOfColumn); types.Add(PivotSummaryDisplayType.PercentOfRow); types.Add(PivotSummaryDisplayType.PercentOfColumnGrandTotal); types.Add(PivotSummaryDisplayType.PercentOfRowGrandTotal); types.Add(PivotSummaryDisplayType.PercentOfGrandTotal); break; case SummaryDisplayTypeGroup.Rank: types.Add(PivotSummaryDisplayType.RankInColumnLargestToSmallest); types.Add(PivotSummaryDisplayType.RankInColumnSmallestToLargest); types.Add(PivotSummaryDisplayType.RankInRowLargestToSmallest); types.Add(PivotSummaryDisplayType.RankInRowSmallestToLargest); break; case SummaryDisplayTypeGroup.Index: types.Add(PivotSummaryDisplayType.Index); break; } ddlSummaryDisplayType.Items.Clear(); foreach (PivotSummaryDisplayType type in types) { ddlSummaryDisplayType.Items.Add(Enum.GetName(typeof(PivotSummaryDisplayType), type), type); } ddlSummaryDisplayType.SelectedIndex = 0; }
void ConfigurePivotGridLayout(SummaryDisplayTypeGroup typeGroup) { pivotGrid.BeginUpdate(); switch (typeGroup) { case SummaryDisplayTypeGroup.Variation: { pivotGrid.DataSourceID = "SalesPersonsDataSource"; pivotGrid.Fields.Clear(); PivotGridField fieldYear = pivotGrid.Fields.Add("OrderDate", DevExpress.XtraPivotGrid.PivotArea.ColumnArea); fieldYear.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; fieldYear.Caption = "Year"; PivotGridField fieldQuarter = pivotGrid.Fields.Add("OrderDate", DevExpress.XtraPivotGrid.PivotArea.ColumnArea); fieldQuarter.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter; fieldQuarter.ValueFormat.FormatString = "Qtr {0}"; fieldQuarter.ValueFormat.FormatType = DevExpress.Utils.FormatType.Custom; fieldQuarter.Caption = "Quarter"; pivotGrid.Fields.Add("Sales Person", DevExpress.XtraPivotGrid.PivotArea.RowArea); PivotGridField sourceDataField = pivotGrid.Fields.Add("OrderID", DevExpress.XtraPivotGrid.PivotArea.DataArea); sourceDataField.SummaryType = PivotSummaryType.Count; sourceDataField.Caption = "Order Count"; SourceDataFieldName = sourceDataField.FieldName; PivotGridField summaryDisplayTypeDataField = pivotGrid.Fields.Add(SourceDataFieldName, DevExpress.XtraPivotGrid.PivotArea.DataArea); summaryDisplayTypeDataField.SummaryType = sourceDataField.SummaryType; summaryDisplayTypeDataField.ID = SummaryDisplayTypeDataFieldID; } break; case SummaryDisplayTypeGroup.Percentage: { pivotGrid.DataSourceID = "ProductReportsDataSource"; pivotGrid.Fields.Clear(); PivotGridField fieldYear = pivotGrid.Fields.Add("ShippedDate", DevExpress.XtraPivotGrid.PivotArea.ColumnArea); fieldYear.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; fieldYear.Caption = "Year"; PivotGridField fieldMonth = pivotGrid.Fields.Add("ShippedDate", DevExpress.XtraPivotGrid.PivotArea.ColumnArea); fieldMonth.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth; fieldMonth.Caption = "Month"; pivotGrid.Fields.Add("CategoryName", DevExpress.XtraPivotGrid.PivotArea.RowArea); pivotGrid.Fields.Add("ProductName", DevExpress.XtraPivotGrid.PivotArea.RowArea); PivotGridField sourceDataField = pivotGrid.Fields.Add("ProductSales", DevExpress.XtraPivotGrid.PivotArea.DataArea); SourceDataFieldName = sourceDataField.FieldName; PivotGridField summaryDisplayTypeDataField = pivotGrid.Fields.Add(SourceDataFieldName, DevExpress.XtraPivotGrid.PivotArea.DataArea); summaryDisplayTypeDataField.ID = SummaryDisplayTypeDataFieldID; } break; case SummaryDisplayTypeGroup.Rank: { pivotGrid.DataSourceID = "SalesPersonsDataSource"; pivotGrid.Fields.Clear(); PivotGridField fieldYear = pivotGrid.Fields.Add("OrderDate", DevExpress.XtraPivotGrid.PivotArea.ColumnArea); fieldYear.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; fieldYear.Caption = "Year"; PivotGridField fieldQuarter = pivotGrid.Fields.Add("OrderDate", DevExpress.XtraPivotGrid.PivotArea.ColumnArea); fieldQuarter.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter; fieldQuarter.ValueFormat.FormatString = "Qtr {0}"; fieldQuarter.ValueFormat.FormatType = DevExpress.Utils.FormatType.Custom; fieldQuarter.Caption = "Quarter"; pivotGrid.Fields.Add("Country", DevExpress.XtraPivotGrid.PivotArea.RowArea); pivotGrid.Fields.Add("Sales Person", DevExpress.XtraPivotGrid.PivotArea.RowArea); PivotGridField sourceDataField = pivotGrid.Fields.Add("Extended_Price", DevExpress.XtraPivotGrid.PivotArea.DataArea); sourceDataField.Caption = "Sales"; SourceDataFieldName = sourceDataField.FieldName; PivotGridField summaryDisplayTypeDataField = pivotGrid.Fields.Add(SourceDataFieldName, DevExpress.XtraPivotGrid.PivotArea.DataArea); summaryDisplayTypeDataField.ID = SummaryDisplayTypeDataFieldID; } break; case SummaryDisplayTypeGroup.Index: { pivotGrid.DataSourceID = "SalesPersonsDataSource"; pivotGrid.Fields.Clear(); PivotGridField fieldYear = pivotGrid.Fields.Add("Country", DevExpress.XtraPivotGrid.PivotArea.ColumnArea); pivotGrid.Fields.Add("CategoryName", DevExpress.XtraPivotGrid.PivotArea.RowArea); PivotGridField sourceDataField = pivotGrid.Fields.Add("Extended_Price", DevExpress.XtraPivotGrid.PivotArea.DataArea); sourceDataField.Caption = "Sales"; SourceDataFieldName = sourceDataField.FieldName; PivotGridField summaryDisplayTypeDataField = pivotGrid.Fields.Add(SourceDataFieldName, DevExpress.XtraPivotGrid.PivotArea.DataArea); summaryDisplayTypeDataField.ID = SummaryDisplayTypeDataFieldID; } break; } pivotGrid.EndUpdate(); pivotGrid.DataBind(); }