PivotGridOptionsData.DataProcessingEngine Property

Gets or sets the engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v20.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.WindowsDesktop.PivotGrid.Core

Declaration

C#

[DefaultValue(PivotDataProcessingEngine.Default)]
public virtual PivotDataProcessingEngine DataProcessingEngine { get; set; }

VB.NET

<DefaultValue(PivotDataProcessingEngine.Default)>
Public Overridable Property DataProcessingEngine As PivotDataProcessingEngine

Property Value

Type	Default	Description
PivotDataProcessingEngine	**Default**	A PivotDataProcessingEngine enumeration value that specifies an engine used to perform data processing in the pivot grid.

Available values:

Name	Description
Default	A default data processing engine (LegacyOptimized). You can specify the default engine explicitly using the DefaultDataProcessingEngine property exposed by the control.
Legacy	A legacy data processing engine.
LegacyOptimized	A legacy data processing engine that includes optimizations for basic operations.
Optimized	Improves performance and provides an extended set of aggregations and window functions. Allows you to use the Data Binding API for PivotGrid fields. Does not support legacy features and behavior. See the Optimized Calculation Engine article for more information.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to DataProcessingEngine
WinForms Controls	PivotGridControl	.OptionsData .DataProcessingEngine
Reporting	XRPivotGrid	.OptionsData .DataProcessingEngine
ASP.NET MVC Extensions	MVCxPivotGrid	.OptionsData .DataProcessingEngine
	PivotGridSettings	.OptionsData .DataProcessingEngine
ASP.NET Web Forms Controls	ASPxPivotGrid	.OptionsData .DataProcessingEngine

Remarks

You can use the following properties to change the default engine (DataProcessingEngine is set to PivotDataProcessingEngine.Default):

• for PivotGridControl, use the PivotGridControl.DefaultDataProcessingEngine;
• for the ASPxPivotGrid control and corresponding MVC extension, use the ASPxPivotGrid.DefaultDataProcessingEngine.

See Data Processing Engines for details.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DataProcessingEngine property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-pivotgrid--display-the-difference-of-income-and-outlay-in-totals/CS/PivotGridCustomSummaryExample/Form1.cs#L12

InitializeComponent();
SelectCustomSummaryApproach(pivotGridControl1.OptionsData.DataProcessingEngine);
pivotGridControl1.FieldValueDisplayText += PivotGridControl1_FieldValueDisplayText;

pivot-grid-aggr-examples/CS/Pivot-Aggr-Examples/Form1.cs#L26

InitializeComponent();
pivotGridControl1.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized;
// Configure the TreeList control.

VB.NET

winforms-pivotgrid--display-the-difference-of-income-and-outlay-in-totals/VB/PivotGridCustomSummaryExample/Form1.vb#L11

InitializeComponent()
SelectCustomSummaryApproach(pivotGridControl1.OptionsData.DataProcessingEngine)
AddHandler pivotGridControl1.FieldValueDisplayText, AddressOf PivotGridControl1_FieldValueDisplayText

pivot-grid-aggr-examples/VB/Pivot-Aggr-Examples/Form1.vb#L19

InitializeComponent()
pivotGridControl1.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized
' Configure the TreeList control.