DevExpress.PivotGrid.v14.1.Core

An appearance object used to print a pivot grid.

Initializes a new instance of the PrintAppearanceObject object with default settings.

Specifies the background color.

A structure, specifying the background color.

Overrides the property to hide it.

A structure.

Specifies the border color.

A structure, specifying the border color.

Gets the default font of the appearance object.

A object, specifying the default font.

Specifies the font used to render the text.

A object, specifying the font used to display element content.

Specifies the foreground color.

A structure, specifying the foreground color.

Specifies the background gradient's direction.

A enumeration value

Overrides the property to hide it.

An object.

Indicates whether or not the property is set.

true if a background color has been assigned; otherwise false.

Indicates whether or not the property is set.

true if a border color has been assigned; otherwise false.

Indicates whether or not the property is set.

true if a font has been assigned; otherwise false.

Indicates whether or not the property is set.

true if a foreground color has been assigned; otherwise false.

Reverts the appearance object's properties to their default values.

Tests whether or not the PrintAppearanceObject instance should be persisted.

true if the object should be persisted; otherwise, false.

Specifies the horizontal alignment of the appearance object's text.

A enumeration value, specifying the horizontal alignment of the text.

Overrides the property to hide it.

A value.

Gets the vertical alignment of the appearance object's text.

A enumeration value, specifying the vertical alignment of the text.

Returns the textual representation of PrintAppearanceObject.

A value.

Specifies the text trimming mode.

A enumeration value.

Specifies whether or not to wrap the text.

true to enable word-wrapping; otherwise false.

Lists values that specify whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.

The WHERE clause is always used when filtering against filter fields in OLAP mode.

The pivot grid automatically selects when to use the WHERE clause in an MDX query.

The WHERE clause is never used when filtering against filter fields in OLAP mode. A subselect clause is used instead.

The WHERE clause is used when the filter condition contains a single field value, either excluded or included into the pivot grid (in OLAP mode). Otherwise, a subselect clause is used.

Lists values that specify the type of a chart data member.

A series point's argument.

A series.

A series point's value.

Lists values that specify the location of the column totals.

Column Totals are displayed to the right of the column field values.

Column Totals are displayed to the left of the column field values.

Lists values that specify how the PivotGridControl's field values are exported to the chart control.

Field value is exported to provide the best representation in a chart.

Field value is always exported as a string.

Field value is exported using its type, when possible.

Represents a cell created when splitting a field value cell.

Initializes a new instance of the FieldValueSplitData class.

The value that will be contained in the new cell. Assigned to the property. An integer value that specifies the number of cells nested in the new cell. This value is assigned to the property.

Gets or sets the number of cells nested in the new cell.

An integer value that specifies the number of cells nested in the new cell.

Gets or sets the value of the new cell.

The value of the new cell.

Represents a read-only collection of data cells.

Initializes a new instance of the ReadOnlyCells class, and adds a single cell to the collection.

A structure that represents the coordinates of the cell to be added to the collection.

Initializes a new instance of the ReadOnlyCells class.

A list of structures that represent the coordinates of cells that should be added to the collection.

Returns whether the collection contains a cell with the specified coordinates.

A structure that represents the coordinates of the cell to locate in the collection. true if the collection contains the specified cell; otherwise, false.

Copies the cells contained within the current collection to the specified list.

A list of structures where the cells should be copied from the current collection.

Gets the number of elements in the collection.

An integer value that specifies the number of elements in the collection.

An empty collection of cells.

[To be supplied]

Returns an enumerator that iterates through the ReadOnlyCells collection.

An object that implements the System.Collections.Generic.IEnumerator interface and represents an enumerator used to iterate through the collection.

Gets whether the collection is empty.

true if the collection is empty; otherwise, false.

Provides indexed access to the collection elements.

An integer value that specifies the zero-based index of the required cell. If it is negative or exceeds the last available index, an exception is raised. A structure that represents the coordinates of the cell with the specified index.

Gets the rectangle that bounds the cells.

A object that specifies the rectangle that bounds the cells.

When implemented, provides the capability to select multiple blocks of cells.

Gets the collection of the selected cells.

A object that represents the read-only collection containing the selected cells.

Selects the specified cells.

An array of structures that specifies the coordinates of the cells that should be selected.

Serves as the base for classes that represent field value cells.

Initializes a new instance of the FieldValueCellBase class.

A DevExpress.XtraPivotGrid.Data.PivotFieldValueItem object.

Gets whether an end-user can expand/collapse the field value.

true if an end-user can expand/collapse the field value; otherwise, false.

Gets the text displayed within the cell.

A that represents the text displayed within the cell.

Gets the index of the last column or row level occupied by the cell.

An integer value that represents the zero-based index of the last column or row level occupied by the cell.

Gets whether the field value is collapsed.

true if the field value is collapsed; otherwise, false.

Gets whether the cell is a column header.

true if the cell is a column header; false if the cell is a row header.

Gets whether the cell is visible.

true if the cell is visible; otherwise, false.

Gets the index of the last nested cell at the last column/row level.

An integer value that specifies the zero-based index of the last nested cell at the last column/row level.

Gets the index of the first nested cell at the last column/row level.

An integer value that specifies the zero-based index of the first nested cell at the last column/row level.

Gets the first column or row level occupied by the cell.

An integer value that represents the zero-based index of the first column or row level occupied by the cell.

Gets the field value represented by the cell.

The field value represented by the cell.

Gets the type of the cell.

A enumeration member that specifies the type of the cell.

Lists values that specify the location of Grand Total rows and columns.

Grand Total columns are displayed to the right of the column field values. Grand Total rows are displayed under the row field values.

Grand Total columns are displayed to the left of the column field values. Grand Total rows are displayed above the row field values.

Serves as the base for classes that provide data for the CustomFieldValueCells event.

Initializes a new instance of the PivotCustomFieldValueCellsEventArgsBase class.

A DevExpress.XtraPivotGrid.Data.PivotVisualItemsBase class descendant.

Gets the number of columns in the pivot grid.

An integer value that specifies the number of columns in the pivot grid.

Returns the number of field value cells in the specified area.

true to return the number of column field value cells; false to return the number of row field value cells. An integer value that represents the number of field value cells in the specified area.

Gets the value of a data cell by its column and row indexes.

An integer value that specifies the zero-based index of the column where the cell resides. An integer value that specifies the zero-based index of the row where the cell resides. The value of the data cell with the specified column and row indexes.

Returns the location of Grand Total columns or rows.

true to return the location of Grand Total columns; false to return the location of Grand Total rows. A enumeration member that specifies the location of Grand Totals.

Returns the number of column or row levels.

true to return the number of column levels; false to return the number of row levels. An integer value that specifies the number of column or row levels.

Gets whether the area where the field value cells reside needs to be redrawn after the event is handled.

true if the area where the field value cells reside needs to be redrawn after the event is handled; otherwise, false.

Removes the specified field value cell.

A descendant that represents the field value cell to remove. true if the specified cell has been found and removed; false if the specified cell has not been found.

Gets the number of rows in the pivot grid.

An integer value that specifies the number of rows in the pivot grid.

Sets the location of Grand Total columns or rows to the specified value.

true to set the location of Grand Total columns; false to set the location of Grand Total rows. A enumeration member that specifies the location of Grand Totals.

Lists values that identify properties of fields.

Identifies the property.

An ADOMD.NET datasource.

Initializes a new instance of the PivotGridAdomdDataSource class.

Initializes a new instance of the PivotGridAdomdDataSource class, using the specified ADOMD.NET version.

An enumeration member specifying the ADOMD.NET version to use.

Specifies a connection string to a cube in an MS Analysis Services database.

A connection string.

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).

Disposes of the data source.

For internal use.

When overridden in descendant classes, returns the index of the specified row.

A data source row. Always -1.

When overridden in descendant classes, gets or sets whether to update the data source when the pivot grid data changes.

Always false.

Occurs after the data source has been changed.

When overridden in descendant classes, gets the number of rows in the data source.

Always 0.

Represent a collection of sort conditions.

Initializes a new instance of the PivotGridFieldSortConditionCollection class.

A descendant that represents the field whose values will be sorted by the column or row represented by the current PivotGridFieldSortConditionCollection.

Adds the specified sort conditions to the collection.

A list of objects representing sort conditions that should be added to the current collection.

Occurs after the collection has been changed.

Returns whether the collection contains a sort condition that corresponds to the specified field.

A descendant that represents the pivot grid field. true if the collection contains a sort condition that corresponds to the specified field; otherwise, false.

For internal use.

Returns the index of the sort condition that corresponds to the specified field.

A descendant that represents the pivot grid field. An integer value that specifies the zero-based index of the sort condition that corresponds to the specified field.

Gets the sort condition by the corresponding field.

A descendant that represents the pivot grid field. A object specifying the sort condition that corresponds to the specified field.

Provides data for the event.

Gets whether the pivot grid will be redrawn after the event is raised.

true if the pivot grid will be redrawn after the event is raised; otherwise, false.

Represents a method that will handle the event.

The event source. A object that contains event data.

Serves as the base class for classes that represent options affecting data filtering.

Initializes a new instance of the PivotGridOptionsFilterBase class.

The event handler.

Initializes a new instance of the PivotGridOptionsFilterBase class. For internal use.

The event handler. An object that implements the IViewBagOwner interface. The string value.

Gets or sets the filtering mode used for field groups.

A enumeration member that specifies the filtering mode used for field groups.

Occurs after any option has been changed.

Gets or sets whether filter items that cannot be displayed because of filtering applied to other fields should be hidden.

true to hide filter items that cannot be displayed because of filtering applied to other fields; otherwise, false.

Provides print options for the PivotGrid controls.

Initializes a new instance of the PivotGridOptionsPrint class.

A delegate that will receive change notifications.

Copies all the settings from the options object passed as the parameter to the current object.

A descendant whose settings are assigned to the current object.

Gets or sets the distance between the values of column fields when the pivot grid is printed.

An integer value which specifies the distance between column field values, in pixels, when the pivot grid is printed.

Gets or sets the vertical distance between filter field headers headers and the main part of the printed pivot grid.

An integer value which specifies the vertical distance between filter field headers and the main part of the printed pivot grid.

Indicates whether the headers located within the specified area are printed.

A enumeration value which specifies the area in which the pivot grid fields can be displayed. A enumeration value which specifies whether the headers located within the specified area are printed.

Returns whether the values of outer column or row fields are merged when a pivot grid is printed.

true to check whether outer column field values will be merged; false to check whether outer row field values will be merged. true if field values will be merged; otherwise, false.

Gets or sets whether the values of outer column fields are merged when a pivot grid is printed.

true if the values of outer column fields are merged; otherwise, false.

Gets or sets whether the values of outer row fields are merged when a pivot grid is printed.

true if the values of outer row fields are merged; otherwise, false.

Provides access to the page settings to print the PivotGrid control.

A object representing PivotGrid control's page settings.

Gets or sets whether column field headers are printed.

A enumeration value which specifies whether column field headers are printed.

Gets or sets whether data field headers are printed.

A enumeration value which specifies whether data field headers are printed.

Gets or sets whether filter field headers are printed.

A DevExpress.Utils.DefaultBoolean enumeration value which specifies whether filter field headers are printed.

Gets or sets whether to print column headers on every page.

true to print column headers on every page; otherwise, false.

Gets or sets whether horizontal grid lines are printed.

A enumeration value which specifies whether horizontal grid lines are printed.

Gets or sets whether row field headers are printed.

A enumeration value which specifies whether row field headers are printed.

Gets or sets whether unused filter fields are printed/exported.

true if unused filter fields are printed/exported; otherwise, false.

Gets or sets whether vertical grid lines are printed.

A enumeration value which specifies whether vertical grid lines are printed.

Gets or sets the distance between row field values when the pivot grid is printed.

An integer value which specifies the distance between row field values, in pixels, when the pivot grid is printed.

Gets or sets whether print appearances are used when the pivot grid is printed.

true to use print appearances; false to use the pivot grid's appearances.

Gets or sets whether a cell is allowed to be split across pages.

A enumeration value.

Contains the names of the OLAP measures that represent values of a particular KPI.

Initializes a new instance of the PivotOLAPKPIMeasures class.

A specifying the name of the KPI. This value is assigned to the property. A specifying the name of the measure that stores the KPI's actually achieved value. This value is assigned to the property. A specifying the name of the measure that stores the KPI's goal value. This value is assigned to the property. A specifying the name of the measure that stores the KPI's status value. This value is assigned to the property. A specifying the name of the measure that stores the KPI's trend value. This value is assigned to the property. A specifying the name of the measure that stores the KPI's weight value. This value is assigned to the property.

Initializes a new instance of the PivotOLAPKPIMeasures class.

A binary stream reader used to load the object's data from a binary stream.

For internal use.

Gets the name of the measure that stores the KPI's goal values.

A that specifies the name of the measure that stores the KPI's goal values.

Gets the name of the KPI.

A that specifies the name of the KPI.

For internal use.

Gets the name of the measure that stores the KPI's status values.

A that specifies the name of the measure that stores the KPI's status values.

Returns the textual representation of the current object.

A that specifies the textual representation of the current object.

Gets the name of the measure that stores the KPI's trend values.

A that specifies the name of the measure that stores the KPI's trend values.

Gets the name of the measure that stores the KPI's actually achieved values.

A that specifies the name of the measure that stores the KPI's actually achieved values.

Gets the name of the measure that stores the KPI's weight values.

A that specifies the name of the measure that stores the KPI's weight values.

Represents values of a KPI.

Initializes a new instance of the PivotOLAPKPIValue class.

The KPI's actually achieved value. This value is assigned to the property. The KPI's goal value. This value is assigned to the property. An integer value (1, 0 or -1) that specifies the KPI's status. This value is assigned to the property. An integer value (1, 0 or -1) that specifies the KPI's trend. This value is assigned to the property. A value that specifies the KPI's weight. This value is assigned to the property.

Gets the KPI's goal value.

The KPI's goal value.

Gets the KPI's status value.

An integer value (1, 0 or -1) that specifies the KPI's status.

Gets the KPI's trend value.

An integer value (1, 0 or -1) that specifies the KPI's trend.

Gets the KPI's actually achieved value.

The KPI's actually achieved value.

Gets the KPI's weight value.

A value that specifies the KPI's weight.

Represents a collection of filter items. For internal use.

Initializes a new instance of the PivotGridFilterItems class. For internal use.

For internal use.

Contains options that specify how summary values are displayed within cells ("as is" or adjusted using a specific predefined algorithm).

The absolute variance between the current value and the previously calculated value for the current field is displayed in the cell.

The calculated summary values are displayed "as is".

An index value that reflects the summary value's importance in its row and column context. This value is calculated as follows: ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))

For data cells, the percentage of the column's total value is displayed; for total cells, the percentage of the column's grand total value is displayed.

Percent of the summary in the Column Grand Total value.

Percent of the summary in the Grand Total value.

For data cells, the percentage of the row's total value is displayed; for total cells, the percentage of the row's grand total value is displayed.

Percent of the summary in the Row Grand Total value.

The percentage variance between the current value and the previously calculated value for the current field is displayed in the cell.

The summary value's rank in its column, with the largest value in the column as 1, and each smaller value assigned a higher rank.

The summary value's rank in its column, with the smallest value in the column as 1, and each larger value assigned a higher rank.

The summary value's rank in its row, with the largest value in the row as 1, and each smaller value assigned a higher rank.

The summary value's rank in its row, with the smallest value in the row as 1, and each larger value assigned a higher rank.

Represents a filter item.

Initializes a new instance of the PivotGridFilterItem class.

A field value that corresponds to the current filter value. This value is assigned to the property. A that specifies the item's caption. This value is assigned to the property. true if the item should be checked; false if it should be unchecked; null if its check state should be indeterminate. This value is assigned to the property.

Initializes a new instance of the PivotGridFilterItem class.

Gets whether the filter item represents the blank field value.

true if the filter item represents the blank field value; otherwise, false.

Gets or sets the check state of the filter item.

true if the item is checked; false if it is unchecked; null if its check state is indeterminate.

Gets or sets whether the filter item is visible.

true if the filter item is visible; otherwise, false.

Gets the hierarchy level of the filter item when overridden in descendant classes.

Always returns 0.

Gets or sets the caption of the filter item.

A that specifies the caption of the filter item.

Returns the textual representation of the filter item.

A that specifies the textual representation of the filter item.

Gets or sets the field value represented by the filter item.

The field value represented by the filter item.

Represents a sort condition used to identify the column/row by whose values the other field values will be sorted.

Initializes a new instance of the PivotGridFieldSortCondition class.

A descendant that represents the field to which the condition corresponds. This value is assigned to the property. An object that specifies the field value represented by the condition. This value is assigned to the property. A that represents the unique name of the corresponding OLAP member. This value is assigned to the property.

Initializes a new instance of the PivotGridFieldSortCondition class with default settings.

Initializes a new instance of the PivotGridFieldSortCondition class.

A PivotFieldValueItem object.

Occurs after one of the current object's properties has been changed.

Gets or sets the field to which the condition corresponds.

A object that represents the field to which the condition corresponds.

