Skip to main content

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.