Skip to main content

PivotGridOptionsData.DirectDataAccessInClientMode Property

Gets or sets whether the calculation engine bypasses the creation of temporary storage for source data.

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design


public bool DirectDataAccessInClientMode { get; set; }

Property Value

Type Default Description
Boolean false

:True, to not upload source data to temporary storage; otherwise, false.”

Property Paths

You can access this nested property as listed below:

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


The data engine loads data to local in-memory storage. This local storage is optimized for frequent calculations with typed data sets and guarantees data integrity. Some large data sets, however, may require too large a memory footprint (which can, in turn, slow down an application).

When the DirectDataAccessInClientMode option is enabled, the calculation engine does not upload source data to temporary storage. This avoids performance degradation in Client mode when working with large volumes of data (and when frequent re-calculations are unnecessary).


This option is not available in PivotDataProcessingEngine.Legacy mode.

The following code demonstrates how to enable the option:

pivotGridControl1.OptionsData.DirectDataAccessInClientMode = true;
See Also