DevExpress.XtraPivotGrid.v10.1.Core
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 collapse button.
Default value: [Collapse]
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 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 ascending sorting image.
Default value: (Ascending)
The alternative text for the descending sorting image.
Default value: (Descending)
Not used.
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 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
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 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 list item used to hide all field values.
Default value: (Hide All)
The caption of the filter dropdown list item used to hide blank values.
Default value: (Hide Blanks)
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 the combo box displayed within the filter dropdown, and used to specify the filter type.
Default value: Filter Type
The caption of the combo box item used to set the excluded filter type.
Default value: Hide selected values
The caption of the combo box item used to set the included filter type.
Default value: Show selected values
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 'measures' tree item displayed in the field section of the Customization Form in the OLAP mode.
Default value: Measures
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 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 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 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 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
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 name of the specified filter type.
A enumeration value identifying the filter type.
A corresponding to the specified filter type.
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.
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.
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.
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.
Use the event instead.
Gets or sets whether series in a chart control are created based on 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.
Gets or sets the type to which the cell values are converted before they are exported to the chart control.
A object representing the type to which the cell values are converted.
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 how field values are exported to the chart control.
One of the enumeration members that specifies how field values are exported to the chart control.
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.
Returns whether a total, custom total or grand total must be hidden in a chart control, according to the options of the PivotGridOptionsChartDataSourceBase object.
A Boolean value that specifies whether a total to be tested is displayed as a column or row.
A object that identifies the type of total to test.
true if the specified total must not be 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.
Gets or sets whether data of column custom totals should be displayed in a chart control.
true if column custom totals should be displayed in a chart control; false if column custom totals are hidden in a chart control.
Gets or sets whether data of column grand totals is displayed in a chart control.
true if data of column grand totals is displayed in a chart control; false if this data is hidden in a chart control.
Gets or sets whether data of column totals is displayed in a chart control.
true if data of column totals is displayed in a chart control; false if this data is hidden in a chart control.
Gets or sets whether data of row custom totals should be displayed in a chart control.
true if row custom totals should be displayed in a chart control; false if row custom totals are hidden in a chart control.
Gets or sets whether data of row grand totals is displayed in a chart control.
true if data of row grand totals is displayed in a chart control; false if this data is hidden in a chart control.
Gets or sets whether data of row totals is displayed in a chart control.
true if data of row totals is displayed in a chart control; false if this data is hidden in a chart control.
Contains options controlling the display of the PivotGrid's data in a .
Initializes a new instance of the PivotGridOptionsChartDataSource class.
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.
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 dropdown options are reset.
Hint options are reset.
Menu options are reset.
OLAP options are reset.
Print options are reset.
Selection options are reset.
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 are calculated independently within individual groups or throughout the PivotGridControl.
A Boolean value that specifies whether summary variations are calculated independently within individual groups or throughout the PivotGridControl.
Gets or sets whether data is grouped case-sensitive.
true if data is grouped case-sensitive; otherwise, false.
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.
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".
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.
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.
The percentage variance between the current value and the previously calculated value for the current field is displayed in the cell.
When implemented, represents an OLAP member.
Gets the unique name of the OLAP member.
A string that represents the unique name of the OLAP member.
Gets the value of the OLAP member.
An object that represents the value of the OLAP member.
Represents a method that will handle the event.
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 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.
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.
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.
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.
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.
The property determines the percentage ratio of top field values that are to be displayed relative to the total number of field values. For instance, if there are 20 unique field values and the TopValueCount property is set to 10, only 2 top field values (10% out of 20) will be displayed.
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. This option is in effect only 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).
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 whether field values are copied to the clipboard when CTRL+C is pressed or the CopySelectionToClipboard method is called.
true if field values are copied to the clipboard when CTRL+C is pressed or the CopySelectionToClipboard method is called; otherwise, false.
Provides "OLAP mode"-specific options for a PivotGrid control.
Initializes a new instance of the PivotGridOptionsOLAP class.
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.
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 relative importance to a KPI.
Contains the values of the predefiend summaries calculated for a specific cell.
Initializes a new instance of the PivotSummaryValue class.
A ValueComparer 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.
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 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.
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.
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.
Use the event instead.
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.
Gets whether any filter criteria are assigned to the PrefilterBase object via the or property.
true if any filter criteria are assigned to the PrefilterBase object; otherwise, false.
Gets the names of all fields contained in the Prefilter expression.
A list of the objects that represent the field names.
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.
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.
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 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 XtraPivotGrid 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 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 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 won'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.
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.
Contains options that specify how a control's layout is stored to and restored from storage (a stream, xml file or system registry).
Initializes a new instance of the class.
Gets or sets whether the field groups that exist in the current control but do not exist in a layout when it's restored should be retained.
true to retain the field groups that exist in the current control's layout but don't exist in the layout being restored; false to destroy such field groups.
Gets or sets which options are reset before loading the layout.
A enumeration member, specifying which options are reset before loading the layout.
Tests whether the OptionsLayoutPivotGrid object should be persisted.
true if the object should be persisted; otherwise, false.
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.
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.
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.
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.
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 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 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.
@nbsp;
@nbsp;
This member supports the internal infrastructure and is not intended to be used directly from your code.
@nbsp;
@nbsp;
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.
Searches for the specified record and returns the index of the first occurrence within the entire list.
The record to locate.
The zero-based index of the first occurrence of the value parameter. -1 if value is not in the list.
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.
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.
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.
If is set to , the Contains method returns true, if the array contains the specified value.
If is set to , the Contains method returns true, if the array doesn't contain the specified value.
An object to locate in the array.
A Boolean value.
This member supports the internal infrastructure and is not intended to be used directly from your code.
@nbsp;
@nbsp;
@nbsp;
Gets the number of elements in the array.
An integer value which specifies the number of elements in the array.
Gets the field which owns the current collection.
A object 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.
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 collection's contents match the contents of the specified array.
An array of values to be compared with the current collection.
true if the collection's contents match the contents of the specified array; otherwise, false.
Removes the specified element from the array.
An object which represents the element to remove.
Adds the specified values to the collection and sets the and properties to the specified values.
An array of objects which represent the filter values to add to the collection.
A value that specifies the current field's filter type.
A Boolean value that specifies whether the PivotGrid control should process the records which contain NULL values in the current field.
Adds the specified values to the collection and sets the and properties to the specified values.
An array of objects which represent the filter values to add to the collection.
A value that specifies the current field's filter type.
A Boolean value that specifies whether the PivotGrid control should process the records which contain NULL values in the current field.
true to allow raising OnChanged events; otherwise, false.
An array of objects which represent the filter values to add to the collection.
Gets or sets whether the records which contain NULL values in the current field should be processed by the control.
true if the records which 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.
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 at the same time.
An integer value that specifies the maximum number of rows that can be selected at the same time. -1 if any number of rows can be selected.
Gets the maximum number of columns that can be selected at the same time.
An integer value that specifies the maximum number of columns that can be selected at the same time. -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 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 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 expand buttons are displayed.
true to display expand buttons; 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 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.
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 PivotGridFieldSortConditionCollection 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.
@nbsp;
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.
This member supports the infrastructure and cannot be used directly from your code.
@nbsp;
This member supports the infrastructure and cannot be used directly from your code.
@nbsp;
@nbsp;
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.
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 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 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 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 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 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.
Specifies whether calculations should be performed manually using a specially designed event.
In the XtraPivotGrid control handle the event to calculate custom summaries.
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 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 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 to use the WHERE or sub-select clause in MDX query when filtering against filter fields in OLAP mode.
true to use the WHERE clause when filtering against filter fields in OLAP mode; false to use a sub-select clause.
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 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 won't need to use it.
Gets the default height of Field Value boxes.
An integer value that specifies the default height of Field Value boxes.
Gets the default width of Field Value boxes.
An integer value that specifies the default width of Field Value boxes.
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.
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.
@nbsp;
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 of the XtraPivotGrid 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.
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.
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 the rows/columns which 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 decimal values.
A object that provides the formatting settings for decimal values.
Provides access to global formatting settings for percent values.
A object that provides the formatting settings for percent values.
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 which 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 the filter values for the current field.
A object which contains filter values for the current field.
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 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.
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.
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 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 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.
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.
Gets a value that indicates whether the component is in design mode.
true if the component is in design mode; otherwise, false.
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.
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.
@nbsp;
This member supports the internal infrastructure and is not intended to be used directly from your code.
@nbsp;
This member supports the internal infrastructure and is not intended to be used directly from your code.
@nbsp;
This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
@nbsp;
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. This property returns 5.
[To be supplied]
Specifies the maximum height of row field values, in lines. This property returns 5.
[To be supplied]
Specifies the minimum height of column/row field values, in lines. This property returns 1.
[To be supplied]
Gets or sets the minimum width of each column which corresponds to the current field.
An integer specifying the minimum width (in pixels) of each column which corresponds 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, this method 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.
@nbsp;
This method supports the control's internal infrastructure and is not intended to be called directly from your code.
This method supports the control's internal infrastructure and is not intended to be called directly from your code.
@nbsp;
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.
This member supports the internal infrastructure and is not intended to be used directly from your code.
@nbsp;
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 visible within the current field's header.
true if the Filter Button is visible for the current field; 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.
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 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 how a summary value calculated against the current data field is represented in a cell.
@nbsp;
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 are to 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.
Gets or sets whether the "Others" item is displayed within the XtraPivotGrid 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 string that represents an expression used to evaluate values for the current field.
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.
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 each column which corresponds to the current field.
An integer value specifying the width of each column which corresponds 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 a pivot grid's 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 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 and Grand 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 and Grand 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.
Gets or sets the location of the totals and grand totals.
A enumeration value which specifies the location of the totals and grand totals.
Serves as a base for classes that represent the Pivot Grid control's options.
Initializes a new instance of the class.
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.
Provides data for summary calculation events.
Initializes a new instance of the PivotGridCustomSummaryEventArgsBase class with the specified settings.
A PivotGridData object which contains the information required to initialize the created PivotGridCustomSummaryEventArgsBase object.
A object which represents a data field.
A PivotCustomSummaryInfo object which contains the information required to initialize the created PivotGridCustomSummaryEventArgsBase object.
Gets the column field which corresponds to the current cell.
A object which represents the column field.
Gets the value of the column field which corresponds to the current cell.
An object which represents the value of the corresponding column field.
Returns a list of the records which are associated with the cell currently being processed.
A object which contains the records which are associated with the current cell.
Gets or sets a custom summary value.
An object which represents a custom summary value.
Gets the data field against which the summary is calculated.
A object which represents the data field against which the summary is calculated.
Gets the name of the data field against which the summary is calculated.
A string which represents the name of the corresponding data field.
Gets the row field which corresponds to the current cell.
A object which represents the row field.
Gets the value of the row field which corresponds to the current cell.
An object which represents the value of the corresponding row field.
Gets an object which contains the values of the predefined summaries that are calculated for the current cell.
A object which contains the values of the predefined summaries that are calculated for the current cell.