DevExpress.XtraPivotGrid Namespace

Contains classes which implement the main functionality of the PivotGridControl.

Assembly: DevExpress.PivotGrid.v24.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Classes

Name	Description
AsyncOperationResult	The result of the asynchronous operation.
BaseFilter	Serves as base for classes that are filters applied to data displayed in the Pivot Grid.
CrossAreaKey	Represents cross area values, by which you want to sort the pivot grid column or row.
CustomCustomizationFormSortEventArgsBase<T>	The base class for classes that provide arguments for the PivotGridControl.CustomCustomizationFormSort and ASPxPivotGrid.CustomCustomizationFormSort events.
CustomFieldDataEventArgsBase<T>	Serves as a base for classes that provide data for the CustomUnboundFieldData event.
CustomServerModeSortEventArgsBase<T>	Serves as a base for classes that provide data for the CustomServerModeSort event.
DataBindingBase	The base class of the Data Binding API. Specifies the source data for the Pivot Grid fields in Optimized, Server, and OLAP modes.
FieldValueCellBase<T>	Serves as a base for classes that represent field value cells.
FixedFieldValue	A column field value to be pinned.
FixedFieldValueCollection	A collection that contains the field values to be pinned.
FixedFieldValueCondition	A condition used to identify the column to pin.
FixedFieldValueConditionCollection	A collection that contains conditions used to identify the columns to be pinned.
PivotCellEventArgsBase<TField, TData, TCustomTotal>	Provides data for events which are invoked for particular cells.
PivotChartDataSourceRowBase	Serves as the base for classes that represent rows in the datasource passed to the chart control.
PivotCustomFieldValueCellsEventArgsBase<T1, T2>	Serves as a base for classes that provide data for the CustomFieldValueCells event.
PivotCustomGroupIntervalEventArgsBase<T>	Serves as a base for classes that provide data for the CustomGroupInterval event.
PivotDataSource	Serves as the base for classes that represent data sources provided by the pivot grid control (e.g. summary data source, drill-down data source).
PivotDrillDownDataRow	A record in the data source that contains data used to calculate summaries for individual cells.
PivotDrillDownDataSource	Represents a list of the records which are used to calculate summaries for individual cells.
PivotFieldDisplayTextEventArgsBase<T>	Provides data for the FieldValueDisplayText event.
PivotFieldEventArgsBase<T>	Serves as a base for classes that provide data for all field-related events.
PivotFieldValueEventArgsBase<T>	Serves as a base for classes that provide data for the events which are used to customize column and row headers.
PivotFilterBase	Serves as the base for classes that are filters applied to data displayed in the PivotGridControl.
PivotGridAdomdDataSource	An ADOMD.NET datasource.
PivotGridCustomFieldSortEventArgsBase<T>	Serves as a base for classes that provide data for the CustomFieldSort event.
PivotGridCustomTotalBase	Represents the base class for the PivotGridCustomTotal class.
PivotGridCustomTotalCollectionBase	Represents the base class for the PivotGridCustomTotalCollection class.
PivotGridFieldBase	Represents the base class for the PivotGridField class.
PivotGridFieldCollectionBase	Represents the base class for the PivotGridFieldCollection class.
PivotGridFieldFilterValues	Contains filter values for a specific field.
PivotGridFieldOptions	Contains options for a field.
PivotGridFieldSortBySummaryInfo	Contains the settings used to sort the values of a column field or row field by summary values in another row/column.
PivotGridFieldSortCondition	Represents a sort condition used to identify the column/row by whose values the other field values will be sorted.
PivotGridFieldSortConditionCollection	Represent a collection of sort conditions.
PivotGridGroup	Represents an individual group of fields.
PivotGridGroupCollection	Represents a collection of field groups.
PivotGridOptionsBase	Serves as a base for classes that represent the Pivot Grid control’s options.
PivotGridOptionsBehaviorBase	Serves as the base for classes that provide behavior options for the PivotGrid controls.
PivotGridOptionsChartDataSource	Contains options controlling the display of the PivotGrid’s data in a ChartControl.
PivotGridOptionsCustomization	Provides customization options for a PivotGrid control.
PivotGridOptionsData	Provides data specific options for PivotGrid controls.
PivotGridOptionsDataField	Provides the options which control the presentation of data fields in the XtraPivotGrid.
PivotGridOptionsFilterBase	Serves as the base class for classes that represent options affecting data filtering.
PivotGridOptionsLayout	Contains options that specify how a control layout is stored to, and restored from a storage (a stream, XML file or system registry).
PivotGridOptionsOLAP	Provides “OLAP mode”-specific options for a PivotGrid control.
PivotGridOptionsPrint	Provides options which specifies the Pivot Grid layout and appearance when the control is printed or exported in WYSIWYG mode.
PivotGridOptionsSelection	Provides selection options for the control.
PivotGridOptionsViewBase	Serves as the base for classes that provide view options for the PivotGrid controls.
PivotGridPageSettings	Contains print page settings.
PivotGridXmlaDataSource	A datasource used to access OLAP data via XMLA.
PivotGroupFilterValue	Represents a group filter value.
PivotGroupFilterValues	Represents a group filter condition.
PivotGroupFilterValuesCollection	Represents a collection of group filter values.
PivotOLAPKPIMeasures	Contains the names of the OLAP measures that represent values of a particular KPI.
PivotOLAPKPIValue	Represents values of a KPI.
PivotOptionsChangedEventArgs	Provides data for the PivotGridFieldOptions.OptionsChanged event.
PivotOptionsFilterEventArgs	Provides data for the PivotGridOptionsFilterBase.OptionsChanged event.
PivotSummaryDataRow	Represents a summary data source row.
PivotSummaryDataSource	Represents a summary data source.
PivotSummaryFilter	Contains summary filter settings.
PivotSummaryInterval	Contains information about the distribution of summary values within a specific range.
PivotXlsExportOptionsBase	Represents the base class for objects which define the PivotGrid’s export options specific to XLS format.
PivotXlsxExportOptionsBase	Represents the base class for objects which define the PivotGrid’s export options specific to XLSX format.
PrefilterBase

