PivotGridOptionsData Properties

Provides data specific options for PivotGrid controls.

Name	Description
AllowCrossGroupVariation	Gets or sets whether summary variations and running totals are calculated independently within individual groups, or throughout the Pivot Grid.
AutoExpandGroups	Gets or sets whether field values are expanded or collapsed by default.
CaseSensitive	Gets or sets whether data is grouped case-sensitively.
CustomObjectConverter	Gets or sets a converter used to serialize/deserialize arbitrary objects in a custom manner.
DataFieldUnboundExpressionMode	Gets or sets whether unbound expressions for pivot grid’s data fields are calculated based on the data source records or summary values.
DataProcessingEngine	Gets or sets the engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid.
DirectDataAccessInClientMode	Gets or sets whether the calculation engine bypasses the creation of temporary storage for source data.
DrillDownMaxRowCount	Gets or sets the maximum number of rows returned when obtaining underlying data.
FilterByVisibleFieldsOnly	Gets or sets whether to take into account filter conditions of visible filter fields only.
OptimizeSummaryTypeCalculation	Gets or sets whether to use decimal type conversion while calculating data in certain aggregation types.
RetrieveNestedFields	Gets or sets whether to add nested fields when retrieving fields from the bound data source.