Back to Devexpress

DevExpress.XtraPivotGrid Namespace

corelibraries-devexpress-181432c6.md

latest23.7 KB
Original Source

DevExpress.XtraPivotGrid Namespace

Contains classes which implement the main functionality of the PivotGridControl.

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

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

Classes

NameDescription
AsyncOperationResultThe result of the asynchronous operation.
BaseFilterServes as base for classes that are filters applied to data displayed in the Pivot Grid.
CrossAreaKeyRepresents 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.
DataBindingBaseThe 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.
FixedFieldValueA column field value to be pinned.
FixedFieldValueCollectionA collection that contains the field values to be pinned.
FixedFieldValueConditionA condition used to identify the column to pin.
FixedFieldValueConditionCollectionA 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.
PivotChartDataSourceRowBaseServes 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.
PivotDataSourceServes as the base for classes that represent data sources provided by the pivot grid control (e.g. summary data source, drill-down data source).
PivotDrillDownDataRowA record in the data source that contains data used to calculate summaries for individual cells.
PivotDrillDownDataSourceRepresents 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.
PivotFilterBaseServes as the base for classes that are filters applied to data displayed in the PivotGridControl.
PivotGridAdomdDataSourceAn ADOMD.NET datasource.
PivotGridCustomFieldSortEventArgsBase<T>Serves as a base for classes that provide data for the CustomFieldSort event.
PivotGridCustomTotalBaseRepresents the base class for the PivotGridCustomTotal class.
PivotGridCustomTotalCollectionBaseRepresents the base class for the PivotGridCustomTotalCollection class.
PivotGridFieldBaseRepresents the base class for the PivotGridField class.
PivotGridFieldCollectionBaseRepresents the base class for the PivotGridFieldCollection class.
PivotGridFieldFilterValuesContains filter values for a specific field.
PivotGridFieldOptionsContains options for a field.
PivotGridFieldSortBySummaryInfoContains the settings used to sort the values of a column field or row field by summary values in another row/column.
PivotGridFieldSortConditionRepresents a sort condition used to identify the column/row by whose values the other field values will be sorted.
PivotGridFieldSortConditionCollectionRepresent a collection of sort conditions.
PivotGridGroupRepresents an individual group of fields.
PivotGridGroupCollectionRepresents a collection of field groups.
PivotGridOptionsBaseServes as a base for classes that represent the Pivot Grid control’s options.
PivotGridOptionsBehaviorBaseServes as the base for classes that provide behavior options for the PivotGrid controls.
PivotGridOptionsChartDataSourceContains options controlling the display of the PivotGrid’s data in a ChartControl.
PivotGridOptionsCustomizationProvides customization options for a PivotGrid control.
PivotGridOptionsDataProvides data specific options for PivotGrid controls.
PivotGridOptionsDataFieldProvides the options which control the presentation of data fields in the XtraPivotGrid.
PivotGridOptionsFilterBaseServes as the base class for classes that represent options affecting data filtering.
PivotGridOptionsLayoutContains options that specify how a control layout is stored to, and restored from a storage (a stream, XML file or system registry).
PivotGridOptionsOLAPProvides “OLAP mode”-specific options for a PivotGrid control.
PivotGridOptionsPrintProvides options which specifies the Pivot Grid layout and appearance when the control is printed or exported in WYSIWYG mode.
PivotGridOptionsSelectionProvides selection options for the control.
PivotGridOptionsViewBaseServes as the base for classes that provide view options for the PivotGrid controls.
PivotGridPageSettingsContains print page settings.
PivotGridXmlaDataSourceA datasource used to access OLAP data via XMLA.
PivotGroupFilterValueRepresents a group filter value.
PivotGroupFilterValuesRepresents a group filter condition.
PivotGroupFilterValuesCollectionRepresents a collection of group filter values.
PivotOLAPKPIMeasuresContains the names of the OLAP measures that represent values of a particular KPI.
PivotOLAPKPIValueRepresents values of a KPI.
PivotOptionsChangedEventArgsProvides data for the PivotGridFieldOptions.OptionsChanged event.
PivotOptionsFilterEventArgsProvides data for the PivotGridOptionsFilterBase.OptionsChanged event.
PivotSummaryDataRowRepresents a summary data source row.
PivotSummaryDataSourceRepresents a summary data source.
PivotSummaryFilterContains summary filter settings.
PivotSummaryIntervalContains information about the distribution of summary values within a specific range.
PivotXlsExportOptionsBaseRepresents the base class for objects which define the PivotGrid’s export options specific to XLS format.
PivotXlsxExportOptionsBaseRepresents the base class for objects which define the PivotGrid’s export options specific to XLSX format.
PrefilterBase