Interfaces

Name	Description
IOLAPMember	When implemented, represents an OLAP member.
IPivotCustomSummaryValue	When implemented by a class, provides the capability to use custom objects as data field underlying values.
IThreadSafeAccessible	Provides thread-safe access to pivot grid data.
IThreadSafeField	Provides thread-safe access to a pivot grid field.
IThreadSafeFieldCollection	Provides thread-safe access to the pivot grid fields collection.
IThreadSafeGroup	Provides thread-safe access to a field group.
IThreadSafeGroupCollection	Provides thread-safe access to the field groups collection.

Delegates

Name	Description
AsyncCompletedHandler	References a method executed after an asynchronous operation is completed.
PivotOptionsChangedEventHandler	Represents a method that will handle the PivotGridFieldOptions.OptionsChanged event.
PivotOptionsFilterEventHandler	Represents a method that will handle the PivotGridOptionsFilterBase.OptionsChanged event.

Enums

Name	Description
AdomdVersion	Lists values that specify the ADOMD.NET version that should be used to communicate with an OLAP server.
AllowHideFieldsType	Lists values that specify when fields can be hidden by end-users.
CalculationDirection	Lists possible calculation directions in a table.
CalculationPartitioningCriteria	Lists values used to specify a partition (frame) in a data table for window calculations.
CopyCollapsedValuesMode	Lists values that specify how to copy collapsed field values to the Clipboard.
CopyMultiSelectionMode	Lists values that specify how to copy cells to the Clipboard when multiple cells are selected.
DataFieldUnboundExpressionMode	Lists values that specify how the unbound expressions for data fields are calculated.
DifferenceTarget	Lists window locations. The difference is calculated between the current value and the value from the specified location.
DifferenceType	Lists the types of differences.
ExportCellType	Lists values that identify the type of the column or row containing a cell in the exported document.
FixedColumnStyle	Lists values that specify whether to pin columns to the left or the right edge.
OLAPDataProvider	Lists values that specify which data provider should be used when binding to an OLAP cube.
PivotArea	Lists the values that specify the areas where the pivot grid fields can be displayed.
PivotChartDataProvideMode	Lists values that specify which data the pivot grid should pass to a bound chart control.
PivotChartDataProvidePriority	Lists values that specify whether the pivot grid should pass columns or rows to a bound chart control when it is impossible to find the lowest-level data.
PivotChartFieldValuesProvideMode	Lists values that specify how the PivotGridControl’s field values are exported to the chart control.
PivotChartItemDataMember	Lists values that specify the type of a chart data member.
PivotChartItemType	Lists values that specify the type of a PivotGridControl’s item to be represented in a ChartControl.
PivotDataArea	Contains values that specify the areas where the data field headers can be displayed.
PivotDataProcessingEngine	Lists values that specify an engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid.
PivotDefaultMemberFields	Lists values that specify for which fields the pivot grid processes only data related to their default members.
PivotExportArea	Lists values that specify the cell location in the exported Excel document.
PivotFieldPropertyName	Lists values that identify properties of fields.
PivotFilterType	Contains the values that specify a field’s filter type in the XtraPivotGrid control.
PivotGridAllowedAreas	Lists the areas within which a field can be positioned.
PivotGridBestFitMode	Contains values that specify which elements are taken into account when calculating the best-fit width for columns.
PivotGridResetOptions	Lists values that specify which options are reset before loading the layout.
PivotGridValueType	Lists values that specify the types of column and row field values.
PivotGroupFilterMode	Lists values that specify the filtering mode used for grouped fields.
PivotGroupInterval	Contains values that specify how the values of a specific column or row field are combined into groups.
PivotKPIGraphic	Lists values that specify the graphic set used to indicate KPI values.
PivotKPIType	Lists KPI types.
PivotOLAPFilterUsingWhereClause	Lists values that specify whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.
PivotRowTotalsLocation	Lists values that specify the location of the row and grand totals.
PivotSortBySummaryOrder	Lists values that specify the sort order applied to a field when sorting by summaries is enabled for it.
PivotSortLocation	Lists values that specify a target UI element whose items are sorted.
PivotSortMode	Lists the values that specify how a field’s data should be sorted.
PivotSortOrder	Lists the values that specify the sort order of pivot grid fields.
PivotSummaryFilterMode	Lists values that specify whether summary filtering should be applied to the last detail level or to the specified one.
PivotSummaryFilterValidity	Lists values that specify whether the specified value range and detail level are valid.
PivotTopValueType	Lists the values that specify how the number of Top Values is determined.
PivotTotalsLocation	Lists values that specify the location of the column totals.
PivotTotalsVisibility	Contains values that specify which summary totals are displayed for a specific column field or row field.
RankType	Lists rank types.
TopValueMode	Lists values that specify how to calculate top n values for a data field.
UnboundExpressionMode	Lists values that specify how the unbound expressions for a specified data field are calculated.