static void ApplyFilter(MVCxPivotGrid pivotGrid, PivotGridReportsDemoOptions options) { pivotGrid.BeginUpdate(); ApplyFilter(pivotGrid.Fields["Year"], options.FilterYearIndex, 1995); ApplyFilter(pivotGrid.Fields["Quarter"], options.FilterQuarterIndex, 0); pivotGrid.EndUpdate(); }
public ActionResult CustomActionSampleReportsPartial(PivotGridReportsDemoOptions options) { if (options != null) { Session["ReportOptions"] = options; ViewBag.IsReloadLayout = true; } return(PartialView("SampleReportsPartial", NorthwindDataProvider.GetCustomerReports())); }
static void ChangePivotGridFieldLayout(MVCxPivotGrid pivotGrid, PivotGridReportsDemoOptions options) { pivotGrid.BeginUpdate(); pivotGrid.Fields["Year"].Area = PivotArea.ColumnArea; pivotGrid.Fields["Year"].AreaIndex = 0; pivotGrid.Fields["Quarter"].Area = PivotArea.ColumnArea; pivotGrid.Fields["Quarter"].AreaIndex = 1; pivotGrid.Fields["ProductAmount"].Area = PivotArea.DataArea; pivotGrid.Fields["Customer"].Area = PivotArea.RowArea; pivotGrid.Fields["Customer"].AreaIndex = 0; pivotGrid.Fields["Customer"].SortOrder = options.DemoKind == CustomerReportKind.Top10Customers ? PivotSortOrder.Descending : PivotSortOrder.Ascending; pivotGrid.Fields["Customer"].TopValueCount = 0; pivotGrid.Fields["Customer"].SortBySummaryInfo.FieldName = string.Empty; pivotGrid.Fields["ProductName"].Area = PivotArea.FilterArea; pivotGrid.Fields["ProductName"].SortOrder = options.DemoKind == CustomerReportKind.Top2Products ? PivotSortOrder.Descending : PivotSortOrder.Ascending; pivotGrid.Fields["ProductName"].TopValueCount = 0; pivotGrid.Fields["ProductName"].SortBySummaryInfo.FieldName = string.Empty; pivotGrid.Fields["Customer"].SortOrder = options.DemoKind == CustomerReportKind.Top10Customers ? PivotSortOrder.Descending : PivotSortOrder.Ascending; pivotGrid.Fields["ProductName"].SortOrder = options.DemoKind == CustomerReportKind.Top2Products ? PivotSortOrder.Descending : PivotSortOrder.Ascending; switch (options.DemoKind) { case CustomerReportKind.Customers: break; case CustomerReportKind.Filtered: pivotGrid.Fields["Customer"].Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea; pivotGrid.Fields["ProductName"].Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; break; case CustomerReportKind.Top2Products: pivotGrid.Fields["ProductName"].Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; pivotGrid.Fields["ProductName"].TopValueCount = 2; pivotGrid.Fields["ProductName"].SortBySummaryInfo.FieldName = "ProductAmount"; pivotGrid.Fields["Year"].Area = pivotGrid.Fields["Quarter"].Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea; break; case CustomerReportKind.Top10Customers: pivotGrid.Fields["Customer"].TopValueCount = 10; pivotGrid.Fields["Customer"].SortBySummaryInfo.FieldName = "ProductAmount"; pivotGrid.Fields["Year"].Area = pivotGrid.Fields["Quarter"].Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea; break; } ApplyFilter(pivotGrid, options); pivotGrid.EndUpdate(); }
public static void UpdatePivotGridLayoutForSampleReportsDemo(MVCxPivotGrid pivotGrid, PivotGridReportsDemoOptions options) { ChangePivotGridFieldLayout(pivotGrid, options ?? new PivotGridReportsDemoOptions()); }