Interfaces

NameDescription
IOLAPMemberWhen implemented, represents an OLAP member.
IPivotCustomSummaryValueWhen implemented by a class, provides the capability to use custom objects as data field underlying values.
IThreadSafeAccessibleProvides thread-safe access to pivot grid data.
IThreadSafeFieldProvides thread-safe access to a pivot grid field.
IThreadSafeFieldCollectionProvides thread-safe access to the pivot grid fields collection.
IThreadSafeGroupProvides thread-safe access to a field group.
IThreadSafeGroupCollectionProvides thread-safe access to the field groups collection.

Delegates

NameDescription
AsyncCompletedHandlerReferences a method executed after an asynchronous operation is completed.
PivotOptionsChangedEventHandlerRepresents a method that will handle the PivotGridFieldOptions.OptionsChanged event.
PivotOptionsFilterEventHandlerRepresents a method that will handle the PivotGridOptionsFilterBase.OptionsChanged event.

Enums

NameDescription
AdomdVersionLists values that specify the ADOMD.NET version that should be used to communicate with an OLAP server.
AllowHideFieldsTypeLists values that specify when fields can be hidden by end-users.
CalculationDirectionLists possible calculation directions in a table.
CalculationPartitioningCriteriaLists values used to specify a partition (frame) in a data table for window calculations.
CopyCollapsedValuesModeLists values that specify how to copy collapsed field values to the Clipboard.
CopyMultiSelectionModeLists values that specify how to copy cells to the Clipboard when multiple cells are selected.
DataFieldUnboundExpressionModeLists values that specify how the unbound expressions for data fields are calculated.
DifferenceTargetLists window locations. The difference is calculated between the current value and the value from the specified location.
DifferenceTypeLists the types of differences.
ExportCellTypeLists values that identify the type of the column or row containing a cell in the exported document.
FixedColumnStyleLists values that specify whether to pin columns to the left or the right edge.
OLAPDataProviderLists values that specify which data provider should be used when binding to an OLAP cube.
PivotAreaLists the values that specify the areas where the pivot grid fields can be displayed.
PivotChartDataProvideModeLists values that specify which data the pivot grid should pass to a bound chart control.
PivotChartDataProvidePriorityLists 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.
PivotChartFieldValuesProvideModeLists values that specify how the PivotGridControl’s field values are exported to the chart control.
PivotChartItemDataMemberLists values that specify the type of a chart data member.
PivotChartItemTypeLists values that specify the type of a PivotGridControl’s item to be represented in a ChartControl.
PivotDataAreaContains values that specify the areas where the data field headers can be displayed.
PivotDataProcessingEngineLists values that specify an engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid.
PivotDefaultMemberFieldsLists values that specify for which fields the pivot grid processes only data related to their default members.
PivotExportAreaLists values that specify the cell location in the exported Excel document.
PivotFieldPropertyNameLists values that identify properties of fields.
PivotFilterTypeContains the values that specify a field’s filter type in the XtraPivotGrid control.
PivotGridAllowedAreasLists the areas within which a field can be positioned.
PivotGridBestFitModeContains values that specify which elements are taken into account when calculating the best-fit width for columns.
PivotGridResetOptionsLists values that specify which options are reset before loading the layout.
PivotGridValueTypeLists values that specify the types of column and row field values.
PivotGroupFilterModeLists values that specify the filtering mode used for grouped fields.
PivotGroupIntervalContains values that specify how the values of a specific column or row field are combined into groups.
PivotKPIGraphicLists values that specify the graphic set used to indicate KPI values.
PivotKPITypeLists KPI types.
PivotOLAPFilterUsingWhereClauseLists values that specify whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.
PivotRowTotalsLocationLists values that specify the location of the row and grand totals.
PivotSortBySummaryOrderLists values that specify the sort order applied to a field when sorting by summaries is enabled for it.
PivotSortLocationLists values that specify a target UI element whose items are sorted.
PivotSortModeLists the values that specify how a field’s data should be sorted.
PivotSortOrderLists the values that specify the sort order of pivot grid fields.
PivotSummaryFilterModeLists values that specify whether summary filtering should be applied to the last detail level or to the specified one.
PivotSummaryFilterValidityLists values that specify whether the specified value range and detail level are valid.
PivotTopValueTypeLists the values that specify how the number of Top Values is determined.
PivotTotalsLocationLists values that specify the location of the column totals.
PivotTotalsVisibilityContains values that specify which summary totals are displayed for a specific column field or row field.
RankTypeLists rank types.
TopValueModeLists values that specify how to calculate top n values for a data field.
UnboundExpressionModeLists values that specify how the unbound expressions for a specified data field are calculated.