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

WinForms	WPF	ASP.NET
PivotGridControl.CustomSummary	PivotGridControl.CustomSummary	ASPxPivotGrid.CustomSummary
PivotGridControl.CustomGroupInterval	PivotGridControl.CustomGroupInterval	ASPxPivotGrid.CustomGroupInterval
PivotGridControl.CustomUnboundFieldData	PivotGridControl.CustomUnboundFieldData	ASPxPivotGrid.CustomUnboundFieldData
PivotGridControl.CustomFieldSort	PivotGridControl.CustomFieldSort	ASPxPivotGrid.CustomFieldSort

Properties

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

WinForms	WPF	ASP.NET
UnboundFieldName	UnboundFieldName	UnboundFieldName
UnboundExpressionMode	UnboundExpressionMode	UnboundExpressionMode
ExpressionFieldName	ExpressionFieldName	ExpressionFieldName
FilterColumnName	FilterColumnName	FilterColumnName
RunningTotal	RunningTotal	RunningTotal
SummaryDisplayType	SummaryDisplayType	SummaryDisplayType

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

Property	Value
PivotGridField.SummaryType	PivotSummaryType.Custom
PivotGridField.GroupInterval	PivotGroupInterval.Custom
PivotGridField.SortMode	PivotSortMode.Custom

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

• UnboundExpression
• UnboundType
• FieldName
• GroupInterval
• GroupIntervalNumericRange

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.

WinForms	WPF	ASP.NET
DataSourceColumnBinding	DataSourceColumnBinding	DataSourceColumnBinding
ExpressionDataBinding	ExpressionDataBinding	ExpressionDataBinding
OLAPExpressionBinding	OlapExpressionBinding	OLAPExpressionBinding
RankBinding	RankBinding	RankBinding
MovingCalculationBinding	MovingCalculationBinding	MovingCalculationBinding
DifferenceBinding	DifferenceBinding	DifferenceBinding
PercentOfTotalBinding	PercentOfTotalBinding	PercentOfTotalBinding
RunningTotalBinding	RunningTotalBinding	RunningTotalBinding
WindowExpressionBinding	WindowExpressionBinding	WindowExpressionBinding

The PivotGridFieldBase.DataBinding property is ignored.

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

WinForms	WPF	ASP.NET
PivotGridControl.CustomSummary[1]	PivotGridControl.CustomSummary[1]	ASPxPivotGrid.CustomSummary[1]
PivotGridControl.CustomFieldSort	PivotGridControl.CustomFieldSort	ASPxPivotGrid.CustomFieldSort
PivotGridControl.CustomUnboundFieldData	PivotGridControl.CustomUnboundFieldData	ASPxPivotGrid.CustomUnboundFieldData
PivotGridControl.CustomGroupInterval	PivotGridControl.CustomGroupInterval	ASPxPivotGrid.CustomGroupInterval

Footnotes

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