Skip to main content

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