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