ContextQMD
Back to Devexpress

In-Memory Mode Limitations

corelibraries-403818-devexpress-pivot-grid-core-library-pivot-grid-modes-in-memory-mode-in-memory-mode-limitations.md

latest10.3 KB
Original Source

In-Memory Mode Limitations

  • Dec 01, 2022
  • 2 minutes to read

The following article describes Pivot Grid’s In-Memory mode limitations that depend on the data processing engine.

Note

If you connect the Pivot Grid to the server mode data sources and OLAP cubes, the PivotGridOptionsData.DataProcessingEngine property is ignored because Pivot data processing engines calculate data on the client.

Optimized Mode

The following API are not supported in Optimized mode. The NotSupportedException occurs in Optimized mode for unavailable values, properties, and handled events.

Events

WinFormsWPFASP.NET
PivotGridControl.CustomSummaryPivotGridControl.CustomSummaryASPxPivotGrid.CustomSummary
PivotGridControl.CustomGroupIntervalPivotGridControl.CustomGroupIntervalASPxPivotGrid.CustomGroupInterval
PivotGridControl.CustomUnboundFieldDataPivotGridControl.CustomUnboundFieldDataASPxPivotGrid.CustomUnboundFieldData
PivotGridControl.CustomFieldSortPivotGridControl.CustomFieldSortASPxPivotGrid.CustomFieldSort

Properties

The following properties of the Pivot Grid’s field are not supported:

WinFormsWPFASP.NET
UnboundFieldNameUnboundFieldNameUnboundFieldName
UnboundExpressionModeUnboundExpressionModeUnboundExpressionMode
ExpressionFieldNameExpressionFieldNameExpressionFieldName
FilterColumnNameFilterColumnNameFilterColumnName
RunningTotalRunningTotalRunningTotal
SummaryDisplayTypeSummaryDisplayTypeSummaryDisplayType

The following properties of the Pivot Grid’s field are not supported when its value is set to Custom :

PropertyValue
PivotGridField.SummaryTypePivotSummaryType.Custom
PivotGridField.GroupIntervalPivotGroupInterval.Custom
PivotGridField.SortModePivotSortMode.Custom

The following properties of the Pivot Grid’s field are ignored when you use the Data Binding API:

You can set the PivotGridFieldBase.DataBinding property to null to use them.

You cannot use the CalculationBindingBase descendants to apply summary filter or sorting by summary when Pivot Grid operates with Optimized calculation engine.

Legacy and LegacyOptimized

Legacy and LegacyOptimized modes do not support the Data Binding API.

WinFormsWPFASP.NET
DataSourceColumnBindingDataSourceColumnBindingDataSourceColumnBinding
ExpressionDataBindingExpressionDataBindingExpressionDataBinding
OLAPExpressionBindingOlapExpressionBindingOLAPExpressionBinding
RankBindingRankBindingRankBinding
MovingCalculationBindingMovingCalculationBindingMovingCalculationBinding
DifferenceBindingDifferenceBindingDifferenceBinding
PercentOfTotalBindingPercentOfTotalBindingPercentOfTotalBinding
RunningTotalBindingRunningTotalBindingRunningTotalBinding
WindowExpressionBindingWindowExpressionBindingWindowExpressionBinding

The PivotGridFieldBase.DataBinding property is ignored.

You cannot use the control’s CreateDrillDownDataSource methods to request underlying data in the following events:

WinFormsWPFASP.NET
PivotGridControl.CustomSummary[1]PivotGridControl.CustomSummary[1]ASPxPivotGrid.CustomSummary[1]
PivotGridControl.CustomFieldSortPivotGridControl.CustomFieldSortASPxPivotGrid.CustomFieldSort
PivotGridControl.CustomUnboundFieldDataPivotGridControl.CustomUnboundFieldDataASPxPivotGrid.CustomUnboundFieldData
PivotGridControl.CustomGroupIntervalPivotGridControl.CustomGroupIntervalASPxPivotGrid.CustomGroupInterval

Footnotes

  1. Call the PivotCustomSummaryEventArgs.CreateDrillDownDataSource() method to get the underlying data when you handle the CustomSummary event.