For internal use.

Returns whether the specified condition matches the current one.

A PivotGridFieldSortCondition object that specifies the condition that should be compared with the current one. A System.Comparison descendant that represents the method used to compare conditions. true if the conditions represent OLAP members; otherwise, false. true if the specified condition matches the current one; otherwise, false.

Gets or sets the unique name of the corresponding OLAP member.

A that specifies the unique name of the corresponding OLAP member.

Gets or sets the field value represented by the condition.

An object that specifies the field value represented by the condition.

Represents a collection of group filter values.

Initializes a new instance of the PivotGroupFilterValuesCollection class.

An object implementing the DevExpress.XtraPivotGrid.IPivotGroupFilterValueParent interface that represents the owner of the collection (e.g., a or object).

Adds the specified filter value to the collection.

A object representing the filter value that should be added to the collection.

Creates a filter value that corresponds to the specified field value, and adds it to the collection.

The field value for which the filter value should be created and added to the collection. A object representing the filter value that has been added to the collection.

For internal use.

Clears the collection.

For internal use.

Copies the specified collection to the other PivotGroupFilterValuesCollection object.

A object that specifies the collection that should be copied to the dest collection. A object that specifies the collection to which the src collection should be copied.

Returns whether the filter value that corresponds to the specified field value is contained in the collection.

An object representing the field value. true if the filter value that corresponds to the specified field value is contained in the collection; otherwise, false.

Gets the number of filter values in the collection.

An integer value representing the number of filter values in the collection.

For internal use.

Returns all group filter values that meet the specified condition.

A System.Predicate that specifies the condition used to select the required collection elements. A list of objects that represent the group filter values that meet the specified condition.

Gets whether the collection is empty.

true if the collection is empty; otherwise, false.

Returns whether the specified collections match.

The first filter values collection to be compared. The second filter values collection to be compared. true if the specified collections match; otherwise, false.

Gets or sets the filter value by the corresponding field value.

The field value for which the corresponding filter value should be specified. A object representing the filter value that corresponds to the specified field value.

For internal use.

Removes the specified filter value from the collection.

A object representing the filter value that should be removed from the collection.

Removes the filter value that corresponds to the specified field value.

An object representing the field value to which the filter value that should be removed corresponds.

For internal use.

Returns the collection elements as a list.

A list of group filter values.

Returns the collection elements number as text.

A that contains the number of filter values in the collection.

Represents a group filter condition.

Initializes a new instance of the PivotGroupFilterValues class.

A object, representing the owner field group. This value is assigned to the property.

Initializes a new instance of the PivotGroupFilterValues class.

A object that represents the owner field group. This value is assigned to the property. A enumeration member that specifies the filter type. This value is assigned to the property.

For internal use.

Initializes the current PivotGroupFilterValues object with the specified one.

A PivotGroupFilterValues object that will be used to initialize the current object.

Locks the PivotGroupFilterValues object by disallowing visual updates until the EndUpdate or CancelUpdate method is called.

Unlocks the PivotGroupFilterValues object after it has been locked by the BeginUpdate method, without causing an immediate visual update.

Returns a copy of the current object.

A PivotGroupFilterValues object that represents the copy of the current object.

Returns whether the current filter condition allows processing the specified group value.

The field value. Parent values of the field value specified by the value parameter. true if the current filter condition allows processing the specified group value with all its child values; null (Nothing in Visual Basic) if some of the child values are processed, while others are not; false if the specified group value is not processed.

For internal use.

Gets the number of filter values.

An integer value specifying the number of filter values.

For internal use.

Unlocks the PivotGroupFilterValues object after a call to the BeginUpdate method and causes an immediate visual update.

Gets or sets the filter type.

A enumeration member that specifies the filter type.

Returns a filter value that corresponds to the specified group value.

An array of field values that identify the group value. A object, which is a filter value that corresponds to the specified group value; null (Nothing in Visual Basic) if the required filter value has not been found.

Gets the owner field group.

A object that represents the owner group.

Gets whether the filter condition is not empty.

true if the filter condition is not empty; otherwise, false.

Gets whether the filter condition is empty.

true if the filter condition is empty; otherwise, false.

Returns whether the current PivotGroupFilterValues object matches the specified one.

A PivotGroupFilterValues object that should be compared with the current one. true if the current PivotGroupFilterValues object matches the specified one; otherwise, false.

Clears the filter values collection.

For internal use.

Adds the specified filter values to the collection, and sets the filter type to the specified value.

A object that specifies the collection of group filter values. This object is assigned to the property. A object that specifies the filter type. This value is assigned to the property. true to allow raising OnChanged events; otherwise, false. true if the specified values differ from the current ones; otherwise, false.

For internal use.

Gets the collection of filter values.

A object representing the collection of filter values.

Represents a group filter value.

Initializes a new instance of the PivotGroupFilterValue class.

An object that represents the corresponding field value. This value is assigned to the DevExpress.XtraPivotGrid.PivotFilterValue.Value property.

Gets the collection of the filter value's child values.

A object representing the collection of child values.

Clears the child values collection.

Gets the field to which the filter value corresponds.

A descendant, representing the field to which the filter value corresponds.

Gets whether the field to which the filter value corresponds is the last in the group.

true if the field to which the filter value corresponds is the last in the group; otherwise, false.

Gets the hierarchy level of the field to which the filter value corresponds.

An integer value representing the hierarchy level of the field to which the filter value corresponds.

Lists values that specify which options are reset before loading the layout.

All options are reset.

No options are reset.

Behavior options are reset.

Options related to the Chart control integration are reset.

Customization options are reset.

Data options are reset.

Options related to the presentation of data fields are reset.

Filter drop-down options are reset.

Hint options are reset.

Reset options that specify how a control layout is stored to, and restored from a storage.

Loading Panel options are reset.

Menu options are reset.

OLAP options are reset.

Print options are reset.

Selection options are reset.

Lists values that specify how the unbound expressions for data fields are calculated.

An unbound expression is calculated against each data source record, and then the resulting values are summarized.

An unbound expression is calculated against summary values.

Lists values corresponding to strings that can be localized.

The alternative text for the image corresponding to the 'Areas Section Only (1 by 4)' layout, displayed in the Customization Form Layout menu. Default value: [Bottom Panel Only 1 by 4 Layout]

The alternative text for the image corresponding to the 'Areas Section Only (2 by 2)' layout, displayed in the Customization Form Layout menu. Default value: [Bottom Panel Only 2 by 2 Layout]

The alternative text for the collapse button. Default value: [Collapse]

The alternative text for the image displayed near the caption of the Column Area Headers section in the Customization Form. Default value: [Column Area Headers]

The alternative text for the image displayed near the caption of the Data Area Headers section in the Customization Form. Default value: [Data Area Headers]

The alternative text for the image displayed when a field is about to be hidden via drag-and-drop. Default value: Hide

The alternative text for the expand button. Default value: [Expand]

