Back to Devexpress

PivotGridControl.DataProcessingEngine Property

wpf-devexpress-dot-xpf-dot-pivotgrid-dot-pivotgridcontrol-2310a487.md

latest5.4 KB
Original Source

PivotGridControl.DataProcessingEngine Property

Gets or sets an engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid. This is a dependency property.

Namespace : DevExpress.Xpf.PivotGrid

Assembly : DevExpress.Xpf.PivotGrid.v25.2.dll

NuGet Package : DevExpress.Wpf.PivotGrid

Declaration

csharp
public DataProcessingEngine DataProcessingEngine { get; set; }
vb
Public Property DataProcessingEngine As DataProcessingEngine

Property Value

TypeDescription
DataProcessingEngine

A DataProcessingEngine enumeration value that specifies an engine used to perform data processing in the pivot grid.

|

Available values:

NameDescription
Default

A default data processing engine. You can specify the default engine explicitly using the PivotGridControl.DefaultDataProcessingEngine property.

| | 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.

|

Remarks

If necessary, you can change the engine used by default ( DataProcessingEngine is set to DataProcessingEngine.Default) using the PivotGridControl.DefaultDataProcessingEngine property.

Note

The DataProcessingEngine property is not if effect in server mode and for OLAP data sources.

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.

wpf-pivot-grid-bind-to-an-mdb-database/CS/HowToBindToMDB/MainWindow.xaml#L12

xml
<dxpg:PivotGridControl Name="pivotGridControl1" DataProcessingEngine="Optimized"/>

wpf-pivotgrid-how-to-display-underlying-data-asynchronously/CS/WpfDrillDownDataSourceExample/MainWindow.xaml#L32

xml
CellSelectionChanged="PivotGridControl1_CellSelectionChanged"
DataProcessingEngine="Optimized">
<dxpg:PivotGridControl.Fields>

wpf-pivot-grid-hide-specific-columns-and-row/CS/WpfApp/MainWindow.xaml#L33

xml
Grid.Row="1"
DataProcessingEngine="Optimized"
FieldValueDisplayText="pivotGrid_FieldValueDisplayText"

wpf-pivot-grid-add-custom-field-values-rows-columns-not-present-in-datasource/CS/WpfApplication1/MainWindow.xaml#L16

xml
<dxpg:PivotGridControl x:Name="pivot" CustomFieldValueCells="pivot_CustomFieldValueCells" DataProcessingEngine="Optimized">
    <dxpg:PivotGridControl.Fields>

wpf-pivot-grid-create-field-value-template/CS/HowToCreateFieldValueTemplate/MainWindow.xaml#L19

xml
<Grid>
    <dxpg:PivotGridControl Name="pivotGridControl1" DataProcessingEngine="Optimized">
        <dxpg:PivotGridControl.Fields>

See Also

DefaultDataProcessingEngine

PivotGridControl Class

PivotGridControl Members

DevExpress.Xpf.PivotGrid Namespace