corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionsdata.md
Gets or sets the engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[DefaultValue(PivotDataProcessingEngine.Default)]
public virtual PivotDataProcessingEngine DataProcessingEngine { get; set; }
<DefaultValue(PivotDataProcessingEngine.Default)>
Public Overridable Property DataProcessingEngine As PivotDataProcessingEngine
| 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.
|
You can access this nested property as listed below:
| Object Type | Path to DataProcessingEngine |
|---|---|
| PivotGridControl |
.OptionsData .DataProcessingEngine
|
You can use the following properties to change the default engine ( DataProcessingEngine is set to PivotDataProcessingEngine.Default):
See Data Processing Engines for details.
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.
InitializeComponent();
SelectCustomSummaryApproach(pivotGridControl1.OptionsData.DataProcessingEngine);
pivotGridControl1.FieldValueDisplayText += PivotGridControl1_FieldValueDisplayText;
web-forms-pivot-grid-bind-to-sql-data-source/CS/ASPxPivotGrid_RuntimeDataBinding/Default.aspx.cs#L22
ASPxPivotGrid1 = new ASPxPivotGrid();
ASPxPivotGrid1.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized;
winforms-pivot-grid-custom-aggregates/CS/Win_Pivot_CustomAggregates/Form1.cs#L14
pivotGridControl1.OptionsView.ShowRowGrandTotals = false;
pivotGridControl1.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized;
PivotGridField pivotGridField1 = new PivotGridField() {
InitializeComponent()
SelectCustomSummaryApproach(pivotGridControl1.OptionsData.DataProcessingEngine)
AddHandler pivotGridControl1.FieldValueDisplayText, AddressOf PivotGridControl1_FieldValueDisplayText
web-forms-pivot-grid-bind-to-sql-data-source/VB/ASPxPivotGrid_RuntimeDataBinding/Default.aspx.vb#L23
ASPxPivotGrid1 = New ASPxPivotGrid()
ASPxPivotGrid1.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized
' Binds ASPxPivotGrid to the data source.
winforms-pivot-grid-custom-aggregates/VB/Win_Pivot_CustomAggregates/Form1.vb#L15
pivotGridControl1.OptionsView.ShowRowGrandTotals = False
pivotGridControl1.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized
Dim pivotGridField1 As New PivotGridField() With {
See Also