The alternative text for the image displayed near the caption of the Hidden Headers section in the Customization Form. Default value: [Hidden Field's Headers]

The alternative text for the image displayed near the caption of the Filter Area Headers section in the Customization Form. Default value: [Filter Area Headers]

The alternative text for the filter button used when the field values are not filtered. Default value: [Filter]

The alternative text for the filter button used when the field values are filtered. Default value: [Filtered]

The alternative text for the filter drop-down's size grip. Default value: [Resize]

The alternative text for the image displayed on the Layout button in the Customization Form. Default value: [Layout Button]

The alternative text for the image displayed near the caption of the Row Area Headers section in the Customization Form. Default value: [Row Area Headers]

The alternative text for the ascending sorting image. Default value: (Ascending)

The alternative text for the descending sorting image. Default value: (Descending)

The alternative text for the image corresponding to the 'Fields Section and Areas Section Stacked' layout, displayed in the Customization Form Layout menu. Default value: [Stacked Default Layout]

The alternative text for the image corresponding to the 'Fields Section and Areas Section Side-By-Side' layout, displayed in the Customization Form Layout menu. Default value: [Stacked Side By Side Layout]

The alternative text for the image corresponding to the 'Fields Section Only' layout, displayed in the Customization Form Layout menu. Default value: [Top Panel Only Layout]

The text displayed within a cell when an error occurs (the cell's value is ). Default value: Error

The text that represents the column area (displayed within the Customization Form). Default value: Column Area

The text displayed within the Column Area when it contains no field headers. Default value: Drop Column Fields Here

The caption of the 'Add To' button displayed within the Customization Form. Default value: Add To

The text displayed above the Hidden Fields section in the Excel-style Customization Form when visible fields are included in it. Default value: Choose fields to add to the report:

The text that represents the Customization Form's 'Area Section Only (1 by 4)' layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Areas Section Only (1 by 4)

The text that represents the Customization Form's 'Areas Section Only (2 by 2)' layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Areas Section Only (2 by 2)

The caption of the Customization Form. Default value: PivotGrid Field List

The caption of the check box in the Customization Form that allows you to perform delayed layout updates. Default value: Defer Layout Update

The text displayed within the Customization Form above the hidden fields list. Default value: Hidden Fields

The text displayed above the areas section in the Customization Form. Default value: Drag fields between areas below:

The text displayed within the Customization Form Layout button's tooltip. Default value: Customization Form Layout

The text displayed within the Customization Form's field list when it is empty. Default value: Drag a field here to customize layout

The text that represents the Customization Form's 'Fields Section and Areas Section Stacked' layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Fields Section and Areas Section Stacked

The text that represents the Customization Form's 'Fields Section and Areas Section Side-By-Side' layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Fields Section and Areas Section Side-By-Side

The text displayed above the Customization Form's field list. Default value: Drag Items to the PivotGrid

The text that represents the Customization Form's 'Fields Section Only' layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Fields Section Only

The caption of the Customization Form's update button. Default value: Update

The text that represents the data area (displayed within the Customization Form). Default value: Data Area

The text displayed within the data field header. Default value: Data

The text displayed within the Data Header Area when it contains no field headers. Default value: Drop Data Items Here

Default value: Q{0}

The error message which is displayed when a drilldown dataset cannot be retrieved. Default value: Error retrieving drilldown dataset.

The caption of the button displayed within the Prefilter Panel and used to edit the Prefilter. Default value: Edit Prefilter

The text that represents the filter area (displayed within the Customization Form). Default value: Filter Area

The caption of the blank item in the group filter drop-down. Default value: (Blank)

The caption of the Cancel button displayed within the filter dropdown. Default value: Cancel

The text displayed within the Filter Header Area when it contains no field headers. Default value: Drop Filter Fields Here

The caption of the filter dropdown's popup menu item used to invert the selection. Default value: Invert Filter

The caption of the OK button displayed within the filter dropdown. Default value: OK

The caption of the filter dropdown list item used to show all field values. Default value: (Show All)

The caption of the filter dropdown list item used to show blank values. Default value: (Show Blanks)

The caption of grand total columns and rows. Default value: Grand Total

The error message which is displayed when a drill-through is performed while multiple items are selected in the report filter field. Default value: Show Details command cannot be executed when multiple items are selected in a report filter field. Select a single item for each field in the report filter area before performing a drill-through.

The caption of the 'KPIs' tree item displayed in the field section of the Customization Form in the OLAP mode. Default value: KPIs

The caption of the 'Goal' tree item (the KPI goal value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Goal

The caption of the 'Status' tree item (the KPI status value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Status

The caption of the 'Trend' tree item (the KPI trend value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Trend

The caption of the 'Value' tree item (the KPI actually achieved value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Value

The caption of the 'Weight' tree item (the KPI weight value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Weight

The caption of the 'measures' tree item displayed in the field section of the Customization Form in the OLAP mode. Default value: Measures

The message that appears if no OLE DB provider can be found on the system when binding the pivot grid to an OLAP data source. Default value: In order to use the PivotGrid OLAP functionality, you should have a MS OLAP OleDb provider installed on your system.\r\nYou can download it here:

The caption of the field header's context menu item used to clear the currently applied sorting. Default value: Clear Sorting

The name of the field value's context menu item used to collapse the field value. Default value: Collapse

The name of the field value's context menu item used to collapse all values of the field. Default value: Collapse All

The name of the field value's context menu item used to expand the field value. Default value: Expand

The name of the field value's context menu item used to expand all values of the field. Default value: Expand All

The caption of the field header's context menu item which contains subitems used to reorder fields. Default value: Order

The caption of the field header's context menu item used to hide the field. Default value: Hide

The caption of the context menu item used to hide the Customization Form. Default value: Hide Field List

The caption of the context menu item used to hide the Prefilter. Default value: Hide Prefilter

The caption of a data field header context menu item that opens a submenu used to choose KPI graphics. Default value: KPI Graphics

The caption of the context menu item that identifies the Cylinder KPI graphics. Default value: Cylinder

The caption of the context menu item that identifies the Faces KPI graphics. Default value: Faces

The caption of the context menu item that identifies the Gauge KPI graphics. Default value: Gauge

The caption of the context menu item that is used to disable KPI graphics. Default value: None

The caption of the context menu item that identifies the Reversed Cylinder KPI graphics. Default value: Reversed Cylinder

The caption of the context menu item that identifies the Reversed Gauge KPI graphics. Default value: Reversed Gauge

The caption of the context menu item that identifies the Reversed Status Arrow KPI graphics. Default value: Reversed Status Arrow

The caption of the context menu item that identifies the Reversed Thermometer KPI graphics. Default value: Reversed Thermometer

The caption of the context menu item that identifies the Road Signs KPI graphics. Default value: Road Signs

The caption of the context menu item that identifies server-defined KPI graphics. Default value: Server Defined

The caption of the context menu item that identifies the Shapes KPI graphics. Default value: Shapes

The caption of the context menu item that identifies the Standard Arrow KPI graphics. Default value: Standard Arrow

The caption of the context menu item that identifies the Status Arrow KPI graphics. Default value: Status Arrow

The caption of the context menu item that identifies the Thermometer KPI graphics. Default value: Thermometer

The caption of the context menu item that identifies the Traffic Lights KPI graphics. Default value: Traffic Lights

The caption of the context menu item that identifies the Variance Arrow KPI graphics. Default value: Variance Arrow

The caption of the field header's context menu item used to move the field to the first position in its area. Default value: Move to Beginning

The caption of the field header's context menu item used to move the field to the last position in its area. Default value: Move to End

The caption of the field header's context menu item used to move the field left. Default value: Move to Left

The caption of the field header's context menu item used to move the field right. Default value: Move to Right

The caption of the context menu item used to refresh the pivot grid's data. Default value: Reload Data

The name of the field value's context menu item used to remove sorting by column. Default value: Remove All Sorting

The caption of the field value's context menu item used to invoke the Expression Editor. Default value: Expression Editor...

The caption of the context menu item used to invoke the Customization Form. Default value: Show Field List

The caption of the context menu item used to invoke the Prefilter. Default value: Show Prefilter

The caption of the field header's context menu item used to sort the field values in ascending order. Default value: Sort A-Z

The caption of the field header's context menu item used to sort the field values in descending order. Default value: Sort Z-A

The caption of the column field value's context menu item used to sort the other field values by this column. Default value: Sort "{0}" by This Column

The caption of the row field value's context menu item used to sort the other field values by this row. Default value: Sort "{0}" by This Row

The caption of the Prefilter form. Default value: PivotGrid Prefilter

The text displayed in the Prefilter Panel if the Prefilter expression is invalid. Default value: An error occurs in the Prefilter criteria. Please detect invalid property captions inside the criteria operands and correct or remove them.

If you specify an invalid field name in a Prefilter expression, this string will be displayed in the Prefilter window instead of that field name. Default value: (invalid property)

The caption of the Print Designer dialog. Default value: Print Designer

The caption of the default options category in the Print Designer dialog. Default value: Default

The caption of the Print Designer options category which contains options used to specify how field values are printed. Default value: Field Values

The caption of the Print Designer options category which contains options used to specify how field headers are printed. Default value: Headers

The caption of the Print Designer options category which contains options used to specify how cell borders are printed. Default value: Lines

The caption of the Print Designer dialog option used to specify whether headers of column fields are printed. Default value: Column Headers

The caption of the Print Designer dialog option used to specify whether headers of data fields are printed. Default value: Data Headers

The caption of the Print Designer dialog option used to specify whether headers of filter fields are printed. Default value: Filter Headers

The caption of the Print Designer dialog option used to specify whether headers are printed on every page. Default value: Headers On Every Page

The caption of the Print Designer dialog option used to specify whether horizontal cell borders are printed. Default value: Horizontal Lines

The caption of the Print Designer dialog option used to specify whether cells that display the same column field value are merged. Default value: Merge Column Field Values

The caption of the Print Designer dialog option used to specify whether cells that display the same row field value are merged. Default value: Merge Row Field Values

The caption of the Print Designer dialog page that contains options used to specify the printing behavior. Default value: Behavior

The caption of the Print Designer dialog page that contains general printing options. Default value: Options

The caption of the Print Designer dialog option used to specify whether headers of row fields are printed. Default value: Row Headers

The caption of the Print Designer dialog option used to specify whether unused filter fields are printed. Default value: Unused Filter Fields

The caption of the Print Designer dialog option used to specify whether print appearances are used when the pivot grid is printed. Default value: Use Print Appearance

The caption of the Print Designer dialog option used to specify whether vertical cell borders are printed. Default value: Vertical Lines

The text that represents the row area (displayed within the Customization Form). Default value: Row Area

The text displayed within the Row Header Area when it contains no field headers. Default value: Drop Row Fields Here

The text displayed within the Search Box in the Group Filter popup when the box is empty. Default value: Search

The text of the tooltip displayed for KPI values representing a bad progress state. Default value: Bad

The text of the tooltip displayed for KPI values representing a good progress state. Default value: Good

The text of the tooltip displayed for KPI values representing a neutral progress state. Default value: Neutral

The text displayed within the headers of average summary data fields. Default value: Average

The text displayed within the headers of count summary data fields. Default value: Count

The text displayed within the headers of data fields with manually calculated summary values. Default value: Custom

The caption of a check box that enables end-users to select an aggregation level to which summary filtering should be applied. Default value: Apply to specific level

The caption of a button that resets the summary filter. Default value: Clear

The caption of a combo box used to select a column field that identifies an aggregation level to which summary filtering is applied. Default value: Column field:

The horizontal axis label of the summary distribution diagram displayed in summary filter popup windows. Default value: Values

The description for a legend item that identifies hidden summary values. Shown in the legend of the summary distribution diagram displayed within summary filter popup windows. Default value: Hidden

The description for a legend item that identifies visible summary values. Shown in the legend of the summary distribution diagram displayed within summary filter popup windows. Default value: Visible

The description displayed above a constant line that indicates the maximum number of summary values that fall into a single subrange. This constant line is shown in a summary distribution diagram displayed within summary filter popup windows. Default value: Max Count

The description displayed above a constant line that indicates the maximum number of visible summary values that fall into a single subrange. This constant line is shown in a summary distribution diagram displayed within summary filter popup windows. Default value: Max Visible Count

The text displayed on top of the summary filter popup window before the text editor used to specify the minimum of the visible values range. Default value: Show values from

The text displayed on top of the summary filter popup window, before the text editor used to specify the maximum of the visible values range. Default value: to

The caption of a combo box used to select a row field that identifies an aggregation level to which summary filtering is applied. Default value: Row field:

The text displayed within the headers of maximum summary data fields. Default value: Max

The text displayed within the headers of minimum summary data fields. Default value: Min

The text displayed within the headers of standard deviation of a population subset summary data fields. Default value: StdDev

The text displayed within the headers of standard deviation of the whole population summary data fields. Default value: StdDevp

The text displayed within the headers of sum summary data fields. Default value: Sum

The text displayed within the headers of variance of a population subset summary data fields. Default value: Var

The text displayed within the headers of variance of the whole population summary data fields. Default value: Varp

The text displayed within the header of the 'Others' row. Default value: Others

The text displayed after the field name within the grand total column/row header, if a specific caption for grand total headers has not been specified. Default value: Total

A pattern used to format headers of automatic total summary columns/rows. Default value: {0} Total Where {0} - the field value

A pattern used to format headers of average total summary columns/rows. Default value: {0} Average Where {0} - the field value

A pattern used to format headers of count total summary columns/rows. Default value: {0} Count Where {0} - the field value

A pattern used to format headers of data fields with manually calculated summary values. Default value: {0} Custom Where {0} - the field value

A pattern used to format headers of maximum total summary columns/rows. Default value: {0} Max Where {0} - the field value

A pattern used to format headers of minimum total summary columns/rows. Default value: {0} Min Where {0} - the field value

A pattern used to format headers of standard deviation of a population subset total summary columns/rows. Default value: {0} StdDev Where {0} - the field value

A pattern used to format headers of standard deviation of the whole population total summary columns/rows. Default value: {0} StdDevp Where {0} - the field value

A pattern used to format headers of sum total summary columns/rows. Default value: {0} Sum Where {0} - the field value

A pattern used to format headers of variance of a population subset total summary columns/rows. Default value: {0} Var Where {0} - the field value

A pattern used to format headers of variance of the whole population total summary columns/rows. Default value: {0} Varp Where {0} - the field value

The text of the tooltip displayed for KPI values representing a descending trend. Default value: Going Down

The text of the tooltip displayed for KPI values representing an ascending trend. Default value: Going Up

The text of the tooltip displayed for KPI values representing a horizontal trend. Default value: No Change

The text displayed within a field value cell when an error occurs. Default value: Error

Provides localized strings for the PivotGrid's user interface elements.

Initializes a new instance of the PivotGridLocalizer class with default settings.

Gets or sets a localizer object providing localization of the PivotGrid's user interface at runtime.

An descendant, used to localize the user interface at runtime.

Returns an object representing resources based on the thread's language and regional settings (culture).

An object representing resources based on the thread's culture.

Returns a localized name of the specified field header area.

An integer value identifying the field header area. A corresponding to the specified field header area.

Returns a localized string to be displayed within the specified field header area when it is empty.

An integer value identifying the field header area. A that should be displayed in the specified field header area.

Returns a localized string for the specified string identifier.

A enumeration value identifying the string to localize. A corresponding to the specified identifier.

Returns a localized name of the specified summary type.

A enumeration value identifying the summary type. A corresponding to the specified summary type.

When implemented, represents an OLAP member.

Gets the dimension level to which the current OLAP member belongs.

An object implementing the DevExpress.XtraPivotGrid.IOLAPLevel interface that represents the dimension level to which the current member belongs.

Gets the OLAP member properties.

A DevExpress.XtraPivotGrid.OLAPMemberProperties collection that contains properties of the OLAP member.

Represents a method that will handle the event.

The event sender. A object that contains event data.

Provides data for the event.

Initializes a new instance of the PivotOptionsChangedEventArgs class with the specified option that has been changed.

A enumeration value, which indicates an option that has been changed.

Gets a value indicating an option that has been changed.

A enumeration value.

Lists the values that specify how the number of Top Values is determined.

The property determines the absolute number of top field values to display. For instance, if there are 20 unique field values and the TopValueCount property is set to 10, only the 10 top field values will be displayed.

In a regular data binding mode, the property determines the number of field values to display relative to the total number of field values. For instance, if there are 20 unique field values and the property is set to 10, only 2 top field values (10% out of 20) will be displayed. In an OLAP mode, PivotGridControl will display top values whose cumulative total is equal to or greater than a specified percentage. For instance, if the property is set to 10, PivotGridControl will display values whose cumulative total is not less than 10% of the Grand Total value.

The property determines the maximum allowed sum of the corresponding summary values. For instance, if the property is set to 100, the PivotGridControl will display field values whose cumulative total does not exceed 100. Works in OLAP mode only.

Lists the values that specify how a field's data should be sorted.

Enables custom sorting of the field's data via the event. Not supported in OLAP mode.

Sorts the field's data by the field's values (these are synchronized with the values from the bound data source).

Sorts the field's data by the field's display text (the strings displayed within the field values). In OLAP mode, the data is sorted against the text generated on the server. The field will not be sorted against the custom text generated on the client side (for instance, if you modify the text via the event).

Sorts by a level member's ID (in OLAP mode).

Sorts the field's data by key attributes (in OLAP mode).

Data is not sorted, and it's displayed in the order specified by the data source. This option is in effect only in OLAP mode.

Sorts the field's data by the field's values (these are synchronized with the values from the bound data source).

Lists values that specify the type of a PivotGridControl's item to be represented in a ChartControl.

A data cell value is processed to be represented in the chart control.

A column field value is processed to be represented in the chart control.

A row field value is processed to be represented in the chart control.

Represents the base class for Prefilters, that are editors allowing end-users to customize filter criteria at runtime.

Initializes a new instance of the PrefilterBase class with the specified owner.

An IPrefilterOwnerBase object that will own the created object.

Copies settings from the specified object to the current object.

An object whose settings are copied to the current object.

Clears the filter expression.

Returns whether the specified field is contained in the Prefilter expression.

A object that represents the field. true if the Prefilter expression contains the specified field; otherwise, false.

Gets or sets the filter expression.

A object that represents the filter expression.

Gets or sets the filter expression, in the string form.

A string value that specifies the filter expression.

Disposes of the resources allocated by the current object.

Gets or sets whether the filter criteria, specified by the or property, are enabled.

true if the filter criteria are enabled; otherwise, false.

For internal use.

Gets whether the Prefilter has no filter expression specified.

true if the Prefilter has no filter expression specified; otherwise, false.

Gets the names of all fields contained in the Prefilter expression.

A list of the objects that represent the field names.

Gets the Prefilter state that indicates whether the Prefilter expression is valid.

A enumeration member that specifies the Prefilter state.

Serves as a base for classes that provide data for the CustomExportFieldValue event.

Initializes a new instance of the CustomExportFieldValueEventArgsBase class with the specified settings.

An object implementing the IVisualBrick interface or its descendant. A PivotFieldValueItem class descendant that contains information used to initialize a new object.

Returns whether the specified row or column level corresponds to the processed field value.

An integer value that identifies the row or column level. true, if the specified row or column level corresponds to the processed field value; otherwise, false.

Gets a custom total to which the processed field value corresponds.

A class descendant that specifies the custom total to which the processed value corresponds; null if the field value does not correspond to a custom total.

Gets the data field that specifies the processed value.

A class descendant that specifies the data field which identifies the processed value.

Gets the maximum row level (for row fields) or column level (for column fields) that corresponds to the field value currently being processed.

An integer value that specifies the maximum row or column level that corresponds to the processed field value.

Gets a field whose value is being processed.

A class descendant that specifies the field whose value is being processed.

Gets whether the processed field value is collapsed.

true, if the processed field value is collapsed; otherwise, false.

Gets whether the processed value corresponds to a column field.

true, if the processed value corresponds to a column field; otherwise, false.

Gets whether the processed value corresponds to the "Others" row/column.

true, if the processed value corresponds to the "Others" row/column; otherwise, false.

Gets whether the processed field value resides within the top most row or column.

true, if the processed field value resides within the top most row or column; otherwise, false.

Gets the maximum row index (for row fields) or column index (for column fields) that corresponds to the field value currently being processed.

An integer value that specifies the maximum row or column index that corresponds to the processed field value.

Gets the minimum row index (for row fields) or column index (for column fields) that corresponds to the field value currently being processed.

An integer value that specifies the minimum row or column index that corresponds to the processed field value.

Gets the minimum row level (for row fields) or column level (for column fields) that corresponds to the field value currently being processed.

An integer value that specifies the minimum row or column level that corresponds to the processed field value.

Gets the processed field value display text.

A string value that specifies the field value display text.

Gets the processed field value.

An object that specifies the processed field value.

Gets the type of the currently processed field value.

A enumeration value that identifies the field value type.

Serves as a base for classes that provide data for the CustomUnboundFieldData event.

Initializes a new instance of the CustomFieldDataEventArgsBase class.

A PivotGridData object. A class descendant that specifies the unbound field currently being processed. An integer value that identifies the current row index in the data source. An object that specifies the processed cell value.

Gets the unbound field currently being processed.

A class descendant that specifies the unbound field currently being processed.

Returns the value of the specified cell within the processed row in the control's underlying data source.

A that specifies the name of the field whose value should be obtained. The value of the specified field in the control data source.

Returns the value of the specified cell within the specified row in the control's underlying data source.

An integer value that specifies the required row index in the data source. A that specifies the name of the field whose value should be obtained. The value from the specified field in the control's data source.

Gets the current row index in the data source.

An integer value identifying the current row index in the data source.

Gets or sets the currently processed value.

The value currently being processed.

Serves as a base for classes that represent field value cells.

Initializes a new instance of the FieldValueCellBase class.

A PivotFieldValueItem class descendant that contains information used to initialize a new object.

Gets the data field that identifies the cell.

A descendant that specifies the data field which identifies the cell.

Gets the field to which the cell corresponds.

A class descendant that specifies the field to which the cell corresponds.

Gets the parent of the current cell.

A class descendant that specifies the parent cell.

Provides data for the FieldValueDisplayText event.

Initializes a new instance of the PivotFieldDisplayTextEventArgsBase class with the specified settings.

A PivotFieldValueItem class descendant that contains information used to initialize a new object. A that specifies the text displayed by default. This value is assigned to the property.

Initializes a new instance of the PivotFieldDisplayTextEventArgsBase class with the specified settings.

A class descendant that specifies the field currently being processed. This value is assigned to the property. An object that specifies the field value. This value is assigned to the property.

Initializes a new instance of the PivotFieldDisplayTextEventArgsBase class with the specified settings.

A class descendant that specifies the field currently being processed. This value is assigned to the property. An object implementing the interface.

Gets or sets the text displayed in the field header or filter drop-down item.

A that specifies the text displayed in the field header or filter drop-down item.

Gets whether the FieldValueDisplayText event is called to populate the filter dropdown.

true if the event is called to populate the filter dropdown; false if the event is called to customize the display text of column and row headers.

Gets the column field or row field value that corresponds to the currently processed column/row header.

The field value currently being processed.

Provides "OLAP mode"-specific options for a PivotGrid control.

Initializes a new instance of the PivotGridOptionsOLAP class. For internal use.

For internal use.

Gets or sets for which filter fields the pivot grid processes only data related to their default members.

A enumeration member that specifies for which filter fields the pivot grid processes only data related to their default members.

Gets or sets whether PivotGridControl should take into account OLAP member values or unique names when filtering data in the OLAP mode.

true to take into account unique names when filtering data in the OLAP mode; false to take into account values instead.

Gets or sets whether to use the Aggregate function in the MDX query, if the filter contains a single value.

true to use the Aggregate function for a single filter value; otherwise, false.

For internal use.

Lists values that specify the graphic set used to indicate KPI values.

No image is displayed.

The KPI graphic type is defined by the server.

Lists KPI types.

A target value of the KPI.

Not the KPI.

The state of the KPI at a specified point in time.

A value's evaluation of the KPI over time.

A KPI value.

A KPI's relative importance.

Lists the areas within which a field can be positioned.

Specifies that a field can be positioned within any area.

Specifies that a field can be positioned within the Column Header Area.

Specifies that a field can be positioned within the Data Header Area.

Specifies that a field can be positioned within the Filter Header Area.

Specifies that a field can be positioned within the Row Header Area.

Contains the values that specify a field's filter type in the XtraPivotGrid control.

Specifies that the XtraPivotGrid control should not display the filter values. All the other values will be displayed.

Specifies that the XtraPivotGrid control should display only the filter values.

Provides the options which control the presentation of data fields in the XtraPivotGrid.

Initializes a new instance of the PivotGridOptionsDataField class.

A object that implements data-aware operations on the data source.

Initializes a new instance of the PivotGridOptionsDataField class with the specified settings.

A PivotGridData object which contains the information required to initialize the created PivotGridOptionsDataField object. An IViewBagOwner object that is used to initialize the created object. A string value that is used to initialize the created object.

Initializes a new instance of the PivotGridOptionsDataField class with the specified settings.

A PivotGridData object which contains information required to initialize the created PivotGridOptionsDataField object. A method that will handle the event.

Initializes a new instance of the PivotGridOptionsDataField class with the specified settings.

A PivotGridData object which contains information required to initialize the created PivotGridOptionsDataField object. A method that will handle the event. An IViewBagOwner object used to initialize the created object. A string value used to initialize the created object.

Gets or sets the area in which the data field headers are displayed.

A value that specifies the area in which the data field headers are displayed.

Gets or sets the position of the data field headers.

An integer which specifies the position of the data field headers within the hierarchy of field values.

Gets or sets the text displayed within the data header.

A string which specifies the text displayed within the data header.

Gets or sets the height of data field headers, in text lines. This property is in effect when there are two or more data fields, and data field headers are displayed in the Column Header Area.

An integer value that specifies the height of data field headers, in text lines.

Gets or sets the area in which the data field headers are displayed.

A value that specifies the area in which the data field headers are displayed.

Gets or sets the position of the data field headers.

An integer which specifies the position of the data field headers within the hierarchy of field values.

Gets or sets the area in which the data field headers are displayed.

A value that specifies the area in which the data field headers are displayed.

Gets or sets whether data field headers are visible.

true to display data field headers as column headers; false to hide data field headers.

This member supports the internal infrastructure and is not intended to be used directly from your code.

A Boolean value.

Gets or sets the rule for naming columns, that correspond to data fields, when creating a data source via the CreateSummaryDataSource methods.

A value that specifies the column naming convention.

Gets or sets the width of the data field headers when they are displayed as row headers.

An integer which specifies the width of the data field headers when they are displayed as rows.

Gets or sets the height of data field headers, in text lines. This property is in effect when there are two or more data fields, and data field headers are displayed in the Row Header Area.

An integer value that specifies the height of data field headers, in text lines.

For internal use.

Contains values that specify the areas where the data field headers can be displayed.

The data field headers are displayed as column headers. The data header is displayed within the column header area.

The data field headers are displayed as column headers. The data header is hidden.

The data field headers are displayed as row headers. The data header is displayed within the row header area.

Represents a collection of field groups.

Initializes a new instance of the class.

A object.

Adds the specified group to the end of the collection.

A object which represents the group to add.

Creates a new group and appends it to the collection.

A object which represents the group that was added.

Creates and appends a new empty group with the specified caption to the collection.

A string which specifies the group's caption. This value is assigned to the property.

Creates a group and adds the specified fields to it.

An array of fields to be added to the created group. The created object.

Creates a group with the specified caption, containing the specified fields.

An array of fields to be added to the created group. A caption for the group. This value is assigned to the property. The created object.

Adds an array of groups to the collection.

An array of objects to add to the collection.

Determines whether all groups allow a field to be moved to the specified location.

A enumeration value which specifies the area of the XtraPivotGrid. An integer value which specifies the new index of the field among the other fields displayed within the specified area. true if all groups allow a field to be moved to the location specified; otherwise, false.

Indicates whether the current collection contains the group which owns the specified field.

A descendant which represents the field. true if the collection contains the group which owns the specified field; otherwise, false.

Indicates whether the current collection contains the specified group.

A object which represents the group to locate in the collection. true if the collection contains the specified group; otherwise, false.

Returns the group that meets the specified criteria.

A System.Predicate delegate, representing a method that defines a set of criteria used to locate the required group. A object that represents the group that meets the specified criteria; null if the group has not been found.

Returns the group which owns the specified field.

A descendant which represents the field whose owning group is to be returned. A object which represents a group that owns the specified field. null (Nothing in Visual Basic) if the specified field doesn't belong to any group within the collection.

Returns the specified group's position within the collection.

A object which represents the group to locate. An integer value specifying the group's position within the collection. -1 if the collection doesn't contain the specified group.

Adds the specified group to the specified position within the collection.

An integer value which specifies the zero-based index at which the specified group should be inserted. If it's negative or exceeds the number of elements, an exception is raised. A object which represents the group to insert.

Provides indexed access to the groups in the collection.

An integer value specifying the zero-based index of the required group. If it's negative or exceeds the maximum available index, an exception is raised. A object which represents the group in the collection.

Removes the specified group from the collection.

A object which represents the group to remove.

Represents an individual group of fields.

Initializes a new instance of the class.

Initializes a new instance of the class with the specified caption.

A value that specifies the group's caption. This value is assigned to the property.

Adds the specified field to the collection of the current group.

A descendant which represents the field to add.

Adds an array of fields to the collection of the current group.

An array of descendants to add to the group's field collection.

Gets the area of the pivot grid in which the group is displayed.

A enumeration value which specifies the area in which the group is displayed.

Gets the index of the first field within the group among the other fields displayed within the same area.

A zero-based integer that specifies the index of the first field within the group among the other fields displayed within the same area. -1 if the group is empty.

Indicates whether the specified field can be added to the field group.

A descendant which represents the field being examined. true if the specified field can be added to the group; otherwise, false.

Determines whether changing the location of the specified field will change the location of the entire group.

A descendant which represents the inspected field. true if changing the location of the specified field will change the location of the entire group; otherwise, false.

Determines whether the group can be moved to the specified location.

A enumeration value which specifies the area of the XtraPivotGrid. An integer value which specifies the new index of the first field in the group among the other fields displayed within the specified area. true if the group can be moved to the location specified; otherwise, false.

Indicates whether the specified field can be expanded/collapsed.

A descendant that represents the field. true if the specified field belongs to the current group and isn't the right most field within the group; otherwise, false.

Gets or sets the group's caption.

A string value which specifies the group's caption.

Moves the specified field to the specified position within the group.

A object which represents the field to move. An integer value specifying the new position of the field within the group.

Removes all elements from the collection.

Indicates whether the current group contains the specified field.

A descendant which represents the field to locate in the group. true if the group contains the specified field; otherwise, false.

Gets the number of fields within the group.

An integer value which specifies the number of fields within the group.

Provides access to the group's field collection.

An object which implements the interface.

Gets the group filter condition.

A object that represents the group filter condition.

Returns the unique child values of the specified group value.

An array of objects that identifies the group value. A collection of the group value's child values.

Gets the list of expanded fields in this group.

A list of expanded fields in this group.

Gets or sets the name of the hierarchy to which the current field group belongs.

A string that specifies the name of the hierarchy to which the current field group belongs.

Gets the group's position within the collection that owns it.

A zero-based integer which represents the group's position within the collection that owns it. -1 if the group isn't contained within a collection.

Returns the specified field's position within the group.

A descendant which represents the field to be located. An integer value specifying the field's position within the group. -1 if the group doesn't contain the specified field.

Returns a value which identifies whether the specified field is visible.

A object which represents the field within the XtraPivotGrid control. true if the specified field is visible; otherwise, false.

Gets whether the group filter is used to filter data against the group's fields.

true if the group filter is used to filter data against the group's fields; false if data is filtered against each of the group's fields separately.

Gets whether the control is in OLAP mode.

A Boolean value that specifies whether the control is in OLAP mode.

Provides indexed access to the fields in the group.

An integer value specifying the zero-based index of the required field. If it's negative or exceeds the maximum available index, an exception is raised. A descendant which represents the field in the group.

This method is intended for internal use only. Normally, you don't need to use it.

Removes the specified field from the group.

A descendant which represents the field to remove from the group.

Removes a field from the group by its index.

An integer value which specifies the index of the field to remove. If negative or exceeds the number of fields within the group, an exception is raised.

Gets or sets whether field values that have appeared in the datasource after the field's filtering was configured should be shown.

true to show new field values; otherwise, false.

Returns the group's display text.

A string which represents the group's display text.

Gets whether the group is visible.

true if the group is visible; otherwise, false.

Gets the number of visible fields within the current group.

An integer which specifies the number of visible fields within the group.

This method supports the internal infrastructure and is not intended to be used directly from your code.

An XtraItemEventArgs object. An object.

Represents a list of the records which are used to calculate summaries for individual cells.

Initializes a new instance of the PivotDrillDownDataSource class.

This member supports the internal infrastructure and is not intended to be used directly from your code.

[To be supplied]

This member supports the internal infrastructure and is not intended to be used directly from your code.

Returns the index of the specified row.

A data source row to locate. An integer value that represents the zero-based index of the specified row; -1 if the specified row has not been found.

Gets the value of the specified field in the specified row.

The zero-based index of the required row. A object which represents the required field. An object which represents the value of the specified field in the specified row.

Returns the value of the specified data field in the specified row.

A zero-based integer that identifies the data row. A value that specifies the field name. In OLAP mode, this parameter must specify the column name, as defined in the data source. An object that represents the value of the specified data field in the specified row.

Returns the value of the specified data field in the specified row.

A zero-based integer that identifies the data row. A zero-based integer that identifies the data column. An object that represents the value of the specified data field in the specified row.

Provides indexed access to the rows in the current data source.

A zero-based integer which specifies the index of the required row. A object that represents the row at the specified location.

Gets the number of records in the data source.

An integer value that specifies the number of records in the data source.

Sets the value of the specified data field in the specified row.

A zero-based integer that identifies the data row. A value that specifies the field name. An object that represents the new value.

Sets the value of the specified data field in the specified row.

A zero-based integer that identifies the data row. A zero-based integer that identifies the column. An object that represents the new value.

Sets the value of the specified data field in the specified row.

A zero-based integer that identifies the data row. A object that represents the pivot grid field. It's property identifies the column in the data source. An object that represents the new value.

Represents a single row in the data source which provides the data used to calculate summaries for individual cells.

Initializes a new instance of the PivotDrillDownDataRow class.

A object that represents the data source that will own the created row. An integer that specifies the index of the created row in the data source.

Gets the data source which contains the current row.

A object which represents the data source that contains the current row.

Gets the row's index within .

An integer which specifies the row's index in the data source.

Gets the row's value for the specified field.

A object which represents the required field. An object which represents the row's value in the specified field.

Returns the value of the specified field in the current row.

A zero-based integer that identifies the data column. An object that represents the value of the specified data field in the current row.

Returns the value of the specified field in the current row.

A value that specifies the data field name. An object that represents the value of the specified data field in the current row.

Gets the row's index in the pivot grid's data source.

Gets the current row's index in the pivot grid's data source.

Contains filter values for a specific field.

Initializes a new instance of the PivotGridFieldFilterValues class.

A object which represents the field that will own the collection. This value is assigned to the property.

Adds the specified element to the array.

An object which represents the element to add.

For internal use.

Copies the settings from the object passed as a parameter.

A object whose settings are assigned to the current object. If null (Nothing in Visual Basic), this method does nothing.

Removes all elements from the array.

Returns whether the current filter condition allows displaying the specified value.

An object that should be located in the array. true if the current filter condition allows displaying the specified value; otherwise, false.

This member supports the internal infrastructure and is not intended to be used directly from your code.

Gets the number of elements in the array.

An integer value which specifies the number of elements in the array.

For internal use.

Gets the field which owns the current collection.

A descendant that represents the field which the current collection belongs to.

Gets or sets the field's filter type.

A enumeration value which specifies the field's filter type.

Gets whether the current PivotGridFieldFilterValues object specifies non-empty filter criteria.

true if the current PivotGridFieldFilterValues object specifies non-empty filter criteria; otherwise, false.

Inverts the current filter type.

Gets whether the current collection contains values used to filter against the current field.

true if there are no elements in the array and the property is set to Excluded; otherwise, false.

Returns whether the filter values and settings represented by the current and specified objects match.

A object that represents the filter values and settings that should be compared with the current ones. true if the filter values and settings represented by the current and specified objects match; otherwise, false.

Returns whether the current filter values and the specified values match.

A list of objects that represents the values that should be compared with the current filter values. true if the current filter values and the specified values match; otherwise, false.

Removes the specified element from the array.

An object which represents the element to remove.

For internal use.

Sets the filter type to the specified value.

A enumeration member that specifies the filter type. This value is assigned to the property.

Adds the specified values to the collection and sets the and properties to the specified values.

An array of objects that contains filter values that should be added to the collection. A value that specifies the current field's filter type. true if the PivotGridControl should process records that contain NULL values in the current field; otherwise, false. true to allow raising OnChanged events; otherwise, false. true if the specified values differ from the current ones; otherwise, false.

For internal use.

Gets or sets whether records that contain NULL values in the current field should be processed by the control.

true if records that contain NULL values in the current field are processed by the control; false if these records are ignored.

Gets or sets an array of filter values.

An array of objects that represent the filter values.

For internal use.

Gets or sets which values are excluded from the current field.

An array of the values that are excluded from being displayed in the current field.

Gets or sets the values that are displayed in the current field.

An array of the values that are displayed in the current field.

Represents the base class for the class.

Initializes a new instance of the PivotGridCustomTotalCollectionBase class.

A object which will own the collection being created.

Initializes a new instance of the PivotGridCustomTotalCollectionBase class with default settings,

Initializes a new instance of the PivotGridCustomTotalCollectionBase class and adds copies of the specified custom totals to the collection.

An array of objects whose copies will be added to the collection.

Appends a new item to the collection that represents a custom total of the specified summary function type.

A value that determines the type of the summary function used to calculate the current total. This value is assigned to the property. A object which represents the created custom total.

Adds the specified custom total to the collection.

A descendant which represents the custom total to add to the collection.

Clones custom totals from the specified collection and adds them to the current collection.

A collection that stores custom totals whose copies will be added to the current collection.

Clears the current collection and adds the specified array's items to the collection.

An array of objects to be added to the collection.

Returns copies of items stored in the current collection.

An array of objects which are copies of the current collection's items.

Returns whether the current collection contains an element with the specified summary type.

A value that specifies the summary type to be tested. true if the current collection contains an element with the specified summary type; otherwise, false.

Gets the field which owns the current collection.

A field which owns the current collection.

Returns the index of the specified element.

A descendant representing the collection element. An integer value representing the zero-based index of the specified element; -1 if the element has not been found.

Provides indexed access to the elements in the collection.

A zero-based integer value which represents the desired custom total's position within the collection. If it's negative or exceeds the last available index, an exception is raised. A object located at the specified index.

Removes the specified custom total from the collection.

A descendant which represents the custom total to remove from the collection.

Represents the base class for the class.

Initializes a new instance of the PivotGridCustomTotalBase class with the specified summary function type.

A value that specifies the summary function type for the created custom total object. This value is assigned to the property.

Initializes a new instance of the PivotGridCustomTotalBase class with the default settings.

Provides the settings used to format the custom total's values.

A object that specifies the formatting settings for the custom total values.

Copies settings of the current object to the object passed as the parameter.

A object to which settings are copied from the current object.

Provides the settings used to format the text within the custom total's headers.

A object that specifies formatting settings for the text displayed within the custom total's header.

Gets the actual settings used to format the custom total's values.

A object that specifies the formatting settings.

Returns the formatted text representation of the specified value according to the settings used to represent the headers of the current custom total.

An object which identifies the value to format. A string which is the formatted text representation of the specified value.

Returns whether the settings of the current and specified objects match.

A object to be compared with the current object. true if the settings of the objects match; otherwise, false.

Gets or sets the type of the summary function used to calculate the current custom total.

A enumeration value that specifies the summary function type.

Gets or sets the data associated with the custom total.

An object containing the information which is associated with the custom total.

Returns the text representation of the current object.

A string representation of the current object.

Provides selection options for the control.

Initializes a new instance of the class.

Gets or sets whether multiple cells can be selected.

true to allow multiple cell selections; otherwise, false.

Gets or sets whether the appearance settings used to paint the focused cell are enabled.

true if the appearance settings for focused cells are enabled; otherwise, false.

Gets the maximum number of rows that can be selected simultaneously.

An integer value that specifies the maximum number of rows that can be selected simultaneously. -1 if any number of rows can be selected.

Gets the maximum number of columns that can be selected simultaneously.

An integer value that specifies the maximum number of columns that can be selected simultaneously. -1 if any number of columns can be selected.

Gets or sets whether multiple range selection is enabled.

true to enable multiple range selection; otherwise, false.

Contains values that specify which summary totals are displayed for a specific column field or row field.

Specifies that automatic totals are calculated.

Specifies that custom totals are calculated using the formula in the collection.

Specifies that a summary total is not calculated.

Provides thread-safe access to the pivot grid fields collection.

Gets the number of fields in the collection.

An integer value that specifies the number of fields in the collection.

Returns the number of visible fields displayed within the specified area.

A value that identifies the targeted area. An integer value that identifies the number of visible fields displayed within the specified area.

Provides access to individual fields within the collection by the name of the bound data source field.

A that specifies the name of the bound data source field. An object that implements the interface. Provides thread safe read-only access to basic field settings.

Provides indexed access to individual fields within the collection.

A zero-based integer value that specifies the index of the required field. An object that implements the interface. Provides thread safe read-only access to basic field settings.

Provides customization options for a PivotGrid control.

Initializes a new instance of the class.

A delegate that will receive change notifications.

Initializes a new instance of the PivotGridOptionsCustomization class.

A delegate that will receive change notifications. An object which implements the IViewBagOwner interface. The string value.

Gets or sets whether end-users are allowed to invoke the Customization Form.

true if end-users are allowed to invoke the Customization Form; otherwise, false.

Gets or sets whether end-users are allowed to drag field headers.

true to allow end-users to drag field headers; otherwise, false.

Gets or sets whether end-users are allowed to drag field headers between areas in the Customization Form.

true if end-users are allowed to drag field headers between areas in the Customization Form; otherwise, false.

Gets or sets whether end-users are allowed to expand/collapse rows or columns that correspond to the current field.

true if end-users are allowed to expand/collapse rows or columns that correspond to the current field; otherwise, false.

Gets or sets whether field values are expanded/collapsed on a double click.

true if field values are expanded/collapsed on a double click; otherwise, false.

Gets or sets whether filter buttons are displayed within field headers.

true to display filter buttons within field headers; otherwise, false.

Gets or sets whether end-users are allowed to filter pivot grid data by summaries.

A enumeration member that specifies whether end-users are allowed to filter pivot grid data by summaries.

Gets or sets whether filtering can be applied to fields via the Customization Form.

true if filtering can be applied to fields via the Customization Form; otherwise, false.

Gets or sets a value which specifies when the fields can be hidden by end-users.

An enumeration value which specifies when the field can be hidden by end-users.

Gets or sets whether end-users are allowed to invoke the Prefilter.

true to allow end-users to invoke the Prefilter; otherwise, false.

Gets or sets whether end-users can change the sort order of fields.

true to allow end-users to change the sort order of fields; otherwise, false.

Gets or sets whether end-users can sort row field values by column values, and column field values by row values.

true if end-users can sort field values by other field values; otherwise, false.

Gets or sets whether the sort order of field values can be toggled via the Customization Form.

true if the sort order of field values can be toggled via the Customization Form; otherwise, false.

Gets or sets which layouts can be applied to the Customization Form when it is painted in Excel2007 style.

One or several enumeration members that specify which layouts can be applied to the Customization Form.

Gets or sets the customization form's layout when it is painted in Excel2007 style.

A enumeration member that specifies how fields are arranged within the customization form.

Gets or sets the Customization Form's style.

A value that specifies the customization form's style.

Gets or sets whether dragging fields within the Customization Form (when it's painted using the Excel2007 style) immediately updates the layout of fields in the PivotGrid control.

true if the layout of fields in the PivotGrid control must not be immediately updated; otherwise, false.

Contains the settings used to sort the values of a column field or row field by summary values in another row/column.

Initializes a new instance of the PivotGridFieldSortBySummaryInfo class.

A descendant. The string value.

Copies settings from the specified object to the current object.

A source object whose settings are copied to the current object.

Contains conditions that identify the column or row whose values are sorted.

A collection whose items identify the column or row of values to be sorted.

Gets or sets the summary type of the custom total column/row, by which the current field values are sorted.

A object representing the summary type of the custom total column/row, by which the field values are sorted. Null if the field values are not sorted by a custom total column/row.

Gets or sets the field whose summary values define the order in which the values of the current column field or row field are arranged.

A object which represents a field whose summary values determine the order of the current field's values.

For internal use. Gets or sets the name of the field specified by the property.

A string which specifies the name of the .

Gets or sets the field name of the field whose summary values define the order in which the values of the current column field or row field are arranged.

A string that specifies the field name of the field whose summary values determine the order of the current field's values.

Gets whether the current object is initialized with valid data.

true if the current object is initialized with valid data; otherwise, false.

Gets the field which owns the current PivotGridFieldSortBySummaryInfo object and whose values are sorted using the settings of this object.

A object which represents the Column Field or row field whose values are sorted using the settings of the current PivotGridFieldSortBySummaryInfo object.

Reverts the , and properties to their default values.

This member supports the infrastructure and cannot be used directly from your code.

Tests whether the PivotGridFieldSortBySummaryInfo object should be persisted.

true if the object should be persisted; otherwise, false.

This member supports the infrastructure and cannot be used directly from your code.

Gets or sets the summary function type used to calculate the summary values which define the order in which the current column field's (row field's) values are arranged.

A value that specifies the summary function type.

Gets the text representation of the current object.

An empty string.

Lists values that specify when fields can be hidden by end-users.

End-users can always hide fields.

End-users cannot hide fields.

End-users can only hide fields when the customization form is visible.

Represents a summary data source.

Initializes a new instance of the PivotSummaryDataSource class.

A DevExpress.XtraPivotGrid.Data.PivotGridData object representing the pivot grid data. An integer value that specifies the index of the pivot grid column whose data cells should be represented by the summary data source; -1 to include data from all columns to the data source. An integer value that specifies the index of the pivot grid row whose data cells should be represented by the summary data source; -1 to include data from all rows to the data source.

Exports the summary data source to an XML file.

A that specifies the name of the XML file to which the summary data source should be written. true to write the summary data source with the relational structure as an inline XSD schema; otherwise, false.

Exports the summary data source to a binary stream in the XML format.

A object that represents the stream to which the summary data source should be written. true to write the summary data source with the relational structure as an inline XSD schema; otherwise, false.

Returns the index of the column that corresponds to the specified field.

A object that represents the pivot grid field used to identify the summary data source column. An integer value that specifies the zero-based index of the summary data source column that corresponds to the specified field.

Returns the field to which the specified column corresponds.

An integer value that specifies the zero-based index of the summary data source column. A object that represents the field to which the specified column corresponds.

Returns whether the specified cell corresponds to the 'Others' column/row.

An integer value that specifies the zero-based index of the summary data source row. A that specifies the name of the summary data source column. true if the specified cell corresponds to the pivot grid's 'Others' column/row; otherwise, false.

Returns whether the specified cell corresponds to the 'Others' column/row.

An integer value that specifies the zero-based index of the summary data source row. An integer value that specifies the zero-based index of the summary data source column. true if the specified cell corresponds to the pivot grid's 'Others' column/row; otherwise, false.

For internal use.

Returns the index of the specified row.

A object that represents the summary data source row. An integer value that represents the zero-based index of the specified summary data source row.

Returns the value of the specified cell.

An integer value that specifies the zero-based index of the summary data source row. A that specifies the name of the summary data source column. The value of the specified summary data source cell.

Returns the value of the specified cell.

An integer value that specifies the zero-based index of the summary data source row. An integer value that specifies the zero-based index of the summary data source column. The value of the specified summary data source cell.

Returns the value of the specified cell.

An integer value that specifies the zero-based index of the summary data source row. A descendant representing the field used to identify the data source column. The value of the specified summary data source cell.

Gets or sets whether to update the data source when the pivot grid data changes.

true to update the summary data source when the pivot grid data changes; otherwise, false.

Gets or sets the row by its index.

An integer value that specifies the zero-based index of the summary data source row. A object that represents the summary data source row with the specified index.

Gets the number of rows in the data source.

An integer value that specifies the number of rows in the summary data source.

Contains values that specify how the values of a specific column or row field are combined into groups.

Combines field values into categories according to the character that the values start with.

Enables combining the field's data into custom intervals via the event. Not supported in OLAP mode.

This option is in effect only for fields that store date/time values. Field values are grouped by the date part. The time part of the values is ignored.

This option is in effect only for fields that store date/time values. Field values are grouped by the day part. The following groups can be created: 1, 2, 3,...,31.

This option is in effect only for fields that store date/time values. Field values are grouped by the days of the week. Examples of such groups: Sunday, Monday, Tuesday (the actual names of the days of the week are determined by the current culture).

This option is in effect only for fields that store date/time values. Field values are grouped by the number of the day in which they occur in a year. The following groups can be created: 1, 2, 3,...,365 (,366 in a leap year).

This option is in effect only for fields that store date/time values. Field values are grouped by the date part with the hour value. Examples of such groups: 3/4/2012 0:00, 3/4/2012 1:00, 3/4/2012 2:00, ...

This option is in effect only for fields that store date/time values. Field values are grouped by the date part with the hour and minute values. Examples of groups: 3/4/2012 0:00, 3/4/2012 0:01, 3/4/2012 0:02, ...

This option is in effect only for fields that store date/time values. Field values are grouped by the date part with the hour, minute and second values. Examples of groups: 3/4/2012 0:00:00, 3/4/2012 0:00:01, 3/4/2012 0:00:02, ...

This option is in effect only for fields that store date/time values. Field values are grouped by the month part. Examples of groups: January, February, March (the actual names of the months are determined by the current culture).

This option is in effect only for fields that store date/time values. Field values are grouped by the date part. Examples of groups: 3/4/2012, 3/5/2012, 3/6/2012, ...

This option is in effect only for fields that store date/time values. Field values are sorted by the quarterly intervals of the year. The following groups can be created: 1, 2, 3 and 4. Each quarter includes three months.

This option is in effect only for fields that store date/time values. Field values are grouped by the year and quarter. Examples of groups: Q3 2012, Q4 2012, Q1 2013, Q2 2013, ...

This option is in effect only for fields that store date/time values. Field values are grouped by the number of the week in which they occur in a month. The following groups can be created: 1, 2, 3, 4 and 5. The first week is the week containing the 1st day of the month.

This option is in effect only for fields that store date/time values. Field values are grouped by the number of the week in a year in which they occur. The following groups can be created: 1, 2, 3,...,52, 53. Week numbers are calculated based on the following current culture's settings: the and properties.

This option is in effect only for fields that store date/time values. Field values are grouped by the year part. Examples of such groups: 2003, 2004, 2005.

This option is in effect only for fields that store date/time values. Field values are grouped by the number of full days that have elapsed till the current date. The lengths of groups is determined by the property.

Groups combine unique field values.

This option is in effect only for fields that store date/time values. Field values are grouped by the hour part, regardless of the date to which the current date/time value belongs.

This option is in effect only for fields that store date/time values. Field values are grouped by the minute part, regardless of the date to which the current date/time value belongs.

This option is in effect only for fields that store date/time values. Field values are grouped by the number of full months that have elapsed till the current date. The lengths of groups is determined by the property.

This option is in effect only for fields that store numeric values. Field values are grouped into intervals as defined by the property.

This option is in effect only for fields that store date/time values. Field values are grouped by the second part, regardless of the date to which the current date/time value belongs.

This option is in effect only for fields that store date/time values. Field values are grouped by the number of full weeks that have elapsed till the current date. The lengths of groups is determined by the property.

This option is in effect only for fields that store date/time values. Field values are grouped by the number of full years that have elapsed till the current date. The lengths of groups is determined by the property.

Lists values that specify the types of column and row headers.

Corresponds to a custom total.

Corresponds to a grand total.

Corresponds to an automatic total.

Corresponds to a field value.

Lists values that specify the summary function types.

The average of the values.

The number of values (excluding Null and DBNull values).

Specifies whether calculations should be performed manually, by handling the CustomSummary event. Not supported in OLAP mode.

The largest value.

The smallest value.

An estimate of the standard deviation of a population, where the sample is a subset of the entire population.

The standard deviation of a population, where the population is all of the data to be summarized.

The sum of the values.

An estimate of the variance of a population, where the sample is a subset of the entire population.

The variance of a population, where the population is all of the data to be summarized.

Contains options for a field.

Initializes a new instance of the PivotGridFieldOptions class with the specified settings.

A delegate that will receive change notifications. An IViewBagOwner object that is used to initialize the created object. A string value that is used to initialize the created object.

Gets or sets whether an end-user is allowed to drag the Field Header.

A enumeration value specifying whether end-users can drag the field's header.

Gets or sets whether end-users are allowed to drag field headers between areas in the Customization Form.

true if end-users are allowed to drag field headers between areas in the Customization Form; otherwise, false.

Gets or sets whether an end-user is allowed to expand/collapse the rows or columns which correspond to the current field.

A enumeration value which specifies whether end-users can expand/collapse the field's rows or columns.

Gets or sets whether an end-user can apply a filter to the current field.

A enumeration value specifying whether end-users can apply a filter to the current field.

Gets or sets whether end-users are allowed to filter pivot grid data by summaries calculated against the current data field.

A enumeration member that specifies whether end-users are allowed to filter pivot grid data by summaries calculated against the current data field.

Gets or sets whether an end-user can change the data field's summary type.

true to allow an end-user to change the data field's summary type; otherwise, false.

Gets or sets whether an end-user can modify the field's current sort order.

A enumeration value specifying whether end-users can modify the field's sort order.

Gets or sets whether end-users can sort the current row/column field values by other column/row summary values.

A value that specifies whether end-users can sort the current row/column field values by other column/row summary values.

Gets or sets the filtering mode used for the field's owner group.

A enumeration member that specifies the filtering mode used for the field's owner group.

Gets or sets whether the first (empty) column/row that displays variation data for the current data field must be hidden.

true if the first (empty) column/row that displays variation data for the current data field must be hidden; otherwise, false.

Gets or sets whether PivotGridControl should take into account OLAP member values or unique names when filtering data in an OLAP mode.

A enumeration member that specifies whether PivotGridControl should take into account OLAP member values or unique names when filtering data in an OLAP mode.

Gets or sets whether to use the WHERE or subselect clause in an MDX query, when filtering against filter fields in OLAP mode.

A enumeration member that specifies whether to use the WHERE or subselect clause in an MDX query, when filtering against filter fields in OLAP mode.

Gets or sets whether the NonEmpty function should be used in MDX queries for the current measure.

true to use the NonEmpty function in MDX queries; otherwise, false.

Occurs when any of the PivotGrid control's option has been changed.

Gets or sets whether Custom Totals that correspond to the current Column Field or Row Field are visible.

true if corresponding custom totals are visible; otherwise, false.

Gets or sets whether grand totals that correspond to the current data field are visible.

true if corresponding grand totals are visible; otherwise, false.

Gets or sets whether the field's header is displayed within the customization form when the field is hidden.

true to display the field's header within the customization form when the field is hidden; otherwise, false.

Gets or sets whether the field is shown in Prefilter.

true if the field is shown in Prefilter; otherwise, false.

Gets or sets whether the summary type is displayed within the data field's header.

true to display the summary type within the data field's header; otherwise, false.

Gets or sets whether Totals that correspond to the current data field are visible.

true if corresponding automatic totals are visible; otherwise, false.

Gets or sets whether data cells that correspond to the current data field are visible.

true if data cells that correspond to the current data field are visible; otherwise, false.

Represents the base class for the class.

Initializes a new instance of the PivotGridFieldCollectionBase class.

A object that implements data-aware operations on the data source.

Appends a new field to the collection.

The object added to the collection.

Adds a new field with the specified field name and location to the end of the collection.

A string that identifies the name of the database field that will be assigned to the new PivotGridField object. This value is assigned to the property. A value that identifies the area in which the new PivotGridField object will be positioned. This value is assigned to the property. The object added to the collection.

Adds the specified field to the collection.

A descendant that represents the pivot grid field.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

Indicates whether the collection contains the specified field.

A object to locate in the collection. true if the collection contains the specified field; otherwise, false.

This property is intended for internal use only. Normally, you don't need to use it.

Gets the default width of Field Value boxes.

An integer value that specifies the default width of Field Value boxes.

Generates the default name of the pivot grid field by the name of the corresponding data source field.

A that specifies the name of the corresponding data source field. A that specifies the generated name of the pivot grid field.

Gets a field in the collection by its name.

A string which represents the name of the required field. A object which represents a field with the specified name; null if the collection doesn't contain such a field.

Returns the number of visible fields displayed within the specified area.

A value that identifies the targeted area. An integer value that identifies the number of visible fields displayed within the specified area.

Combines fields into groups as specified by a cube's structure on an OLAP server. This method supports the internal infrastructure, and is not intended to be called directly from your code.

Returns the specified field's position within the collection.

A object to locate in the collection. A zero-based integer which represents the field's position within the collection. -1 if the field doesn't belong to the collection.

Gets the field object specified by the bound field name.

A string value specifying the bound field name of the required object. The descendant bound to the specified field.

Provides indexed access to individual fields in the collection.

A zero-based integer specifying the desired field's position within the collection. If negative or exceeds the last available index, an exception is raised. A descendant which represents the field at the specified position.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

For internal use.

Removes the specified object from the collection.

A object representing the field to remove.

Sets the index of the specified field to the specified value.

The object that should be moved to the specified location in the collection. The new index of the specified field.

Updates the location indexes of the fields in the collection as a result of modifying the visibility of the fields.

Represents the base class for the class.

Initializes a new instance of the PivotGridFieldBase class with the specified field name and location.

A string identifying the name of the database field. This value is assigned to the property. A value that defines the location for the PivotGridFieldBase object within the control. This value is assigned to the property.

Initializes a new instance of the PivotGridFieldBase class with default settings.

Initializes a new instance of the PivotGridFieldBase class.

A object.

Gets the field's actual data type.

A representing the field's actual data type.

This member supports the internal infrastructure and is not intended to be used directly from your code.

Gets or sets the areas within which the field can be positioned.

A value that specifies which areas the field can be positioned in.

Gets or sets the area in which the field is displayed.

A value that specifies the area in which the field is displayed.

Gets or sets the field's index from among the other fields displayed within the same area.

A zero-based integer that specifies the field's index among the other fields displayed within the same area.

Copies settings from the specified object to the current object.

A source object whose settings are copied to the current object.

For internal use.

Reserved for future use.

Returns whether the field can be positioned in the specified area, and at the specified location.

A object representing the pivot grid area. An integer value representing the index of the field in its area. true if the field can be positioned in the specified area and at the specified location; otherwise, false.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

A Boolean value.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

A Boolean value.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

A Boolean value.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

A Boolean value.

Gets whether the first (empty) column/row for the current data field must be hidden (the field's is set to or ).

true if the first (empty) column/row that displays variation data for the current data field must be hidden; otherwise, false.

Gets whether the field can be displayed within the customization form.

true if the field can be displayed within the customization form; otherwise, false.

Gets whether the current field can be filtered via the Prefilter.

true if the current field can be filtered via the Prefilter; otherwise, false.

Specifies whether field values of the specified type can be dispalyed in the PivotGrid control.

value that identifies the field value type to be tested. true if field values of the specified type can be dispalyed in the PivotGrid control; otherwise, false

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

A Boolean value.

Gets whether the current field's values can be sorted by values in other columns/rows.

A Boolean value that specifies whether the current field's values can be sorted by values in other columns/rows.

For internal use.

Gets or sets the field's display caption.

A string specifying the field's display caption.

Provides access to the formatting settings applied to cells.

A object that provides the formatting settings applied to cells.

Toggles the sort order for the current field.

Collapses all rows/columns that correspond to the current column field or row field.

Collapses the column/row that contains the specified value.

An object specifying the value in the grouping column/row which should be collapsed.

Gets the field's unique identifier.

An integer specifying the field's unique identifier.

If the current field is displayed in the Column Header Area, this property gets or sets the height of the field's values, in text lines.

An integer value that specifies the height of the current column field's values, in text lines. Values less than 1 and greater than 5 are not accepted.

Returns the column name in the associated data controller.

A value.

Gets the field's data type.

The .

Provides access to global formatting settings for date/time values.

A object that provides the formatting settings for date/time values.

Provides access to global formatting settings for decimal values.

A object that provides the formatting settings for decimal values.

A default value of the property, which specifies the minimum allowed width of columns that correspond to the current field. Return value: 20

[To be supplied]

Provides access to global formatting settings for percent values.

A object that provides the format settings for percent values.

Provides access to global format settings for total values.

A object that provides the format settings for total values.

A default value of the property, which specifies the width of columns that correspond to the current field. Return value: 100

[To be supplied]

Gets or sets the name of the folder in which the field is located.

A that specifies the name of the folder in which the field is located.

Gets the text displayed by an empty cell.

A string which is the text displayed by an empty data cell.

Gets the text used for an empty field value header.

A string which represents an empty field value.

Expands all columns/rows that correspond to the current column field or row field.

Gets or sets the expansion status of the current field if it belongs to a field group.

true if the field is expanded in a field group; otherwise, false.

Expands the column/row that contains the specified value.

An object which specifies the value in the grouping column/row that should be expanded.

Gets the name by which the field is referred to in unbound expressions.

A representing the name by which the field is referred to in unbound expressions.

Gets the criteria operator used to evaluate values for the current unbound field.

A object that represents the criteria operator.

Gets or sets the name of the database field that is assigned to the current PivotGridFieldBase object.

A value which is the name of the data field.

Gets or sets filter values for the current field.

A object that contains filter values for the current field.

Returns a list of field values that are not excluded by filters applied to other fields and can be displayed.

A list of field values that are not excluded by filters applied to other fields and can be displayed.

Returns a list of field values that are not excluded by filters applied to other fields and can be displayed. Performs this operation asynchronously.

A delegate referencing a method that should be executed after the operation is completed.

Returns the display representation of the specified value, according to the settings used to format field values.

An object which identifies the value to format. A value that represents the specified value formatted for display purposes.

Returns the actual text displayed within the Grand Total's header which corresponds to the current field.

A string that specifies the actual text displayed within the Grand Total's header which corresponds to the current field.

Returns an array of the OLAP members for the current field.

An array containing OLAP members for the field.

Returns an array of the OLAP members for the current field asynchronously.

An delegate referencing a method that should be executed after the operation is completed. The array of the OLAP members is passed to this method as a parameter.

Returns information about the distribution of summary values that have been calculated against this field and belong to the specified aggregation level.

A object that specifies a row field used to identify the aggregation level. A object that specifies a column field used to identify the aggregation level. A object that contains information about the distribution of summary values calculated against this field.

Returns information about the distribution of summary values that have been calculated against this field and belong to the lowest aggregation level.

A object that contains information about the distribution of last-level summary values calculated against this field.

Returns the text displayed within the total header which corresponds to the "Others" row/column.

A string which specifies the default text for the total header which corresponds to the "Others" row/column.

Returns the number of total summaries. This member supports the pivot grid's infrastructure and is not intended to be used directly from your code.

A Boolean value. The number of total summaries.

For internal use.

Returns a formatted text representation of the specified value according to the settings used to represent the headers of column or row totals.

An object which identifies the value to format. A string that specifies the formatted text representation of the specified value.

Returns an array of the unique values which are stored in the underlying data source in the current field.

An array containing the unique values in the current field.

Returns formatting settings corresponding to the specified value type.

A that identifies the required value type. A object that represents the formatting settings for the specified value type.

Returns a formatted text representation of the specified value according to the settings used to format field values.

An object which identifies the value to format. A string that specifies the formatted text representation of the specified value.

Returns a formatted text representation of the specified OLAP member according to the settings used to format field values.

An object implementing the interface. A string that specifies the formatted text representation of the specified OLAP member.

Returns the field values currently shown in the PivotGrid.

A collection of objects that represent the field values currently shown in the PivotGrid.

Provides access to the formatting settings applied to grand total values.

A object that provides the formatting settings applied to grand total values.

Gets or sets the text displayed within the Grand Total's header that corresponds to the current field.

A string that represents the text displayed within the Grand Total's header that corresponds to the current field.

Gets the group which owns the current field.

A object which owns the current field; null if the field doesn't belong to a group.

Gets the filtering mode used for the field's owner group.

A enumeration member that specifies the filtering mode used for the field's owner group.

Gets the index of the field group which owns the current field.

An integer value that specifies the index of the group which owns the current field. -1 if the field doesn't belong to any field group.

Gets or sets how the values of the current column or row field are combined into groups.

A value that specifies how the values of the current field are combined into groups.

Gets or sets the length of the intervals when values are grouped together.

An integer value which specifies the length of the intervals when values are grouped together.

Gets whether the field has null values.

true if the field has null values; otherwise, false.

Returns the string displayed within the field's header, taking into account the field's and the . The field's summary type is appended to the field's Caption if the property is enabled.

A string that specifies the field header's display text.

Gets the hierarchy to which the dimension level represented by the current field belongs.

A that represents the hierarchy to which the dimension level represented by the current field, belongs.

Gets or sets the index of the field in the control's field collection.

A zero-based integer representing the index of the field in the control's field collection.

Gets the index of the field in a field group.

An integer value that specifies the index of the field in the group which owns the current field. -1 if the field doesn't belong to a group.

For internal use.

Returns whether the current field can be positioned within the specified area.

A object which represents the area to test. true if the field can be positioned within the specified area; otherwise, false.

Gets whether the field is displayed within the Column Header Area.

true if the field is displayed within the Column Header Area; otherwise, false.

Gets whether the current field is displayed within the Column Header Area or Row Header Area.

true if the field is displayed within the column header area or row header area.

Gets whether the current PivotGridFieldBase object is bound to a complex field (a complex field name is constructed in the form "String1.String2" or "String1,String2.String3", etc).

true if the current PivotGridFieldBase object is bound to a complex field; otherwise, false.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

A Boolean value.

Returns whether the specified formatting settings match the default ones.

A object that represents the formatting settings that should be compared with the default ones. true if the specified formatting settings match the default ones; otherwise, false.

Gets a value that indicates whether the component is in design mode.

true if the component is in design mode; otherwise, false.

Gets whether field values are grouped into numeric intervals as defined by the property.

true if field values are grouped into numeric intervals; otherwise, false.

Gets or sets whether the field is being loaded.

true if the field is being loaded; otherwise, false.

This member supports the internal infrastructure and is not intended to be used directly from your code.

A Boolean value.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

The Boolean value.

Gets whether the field's FieldName follows the OLAP field naming convention.

true if the field's FieldName follows the OLAP field naming convention; otherwise, false.

Gets whether the specified field name follows the OLAP field naming convention.

A string that represents a field name. true if the specified field name follows the OLAP field naming convention; otherwise, false.

This member supports the internal infrastructure and is not intended to be used directly from your code.

For internal use.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

Gets or sets a value indicating whether there is an unbound expression specified for the pivot grid field via the property.

true if there is an unbound expression specified; otherwise, false.

Gets whether the property's value specifies a valid expression.

true if the property's value specifies a valid expression; otherwise, false.

Gets or sets a graphic set used to indicate KPI values.

A enumeration value that specifies the graphic set used to indicate KPI values.

Gets the KPI type.

A enumeration value that identifies the KPI type.

Specifies the maximum height of column field values, in lines. Return value: 5

[To be supplied]

Specifies the maximum height of row field values, in lines. Return value: 5

[To be supplied]

Specifies the minimum height of column/row field values, in lines. Return value: 1

[To be supplied]

Gets or sets the minimum allowed width of columns that correspond to the current field.

An integer value specifying the minimum allowed width (in pixels) of columns that correspond to the current field.

Gets or sets the field's name.

A string which specifies the field's name.

Gets the prefix that is used to create field names at design time.

A string that specifies the prefix that is used to create field names at design time.

In OLAP mode, gets the name of the corresponding column in the underlying data source, on an OLAP server.

A string that specifies the corresponding column's name.

This method supports the control's internal infrastructure and is not intended to be called directly from your code.

Contains the field's options.

A object which contains the field's options.

Gets the name by which the field is referred to in the Prefilter expression.

A , specifying the name by which the field is referred to in the Prefilter expression.

This member supports the internal infrastructure and is not intended to be used directly from your code.

If the current field is displayed in the Row Header Area, this property gets or sets the height of the field's values, in text lines.

An integer value that specifies the height of the current row field's values, in text lines. Values less than 1 and greater than 5 are not accepted.

Gets or sets whether Running totals are calculated for values in the Data Area that correspond to the current column or row field.

true to calculate Running totals for the current column/row field; otherwise, false.

Gets or sets whether the component is selected at design time.

true if the component is selected at design time; otherwise, false.

Positions the field in the specified area and at the specified location.

A value that specifies the area in which the field is placed. A zero-based integer that specifies the field's index amongst the other fields displayed within the same area. true if the field has been successfully moved to the specified position; otherwise, false.

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

A string value.

Sorts field values by another column's/row's values.

A descendant that represents the field by whose summary values the current field values are sorted. A list of objects representing conditions that identify the column or row by whose summary values the current field values are sorted. A object representing the summary type of custom total values by which the field values are sorted. Null if the field values are not sorted by a custom total column/row. true to apply the specified sorting by summary, false to remove the current sorting by summary.

Gets whether the Filter Button is displayed as active.

true if the Filter Button is displayed as active for the current field; otherwise, false.

Gets whether the Filter Button is visible within the current field's header.

true if the Filter Button is visible for the current field; otherwise, false.

Gets or sets whether field values that have appeared in the datasource after the field's filtering was configured should be shown.

true to show new field values; otherwise, false.

Gets whether the Sort Button is visible in the current field's header.

true if the Sort Button is visible for the current field; otherwise, false.

Contains the settings used to sort the values of the current column field or row field by summary values in rows/columns.

A object which contains the settings used to sort the current field's values by summary values in columns/rows.

Gets or sets how the field's data is sorted when sorting is applied to it.

A value that specifies how the field's data is sorted in sort mode.

Gets or sets the field's sort order.

A value that specifies the field's sort order.

For internal use.

Gets or sets how a summary value calculated against the current data field is represented in a cell.

A value that specifies how summary values are represented within cells.

Gets summary filtering settings.

A object that encapsulates summary filtering settings.

Gets or sets the type of the summary function which is calculated against the current data field.

A enumeration value that specifies the summary function type which is calculated against the current field.

Gets or sets the data associated with the field.

An object containing the information which is associated with the field.

Gets or sets the absolute or relative number of field values that should be displayed for the current column field or row field.

An integer that specifies the number of field values to display for the current column or row field.

For internal use.

Gets or sets whether the "Others" item is displayed within PivotGridControl when the Top X Value feature is enabled.

true if the "Others" item is displayed when the Top X Value feature is enabled; otherwise, false.

Gets or sets how the number of Top Values is determined.

A value that specifies how the number of Top Values is determined.

Returns the field's display text.

A string representing the field's display text.

Provides access to the formatting settings applied to total cells.

A object that provides the formatting settings applied to total cells.

Gets or sets whether totals are displayed for the current field when it is positioned within the Column Header Area or Row Header Area and if so, whether they are automatic or custom.

A value that specifies which totals are displayed for the current field.

Provides access to the formatting settings applied to the total header.

A object that provides the formatting settings applied to the total header.

Gets or sets an expression used to evaluate values for the current unbound field.

A that specifies an expression used to evaluate values for the current field.

For internal use.

Gets or sets the name of a column in a summary data source that corresponds to the current unbound field.

A string value that specifies the name of a column in a summary data source that corresponds to the current field.

Gets or sets the data type and binding mode of the field.

A enumeration value representing the data type and binding mode of the field.

For internal use.

Gets or sets whether to use the current field's data format when the Pivot Grid Control is exported in XLS format.

A value that specifies whether to use the current field's data format when the Pivot Grid Control is exported in XLS format.

Provides access to the formatting settings applied to field values.

A object that provides the formatting settings applied to field values.

Gets or sets whether the field is visible.

true if the field is visible; false otherwise.

Gets or sets the width of columns that correspond to the current field.

An integer value specifying the width of columns that correspond to the current field.

This method supports the internal infrastructure and is not intended to be used directly from your code.

A Boolean value.

This method supports the internal infrastructure and is not intended to be used directly from your code.

A Boolean value.

This method supports the internal infrastructure and is not intended to be used directly from your code.

A Boolean value.

This method supports the internal infrastructure and is not intended to be used directly from your code.

A Boolean value.

This method supports the internal infrastructure and is not intended to be used directly from your code.

A Boolean value.

Lists the values that specify the areas where the pivot grid fields can be displayed.

Corresponds to the Column Header Area.

Corresponds to the Data Header Area.

Corresponds to the Filter Header Area.

Corresponds to the Row Header Area.

Lists the values that specify the sort order of pivot grid fields.

Sorts the field in ascending order.

Sorts the field in descending order.

Serves as the base for classes that provide view options for the PivotGrid controls.

Initializes a new instance of the class.

A delegate that will receive change notifications.

Initializes a new instance of the PivotGridOptionsViewBase class.

A delegate that will receive change notifications. An object which implements the IViewBagOwner interface. The string value.

Gets or sets the location of the column totals.

A enumeration value which specifies the location of column totals.

Specifies the default value for the property.

[To be supplied]

Gets or sets whether a focus rectangle is painted around the currently focused cell.

true to paint a focus rectangle around the focused cell; otherwise, false.

Gets whether the specified field header area is visible.

A value that specifies the field header area. true if the specified field header area is visible; otherwise, false.

Gets or sets whether hidden fields are grouped within the Customization Form.

true if to group hidden fields within the Customization Form; otherwise, false.

Gets or sets the distance (vertical) between field headers.

An integer value that specifies the distance between field headers, in pixels.

Gets or sets the distance (horizontal) between field headers.

An integer value that specifies the distance between field headers, in pixels.

Hides all Totals.

For internal use only.

Resets all options to their default values.

Gets or sets the location of the totals and grand totals.

A enumeration value which specifies the location of totals and grand totals.

Gets or sets the tree offset.

An integer value that specifies the tree offset.

Gets or sets the width of the innermost row field values.

An integer value that specifies the width of the innermost row field values, in pixels.

Simultaneously sets the values of the and properties.

A enumeration value which specifies the new value for both properties.

Shows all Totals.

Gets or sets whether the Grand Total column header is visible when there are two or more data fields.

true if the Grand Total column header is visible; otherwise, false.

Gets or sets whether column Grand Totals are displayed.

true to display column Grand Totals; otherwise, false.

Gets or sets whether column headers are displayed.

true to display the column header area; otherwise, false.

Gets or sets whether column automatic Totals are displayed.

true to display column automatic Totals; otherwise, false.

Gets or sets whether custom totals are displayed for the field values which contain a single nesting field value.

true to display custom totals for any field value; false to display custom totals for the field values which fall into two or more categories.

Gets or sets whether data headers are displayed.

true to display the data header area; otherwise, false.

Gets or sets whether filter headers are displayed.

true to display the filter area; otherwise, false.

Gets or sets whether the horizontal line that separates the Filter Header Area from the Data Area and Column Header Area is displayed.

true to display the separator; otherwise, false.

Gets or sets whether grand totals are displayed when the control lists a single value of an outer column field or row field along its left or top edge.

true if the grand totals are always displayed; false if they are only displayed when the XtraPivotGrid displays two or more values of an outer column (or row) field along its top (or left) edge.

Gets or sets whether horizontal grid lines are displayed.

true to display horizontal grid lines; otherwise, false.

Gets or sets whether the Grand Total row header is visible when there are two or more data fields.

true if the Grand Total row header is visible; otherwise, false.

Gets or sets whether row Grand Totals are displayed.

true to display row Grand Totals; otherwise, false.

Gets or sets whether row headers are displayed.

true to display the row header area; otherwise, false.

Gets or sets whether row automatic Totals are displayed.

true to display row automatic Totals; otherwise, false.

Gets or sets whether automatic totals are displayed for the field values which contain a single nesting field value.

true to display totals for any field value; false to display totals for the field values which fall into two or more categories.

Gets or sets whether vertical grid lines are displayed.

true to display vertical grid lines; otherwise, false.

Serves as a base for classes that represent the Pivot Grid control's options.

Initializes a new instance of the class.

A delegate that will receive change notifications.

Initializes a new instance of the PivotGridOptionsBase class.

A delegate that will receive change notifications. An object which implements the IViewBagOwner interface. The string value.

Copies all the settings from the options object passed as the parameter to the current object.

A descendant whose settings are assigned to the current object.

Fires when any option is changed.

Tests whether the PivotGridOptionsBase object should be persisted.

true if the object should be persisted; otherwise, false.

Contains the values of the predefined summaries calculated for a specific cell.

Initializes a new instance of the PivotSummaryValue class.

A DevExpress.Data.PivotGrid.PivotValueComparerBase descendant used to compare data field values when calculating the Min and Max summaries.

For internal use.

Returns the value of the function for the current cell.

The value of the function for the current cell. If an error occured during calculation, the property's value is returned.

Returns the value of the function for the current cell.

The value of the function for the current cell.

Gets or sets a custom summary value for the current cell.

A custom summary value for the current cell.

Returns a unique object that identifies an error.

An object that identifies an error.

Returns the value of the specified predefined summary.

A value that specifies the required summary type. The value of the specified summary.

Returns the type of values calculated by the specified summary function evaluated upon data of the specified type.

A enumeration member that specifies the type of a summary function. A that specifies the type of data upon which the summary function is evaluated. A that specifies the type of the calculation result.

Returns the value of the function for the current cell.

The value of the function for the current cell. If an error occured during calculation, the property's value is returned.

Returns the value of the function for the current cell.

The value of the function for the current cell. If an error occured during calculation, the property's value is returned.

Returns the value of the function for the current cell.

The value of the function for the current cell. If an error occured during calculation, the property's value is returned.

Returns the value of the function for the current cell.

The value of the function for the current cell. If an error occured during calculation, the property's value is returned.

Returns the value of the function for the current cell.

The value of the function for the current cell. If an error occured during calculation, the property's value is returned.

Gets or sets custom data for the current PivotSummaryValue object.

An object that represents custom data for the current PivotSummaryValue object.

Returns the value of the function for the current cell.

The value of the function for the current cell. If an error occured during calculation, the property's value is returned.

Returns the value of the function for the current cell.

The value of the function for the current cell. If an error occured during calculation, the property's value is returned.

Serves as a base for classes that represent OLAP data sources.

For internal use.

Lists values that specify which layouts can be applied to the Customization Form.

All layouts can be applied to the Customization Form.

The 'Areas Section Only (1 by 4)' layout can be applied to the Customization Form.

The 'Areas Section Only (2 by 2)' layout can be applied to the Customization Form.

The 'Fields Section and Areas Section Stacked' layout can be applied to the Customization Form.

The 'Fields Section and Areas Section Side-By-Side' layout can be applied to the Customization Form.

The 'Fields Section Only' layout can be applied to the Customization Form.

Serves as the base for classes that represent rows in the datasource passed to the chart control.

Gets or sets the argument of a chart point that will represent the current datasource row.

The argument of a chart point that will represent the current datasource row.

Gets or sets the series of a chart point that will represent the current datasource row.

The series of a chart point that will represent the current datasource row.

Gets or sets the value of a chart point that will represent the current datasource row.

The value of a chart point that will represent the current datasource row.

Lists values that specify whether the specified value range and aggregation level are valid.

The specified summary values range and target aggregation level are both invalid.

The specified target aggregation level is invalid.

The specified summary values range is invalid.

The specified summary values range and target aggregation level are both valid.

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.

Columns are passed to the chart when is set to and it is impossible to find the lowest level within the selection.

Rows are passed to the chart when is set to and it is impossible to find the lowest level within the selection.

Lists values that specify which data the pivot grid should pass to a bound chart control.

PivotGrid passes only values from the lowest aggregation level.

PivotGrid determines which values to provide based on the PivotGridOptionsChartDataSourceBase.Provide...Totals property values.

Lists values that specify which data provider should be used when binding to an OLAP cube.

The ADOMD.NET data provider.

The default OLAP provider (see the respective property description for details).

The OLE DB data provider.

The XMLA data access standard.

Lists values that specify how to copy cells to the clipboard when multiple cells are selected.

Columns and rows located between the selected cells (blocks of cells) are not copied to the clipboard.

Columns and rows located between the selected cells (blocks of cells) are copied to the clipboard with their cells empty.

Lists values that specify how to copy collapsed field values to the clipboard.

Collapsed field values are replaced with duplicates of their parent values.

Collapsed field values are not copied but space is reserved for them.

Collapsed field values are not copied and space is not reserved for them.

Contains values that specify the customization form's style.

The Customization Form is represented using the Office 2007 style: An end-user can move fields between areas by dragging their field headers within the Customization Form. When the Defer Layout Update check box is checked, dragging fields doesn't immediately update the layout. To update the layout, click the Update button.

The Customization Form is represented using the Simple style:

Contains values that specify which elements are taken into account when calculating the best-fit width for columns.

The contents of data cells are taken into account when calculating the best-fit size.

This option is the combination of the , and options.

The contents of field headers are taken into account when calculating the best-fit size.

The contents of field values are taken into account when calculating the best-fit size.

The best-fit functionality is disabled.

Provides data specific options for PivotGrid controls.

Initializes a new instance of the PivotGridOptionsData class.

A PivotGridData object which contains the information required to initialize the created PivotGridOptionsData object. An event handler that will fire after options of the created PivotGridOptionsData object have been changed.

Gets or sets whether summary variations and running totals are calculated independently within individual groups, or throughout the Pivot Grid.

true to calculate summary variations and running totals throughout the Pivot Grid; false to calculate them independently within individual groups.

Gets or sets whether field values are expanded or collapsed by default.

to expand field values by default; to collapse them.

Gets or sets whether data is grouped case-sensitively.

true if data is grouped case-sensitively; otherwise, false.

Gets or sets a converter used to serialize/deserialize arbitrary objects in a custom manner.

An object that implements the interface representing a converter used to serialize/deserialize arbitrary objects in a custom manner.

Gets or sets whether unbound expressions for data fields are calculated based on the data source records, or summary values.

One of the enumeration members specifying how the unbound expressions for data fields are calculated.

Gets or sets the maximum number of rows returned when calling the CreateDrillDownDataSource method.

An integer value that specifies the maximum number of rows returned when calling the CreateDrillDownDataSource method.

Gets or sets whether to take into account filter conditions of visible filter fields only.

true to take into account filter conditions of visible filter fields only; false, to take into account filter conditions of all filter fields.

Assigns the specified value to the property.

A enumeration member that specifies whether field values are expanded or collapsed by default. This value is assigned to the property.

Lists values that specify the layout of the Customization Form.

Contains information about the distribution of summary values within a specific range.

Gets the data type of summary values.

A that specifies the data type of summary values.

Gets information about the distribution of summary values across the summary values range.

A list of integer values that defines the number of summary values that fall into each part (subrange) of the summary values range.

An empty range of summary values.

[To be supplied]

Gets the maximum value in the current range.

The maximum summary value in the current range.

Gets whether the data type of summary values is discrete.

true if the data type of summary values is discrete; otherwise, false.

Gets whether the current range contains no summary values.

true if the current range contains no summary values; otherwise, false.

Gets the minimum value in the current range.

The minimum summary value in the current range.

Lists values that specify whether summary filtering should be applied to the last aggregation level or to the specified one.

Summary filtering is applied to cells that belong to the lowest aggregation level (the one identified by the innermost column and row fields).

Summary filtering is applied to cells that belong to an aggregation level specified by an end-user or in code via the and properties.

Contains summary filter settings.

Applies the summary filter with the specified range of values to be displayed.

The minimum value to be displayed. This value is assigned to the property. The maximum value to be displayed. This value is assigned to the property.

Applies the summary filter with settings copied from the specified object.

A object that contains summary filter settings that should be applied to the current data field.

Applies the summary filter with the specified range of values to be displayed. The filter is applied to cells that belong to the specified aggregation level.

The minimum value to be displayed. This value is assigned to the property. The maximum value to be displayed. This value is assigned to the property. A descendant that specifies the row field used to identify the target aggregation level. This value is assigned to the property. A descendant that specifies the column field used to identify the target aggregation level. This value is assigned to the property.

Resets the summary filter.

Gets or sets a column field used to identify an aggregation level to which the filtering is applied.

A descendant that specifies a column field used to identify an aggregation level to which the filtering is applied.

For internal use.

Gets or sets the maximum summary value to be displayed.

The maximum summary value to be displayed.

Gets whether the filter is inactive.

true if the filter is inactive; otherwise, false.

Gets or sets whether summary filtering should be applied to the last aggregation level or to the specified one.

A enumeration member that specifies whether summary filtering should be applied to the last aggregation level or to the specified one.

Gets or sets the row field used to identify an aggregation level to which the filtering is applied.

A descendant that specifies the row field used to identify an aggregation level to which the filtering is applied.

For internal use.

Gets or sets the minimum summary value to be displayed.

The minimum summary value to be displayed

Gets whether the specified value range and aggregation level are valid.

A enumeration member that defines whether the specified value range and aggregation level are valid.

Provides the appearance settings used to print a pivot grid.

Initializes a new instance of the PrintAppearance class with default settings.

Gets the appearance settings used to print data cells.

A value that provides the appearance settings used to print data cells.

Gets the appearance settings used to print custom total cells.

A value that provides the appearance settings used to print custom total cells.

Gets the appearance settings used to print field headers.

A value that provides the appearance settings used to print field headers.

Gets the appearance settings used to print the values of fields and the default appearance settings used to print grand totals and totals.

A value that provides the appearance settings used to print field values.

Gets the appearance settings used to print grand total headers.

A value that provides the appearance settings used to print the grand total headers.

Gets the appearance settings used to print the headers of totals.

A value that provides the appearance settings used to print the headers of totals.

Gets the appearance settings used to print grand total cells.

A value that provides the appearance settings used to print grand total cells.

Gets the appearance settings used to print the horizontal and vertical lines.

A value that provides the appearance settings used to print grid lines.

Resets the properties of all the appearance objects within the collection to their default values.

Tests whether or not the should be persisted.

true if the object should be persisted; otherwise, false.

Returns the textual representation of PrintAppearance.

A value.

Gets the appearance settings used to print automatic total cells.

A value that provides the appearance settings used to print automatic total cells.

Serves as a base for classes that provide data for the CustomExportHeader event.

Initializes a new instance of the CustomExportHeaderEventArgsBase class with the specified settings.

An object implementing the IVisualBrick interface or its descendant. A PivotFieldItemBase class descendant. A class descendant that specifies the processed field.

Gets the processed field caption.

A that specifies the processed field caption.

Gets the processed field.

A class descendant that specifies the processed field.

A datasource used to access OLAP data via XMLA.

Initializes a new instance of the PivotGridXmlaDataSource class.

Specifies parameters used to connect to a data pump.

A that encapsulates parameters used to connect to a data pump.

Serves as a base for classes that provide data for the CustomExportCell event.

Initializes a new instance of the CustomExportCellEventArgsBase class with the specified settings.

An object implementing the IVisualBrick interface or its descendant. A PivotGridCellItem object. A enumeration value that specifies the unit of measurement for the given data. An object implementing the IPivotPrintAppearance interface or its descendant. A PivotGridPrinterBase class descendant.

For internal use.

Gets the visual index of the column that contains the current cell.

An integer value that specifies the visual index of the column that contains the current cell.

Gets information about a column field value that corresponds to the current cell.

A PivotFieldValueItem object that provides information about a column field value that corresponds to the current cell.

Gets the type of formatting.

A enumeration value that specifies the formatting type.

Gets whether the processed cell text is entirely displayed.

true if the cell text is entirely displayed; false if the cell text is clipped.

For internal use.

Gets the visual index of the row that contains the current cell.

An integer value that specifies the visual index of the row that contains the current cell.

Gets information about a row field value that corresponds to the current cell.

A PivotFieldValueItem object that provides information about a row field value that corresponds to the current cell.

Gets the text displayed within the processed cell.

A string value that specifies the cell display text.

Gets the processed cell value.

An object that specifies the cell value.

The base class for classes that provide options controlling the display of the PivotGrid's data in a chart control.

Initializes a new instance of the PivotGridOptionsChartDataSourceBase class.

A DevExpress.XtraPivotGrid.Data.PivotGridData object.

Copies all settings from the options object passed as the parameter to the current object.

A descendant whose settings should be assigned to the current object.

Gets or sets whether a bound chart control should be transposed if the number of series exceeds the number of argument values.

true to transpose a bound chart control if the number of series exceeds the number of argument values; otherwise, false.

Gets or sets what data the pivot grid should pass to a bound chart control.

A enumeration member that specifies what data the pivot grid should pass to a bound chart control.

Gets or sets whether the pivot grid should pass columns or rows to a bound chart control when it is impossible to find the lowest-level data.

A enumeration member that specifies whether the pivot grid should pass columns or rows to a bound chart control.

The default maximum allowed number of points in a series. Return value: 0 (no limit).

[To be supplied]

The default maximum allowed number of series in the chart data source. Return value: 0 (no limit).

[To be supplied]

Gets or sets how field values are passed to the chart control.

One of the enumeration members that specifies how field values are passed to the chart control.

Gets or sets the maximum number of points allowed in a series.

An integer value that specifies the maximum number of points allowed in a series; 0 for no limit.

Gets or sets the maximum number of series allowed in the chart data source.

An integer value that specifies the maximum number of series allowed in the chart data source; 0 for no limit.

Gets or sets the type to which cell values are converted, before they are exported to the Chart Control.

A object, representing the type to which cell values are converted.

Gets or sets whether column custom totals should be passed to a chart control.

true if column custom totals should be displayed in a chart control; otherwise, false.

Gets or sets the type to which the column field values are converted before they are exported to the chart control.

A object representing the type to which the column field values are converted.

Gets or sets whether column grand totals are passed to a chart control.

true if column grand totals are displayed in a chart control; otherwise, false.

Gets or sets whether column totals are passed to a chart control.

true if column totals are displayed in a chart control; otherwise, false.

Gets or sets whether series in a chart control are created for PivotGrid columns or rows.

true if PivotGrid columns are represented by series in a chart control; false if PivotGrid rows are represented by series in a chart control.

For internal use.

Gets or sets whether empty cells should be processed by the Chart control.

true if empty cells should be processed by the Chart control; otherwise, false.

Gets or sets whether row custom totals should be displayed in a chart control.

true if row custom totals should be displayed in a chart control; otherwise, false.

Gets or sets the type to which the row field values are converted, before they are exported to the chart control.

A object, representing the type to which the row field values are converted.

Gets or sets whether row grand totals are passed to a chart control.

true if row grand totals are displayed in a chart control; otherwise, false.

Gets or sets whether row totals are passed to a chart control.

true if row totals are displayed in a chart control; otherwise, false.

Gets whether any PivotGrid total should not be displayed within a chart control.

true if any total PivotGrid total should not be displayed within a chart control; otherwise, false.

Contains options controlling the display of the PivotGrid's data in a .

Initializes a new instance of the PivotGridOptionsChartDataSource class.

A DevExpress.XtraPivotGrid.Data.PivotGridData object

The default delay between changing the cell focus or selection, and updating the bound Chart control, in milliseconds. Return value: 500

[To be supplied]

Gets or sets whether a chart control must display selected cells or all the data of the PivotGrid control.

true if only selected data is displayed in a chart control; false if all the data is displayed in a chart control.

Gets or sets the delay between changing the cell focus or selection, and updating the bound Chart control.

An integer value that specifies the Chart control update delay, in milliseconds.

Provides thread-safe access to pivot grid data.

Gets the number of columns displayed in the pivot grid.

An integer value that specifies the number of columns displayed in the pivot grid.

Provides thread safe access to a pivot grid field collection.

An object that implements the interface. Provides thread safe read-only access to the collection of fields.

Returns text displayed in the specified cell.

A zero-based integer value that specifies the index of the column where the cell resides. A zero-based integer value that specifies the index of the row where the cell resides. A that specifies text displayed in the specified cell.

Returns a field located at the specified visual position in the specified area.

A value that identifies the area containing the required field. An integer value that specifies the visible index of the field within the specified area. An object that implements the interface. Provides thread safe read-only access to basic field settings.

Returns the field located in the specified area at the specified level.

true to obtain a column field; false to obtain a row field. A zero-based integer value that specifies the field level. An object that implements the interface. Provides thread safe read-only access to basic field settings.

Returns the number of fields located in the specified area.

A enumeration member that specifies the area. An integer value that specifies the number of fields located in the specified area.

Returns a list of fields displayed in the specified area.

A enumeration member that identifies a pivot grid area. A list of visible fields displayed in the specified area.

Returns the display representation of the specified field value.

An object that implements the interface. Identifies a field that owns the value whose display representation should be returned. A zero-based index of a cell in the Data Area that identifies the required field value. Indexes are numbered starting from the left edge for column fields, and from the top edge for row fields. A that specifies the display representation of the specified field value.

Provides thread safe access to a pivot grid group collection.

An object that implements the interface. Provides thread safe read-only access to the collection of field groups.

Gets whether an asynchronous operation is currently being performed.

true if an asynchronous operation is currently being performed; otherwise, false.

Gets the number of rows displayed in the pivot grid.

An integer value that specifies the number of rows displayed in the pivot grid.

Provides thread-safe access to the field groups collection.

Gets the number of groups in the collection.

An integer value that specifies the number of groups in the collection.

Provides indexed access to individual groups within the collection.

A zero-based integer value that specifies the index of the required group. An object that implements the interface. Provides thread safe read-only access to basic group settings.

Provides thread-safe access to a field group.

Gets the area of the pivot grid in which the group is displayed.

A enumeration value that specifies the area in which the group is displayed.

Gets the group's caption.

A value that specifies the group's caption.

Provides access to the group's field collection.

An object that implements the interface. Provides thread safe read-only access to the collection of fields.

Gets the name of the hierarchy to which the current field group belongs.

A that specifies the name of the hierarchy to which the current field group belongs.

Gets the group's position within the collection that owns it.

A zero-based integer that specifies the group's position within the collection that owns it. -1 if the group is not contained within a collection.

Gets whether the group is visible.

true if the group is visible; otherwise, false.

Gets the number of visible fields within the current group.

An integer that specifies the number of visible fields within the group.

Provides thread-safe access to a pivot grid field.

Gets areas within which the field can be positioned.

A value that specifies in which areas the field can be positioned.

Gets the area in which the field is displayed.

A value that specifies the area in which the field is displayed.

Gets the field index from among the other fields displayed within the same area.

A zero-based integer that specifies the field index among the other fields displayed within the same area.

Gets the field's display caption.

A string specifying the field's display caption.

Gets the field's data type.

The .

Gets the name of the folder in which the field is located.

A that specifies the name of the folder in which the field is located.

Gets the expansion status of the current field if it belongs to a field group.

true if the field is expanded in a field group; otherwise, false.

Gets the name of the data source field assigned to the current pivot grid field.

A value specifying the name of the data source field.

Gets the group which owns the current field.

An object that implements the interface. Specifies a group that owns the current field. null if the field does not belong to a group.

Gets the index of the field group that owns the current field.

An integer value that specifies the index of the group that owns the current field. -1 if the field does not belong to a field group.

Gets how values of the current column or row field are combined into groups.

A value that specifies how values of the current field are combined into groups.

Gets the length of intervals when values are grouped together.

An integer value that specifies the length of intervals when values are grouped together.

Gets or sets the field's name.

A that specifies the field's name.

Gets the name by which the field is referred to in the Prefilter expression.

A , specifying the name by which the field is referred to in the Prefilter expression.

Gets whether Running totals are calculated for values in the Data Area that correspond to the current column or row field.

true to calculate Running totals for the current column/row field; otherwise, false.

Gets whether field values that have appeared in the datasource after the field's filtering was configured should be shown.

true to show new field values; otherwise, false.

Gets how the field's data is sorted when sorting is applied to it.

A value that specifies how the field's data is sorted in sort mode.

Gets the field's sort order.

A value that specifies the field's sort order.

Gets the type of the summary function which is calculated against the current data field.

A enumeration value that specifies the summary function type which is calculated against the current field.

Gets the data associated with the field.

An object containing the information which is associated with the field.

Gets the absolute or relative number of field values displayed for the current column field or row field.

An integer that specifies the number of field values to display for the current column or row field.

Gets whether the "Others" item is displayed within PivotGridControl when the Top N Value feature is enabled.

true if the "Others" item is displayed when the Top N Value feature is enabled; otherwise, false.

Gets how the number of Top Values is determined.

A value that specifies how the number of Top Values is determined.

Gets or sets an expression used to evaluate values for the current unbound field.

A that specifies an expression used to evaluate values for the current field.

Gets the name of a column in a summary data source that corresponds to the current unbound field.

A that specifies the name of a column in a summary data source that corresponds to the current field.

Gets the data type and binding mode of the field.

A enumeration value specifying the data type and binding mode of the field.

Gets or sets whether the field is visible.

true if the field is visible; false otherwise.

Serves as a base for classes that provide data for the CustomFieldSort event.

Initializes a new instance of the PivotGridCustomFieldSortEventArgsBase class.

A PivotGridData object. A class descendant that specifies the processed field.

For internal use.

Gets the field whose values are being compared.

A class descendant that specifies the field whose values are being compared.

Gets a value from the specified row and column.

An integer value that specifies the index of the row in the data source. A that specifies the name of the column. A value from the specified row and column.

For internal use.

Gets or sets whether a comparison operation is being handled, so no default processing is required.

true if a comparison operation is being handled; otherwise false.

Gets the index in the data source for the first of the two rows being compared.

An integer value that specifies the index of the first row in the data source.

Gets the index in the data source for the second of the two rows being compared.

An integer value that specifies the index of the second row in the data source.

Gets or sets the result of a custom comparison.

An integer value that specifies the custom comparison result.

For internal use.

An integer value that specifies the index of the first data row. An integer value that specifies the index of the second data row. An object that specifies the first value being compared. An object that specifies the second value being compared. A enumeration value that specifies the sort order.

Gets the sort order applied to the field.

A enumeration value that specifies the field sort order.

Gets the first value being compared.

An object that specifies the first value being compared.

Gets the second value being compared.

An object that specifies the second value being compared.

The result of the asynchronous operation.

Gets an exception thrown during the asynchronous operation execution.

A object that provides information on the exception that has been thrown; null (Nothing in Visual Basic) if no exception has been thrown.

Gets the result of the asynchronous operation.

The result of the asynchronous operation.

Serves as the base for classes that provide behavior options for the PivotGrid controls.

Initializes a new instance of the PivotGridOptionsBehaviorBase class with the specified settings.

A delegate that will receive change notifications.

Gets or sets which visual elements are taken into account when calculating the optimal width for columns.

A enumeration member that specifies which visual elements are taken into account when calculating the optimal width for columns.

Gets or sets how to copy collapsed field values to the clipboard.

A enumeration value that specifies how to copy collapsed field values to the clipboard.

Gets or sets how to copy cells to the clipboard when multiple cells are selected.

A enumeration value that specifies how to copy cells to the clipboard when multiple cells are selected.

Gets or sets whether field values are copied to the clipboard when CTRL+C is pressed or the method is called.

true if field values are copied to the clipboard when CTRL+C is pressed or the method is called; otherwise, false.

The default delay between starting an asynchronous operation and displaying the loading panel.

[To be supplied]

Gets or sets the delay between starting an asynchronous operation and displaying the loading panel.

An integer value that specifies the delay before displaying the loading panel, in milliseconds.

Gets or sets the sort order applied to a field when sorting by summaries is enabled for it.

A enumeration member that specifies the sort order applied to a field when sorting by summaries is enabled for it.

Gets or sets whether data-aware operations caused by end-user actions are performed asynchronously.

true to perform operations caused by end-user actions asynchronously; otherwise, false.

Contains print page settings.

Initializes a new instance of the PivotGridPageSettings class.

Copies all the settings from the PivotGridPageSettings object passed as a parameter.

A PivotGridPageSettings object whose settings are assigned to the current object.

Returns whether the settings of the current object are equal to the default settings.

true if the settings of the current object are equal to the default settings; otherwise, false.

Gets or sets a value indicating whether the page orientation is landscape.

true if the page orientation is landscape; false if the page orientation is portrait.

Gets or sets the margins of a print page.

The margins (in hundredths of an inch) of a print page.

Gets or sets a custom height of the paper, in hundredths of an inch. The property is in effect when the property is set to Custom.

The height of the paper, in hundredths of an inch.

Gets or sets the type of paper for the document.

A enumeration value.

Gets or sets a custom width of the paper, in hundredths of an inch. The property is in effect when the property is set to Custom.

The width of the paper, in hundredths of an inch.

Sets settings provided by the PivotGridPageSettings class to the default values.

Creates and returns a new object with the same settings as the current PivotGridPageSettings object.

A object whose settings are identical to the settings provided by the current PivotGridPageSettings object.

Returns a string representation of the current object.

A string representation of the current object.

References a method executed after an asynchronous operation is completed.

An object that specifies the result of the asynchronous operation.

Lists values that specify the sort order applied to a field when sorting by summaries is enabled for it.

Field values are sorted in ascending order.

The sort order is not changed.

Field values are sorted in descending order.

Serves as a base for classes that provide data for the events which are used to customize column and row headers.

Initializes a new instance of the class.

A class descendant that contains information used to initialize a new object.

Initializes a new instance of the class.

A PivotFieldValueItem class descendant that contains information used to initialize a new object.

Changes the expanded state of the field value currently being processed.

Returns a list of records that are used to calculate a summary value for the specified cell.

A object that contains records associated with the processed cell.

In OLAP mode, returns a list of records used to calculate a summary value for the specified cell.

An integer value that specifies the maximum number of data rows to be returned. A list of columns to be returned. A object that contains the underlying data for the processed cell.

Gets the custom total that corresponds to the currently processed column/row header.

A class descendant that specifies the custom total that corresponds to the currently processed column/row header.

For internal use.

Gets the data field that specifies the processed value.

A class descendant that represents the data field.

Gets the field position among the visible fields within the header area.

An integer value that specifies the field position among the visible fields.

Returns a value displayed in the specified cell.

A zero-based integer value that specifies the column index where the cell resides. A zero-based integer value that specifies the row index where the cell resides. A value displayed in the specified cell.

Returns the specified column or row field value for the cell, addressed by its zero-based index in the Data Area.

A class descendant that specifies a column or row field, whose value is to be obtained. A zero-based cell index in the Data Area that specifies the required field value. An object that specifies the field value.

Returns the parent field for the field value currently being processed.

An array of class descendants that specify parent fields for the field value currently being processed.

Returns the value of a specific parent field corresponding to the field value currently being processed.

A class descendant that specifies the parent field whose value is returned. An object that specifies the value of the parent field.

Gets whether the processed field value is collapsed.

true , if the field value is collapsed; otherwise, false.

Gets whether the field is displayed within the Column Header Area.

true, if the field is displayed within the Column Header Area; otherwise, false.

Gets or sets whether the current header corresponds to the "Others" row/column.

true, if the current header corresponds to the "Others" row/column; otherwise, false.

For internal use.

Gets the maximum row index (for row fields) or column index (for column fields) that corresponds to the processed field value.

An integer value that specifies the maximum row or column index that corresponds to the processed field value.

Gets the minimum row index (for row fields) or column index (for column fields) that corresponds to the processed field value.

An integer value that specifies the minimum row or column index that corresponds to the processed field value.

Gets the column field or row field value that corresponds to the currently processed column/row header.

The field value currently being processed.

Gets the type of the currently processed header of a column or a row.

A enumeration value that specifies the type of the currently processed column or row header.

Represents a summary data source row.

Initializes a new instance of the PivotSummaryDataRow class.

A object that represents the parent summary data source. An integer value that specifies the index of the row in the summary data source. An integer value that specifies the index of the pivot grid column where the cell represented by the summary row resides. An integer value that specifies the index of the pivot grid row where the cell represented by the summary row resides.

Gets the index of the pivot grid column where the cell represented by the summary row resides.

An integer value that specifies the index of the pivot grid column where the cell represented by the summary row resides.

Gets the parent summary data source.

A object that represents the parent summary data source.

Gets the index of the current row in the summary data source.

An integer value that specifies the zero-based index of the current row in the summary data source.

Provides access to the cells in the current row by the name of the corresponding field.

A that specifies the name of the field. The value of the cell that corresponds to the specified field.

Provides access to the cells in the current row by the corresponding pivot grid field.

A object that represents the pivot grid field. The value of the cell that corresponds to the specified pivot grid field.

Provides indexed access to the cells in the current row.

An integer value that specifies the zero-based index of the summary data source column. The value of the cell that resides in the column with the specified index.

Gets the location of the pivot grid cell represented by the current summary row.

A object that represents the location of the corresponding pivot grid cell.

Gets the index of the pivot grid row where the cell represented by the summary row resides.

An integer value that specifies the index of the pivot grid row where the cell represented by the summary row resides.

Serves as a base for classes that provide data for all field-related events.

Initializes a new instance of the PivotFieldEventArgsBase class.

A class descendant that specifies the processed field.

Gets the field being processed.

A descendant that specifies the processed field.

Contains options that specify how a control layout is stored to, and restored from a storage (a stream, XML file or system registry).

Initializes a new instance of the PivotGridOptionsLayout class.

Gets or sets whether to retain field groups that exist in the current control layout, but do not exist in the layout being restored.

true to retain field groups that exist in the current control layout, but do not exist in the layout being restored; false to destroy such field groups.

Copies all settings from the options object passed as the parameter to the current object.

A descendant whose settings should be assigned to the current object.

Gets or sets which options are reset before loading the layout.

A combination of flags, specifying which options are reset before loading the layout.

Tests whether the PivotGridOptionsLayout object should be persisted.

true if the object should be persisted; otherwise, false.

Gets or sets whether options that specify how a pivot grid layout is stored/restored from a storage are stored/restored from the storage together with the layout.

true, if options that specify how a pivot grid layout is stored/restored from a storage are stored/restored from the storage together with the layout; otherwise, false.

Lists values that specify the Prefilter state.

Prefilter is in an invalid state, which indicates that the Prefilter expression is incorrect.

Prefilter is in a normal state, which indicates that the Prefilter expression is correct.

Serves as a base for classes that provide data for the CustomFieldValueCells event.

Returns the header of the column/row whose summary values match the specified condition.

true to locate a column; false to locate a row. A that specifies the condition used to locate the column/row. A class descendant that specifies the header of the column/row whose summary values match the specified predicate; null if no columns/rows match the predicate.

Returns the field value cell by its index.

true to obtain the column field value cell; false to obtain the row field value cell. An integer value that identifies the zero-based index of the cell. A class descendant that specifies the required cell; null if the index is out of bounds.

Splits all field value cells that match the specified condition, or only the first matching cell.

true to process column field value cells; false to process row field value cells. A that specifies the condition used to define which cells should be split. true to split only the first cell that matches the specified condition; false to split all cells that match the condition. The objects that define how to split the cells.

Splits all field value cells that match the specified condition.

true to process column field value cells; false to process row field value cells. A that specifies the condition used to define which cells should be split. The objects that define how to split the cells.

Splits all field value cells that match the specified condition.

true to process column field value cells; false to process row field value cells. A that specifies the condition used to define which cells should be split. A list of objects that define how to split the cells.

Splits all field value cells that match the specified condition, or only the first matching cell.

Lists values that specify the location of the row and grand totals.

Row Totals are displayed under the row field values.

Row Totals and Grand Totals are displayed above the row field values.

Row Totals are displayed in a compact tree-like layout view.

Serves as a base for classes that provide data for the CustomGroupInterval event.

Initializes a new instance of the PivotCustomGroupIntervalEventArgsBase class.

A class descendant that specifies the processed field. An object that specifies the currently processed value.

Gets or sets a group value.

An object that specifies the group value.

Gets the processed field value.

An object that specifies the processed field value.

Stores the vertical and horizontal alignment settings of a cell's text.

Initializes a new instance of the PrintTextOptions object with default settings.

Specifies the horizontal alignment of text.

A value, specifying the text horizontal alignment.

Restores the cell's horizontal and vertical text alignment settings to their default values.

Specifies the text trimming mode.

A enumeration value.

Specifies the vertical alignment of text.

A value, specifying the text horizontal alignment.

Gets or sets text wrapping mode.

A value that specifies text wrapping mode.

Serves as a base for classes that provide data for summary calculation events.

Initializes a new instance of the class with the specified settings.

A PivotGridData object that contains the information required to initialize the created object. A class descendant that specifies a data field. A PivotCustomSummaryInfo object that contains the information required to initialize the created object.

Gets the column field that corresponds to the current cell.

A class descendant that represents the column field.

Gets the value of the column field that corresponds to the current cell.

An object that represents the value of the corresponding column field.

Returns a list of the records that are associated with the cell currently being processed.

A object that contains the records which are associated with the current cell.

Gets or sets a custom summary value.

An object that represents a custom summary value.

Gets the data field against which the summary is calculated.

A class descendant that specifies the data field against which the summary is calculated.

Gets the name of the data field against which the summary is calculated.

A string that specifies the name of the corresponding data field.

Gets the row field that corresponds to the current cell.

A class descendant that specifies the row field.

Gets the value of the row field that corresponds to the current cell.

An object that represents the value of the corresponding row field.

Gets an object that contains the values of the predefined summaries which are calculated for the current cell.

A object that contains the values of the predefined summaries that are calculated for the current cell.

Lists values that specify the ADOMD.NET version that should be used to communicate with an OLAP server.

ADOMD.NET 10 is used.

ADOMD.NET 11 is used.

ADOMD.NET 12 is used.

ADOMD.NET 9 is used.

The base class for classes that provide information to events that fire when exporting cells and field values.

Initializes a new instance of the CustomPrintEventArgs object with the specified brick.

An object implementing the DevExpress.XtraPrinting.IVisualBrick interface that is used to initialize the property.

Provides access to the brick that represents the contents and appearance of a cell, when it is printed or exported.

An object implementing the DevExpress.XtraPrinting.IVisualBrick interface or its descendant (e.g., DevExpress.XtraPrinting.ITextBrick, DevExpress.XtraPrinting.IImageBrick, etc.).

Lists values that specify for which fields the pivot grid processes only data related to their default members.

The Pivot Grid processes only data related to fields' default members for all filter fields, except for those fields whose filter condition is not set to 'Show All'.

The Pivot Grid processes only data related to fields' default members for filter fields that are not visible.

Lists values that specify the filtering mode used for grouped fields.

The pivot grid control's data, loaded from a file or stream.

Initializes a new instance of the PivotFileDataSource class, and loads pivot grid data from the specified file.

A that specifies the name of the file from which to load data.

Initializes a new instance of the PivotFileDataSource class, and loads pivot grid data from the specified stream.

A object that represents the stream from which to load data.

Initializes a new instance of the PivotFileDataSource class.

An object that implements the interface, which is a custom serializer.

Initializes a new instance of the PivotFileDataSource class, and loads pivot grid data from the specified stream.

A object that represents the stream from which to load data. An object that implements the interface, which is a custom serializer.

Initializes a new instance of the PivotFileDataSource class, and loads pivot grid data from the specified file.

A that specifies the name of the file from which to load data. An object that implements the interface, which is a custom serializer.

For internal use.