PivotGridControl Members

Allows you to create a pivot table (cross-tabular format) for multi-dimensional analysis of large amounts of data.

Constructors

Name Description
PivotGridControl() Initializes a new instance of the PivotGridControl class.

Properties

Name Description
AccessibilityObject Gets the AccessibleObject assigned to the control. Inherited from Control.
AccessibleDefaultActionDescription Gets or sets the default action description of the control for use by accessibility client applications. Inherited from Control.
AccessibleDescription Gets or sets the description of the control used by accessibility client applications. Inherited from Control.
AccessibleName Gets or sets the name of the control used by accessibility client applications. Inherited from Control.
AccessibleRole Gets or sets the accessible role of the control. Inherited from Control.
ActiveEditor Gets the PivotGrid's active editor.
ActiveFilter Provides access to settings of the filter applied to the PivotGridControl's data.
ActiveFilterCriteria Gets or sets the filter criteria applied to the PivotGridControl's data.
ActiveFilterEnabled Gets or sets whether to apply the filter criteria specified using the PivotGridControl.ActiveFilterCriteria or PivotGridControl.ActiveFilterString.
ActiveFilterString Gets or sets a string that specifies the filter criteria applied to the PivotGridControl's data.
AllowDrop Gets or sets a value indicating whether the control can accept data that the user drags onto it. Inherited from Control.
AllowTouchGestures Gets or sets whether the EditorContainer allows touch gestures when the app runs on touch-enabled devices. Inherited from EditorContainer.
Anchor Gets or sets the edges of the container to which a control is bound and determines how a control is resized with its parent. Inherited from Control.
Appearance Provides access to the properties that control the appearance of the PivotGrid control's elements.
AppearancePrint Provides access to the properties that specify the appearances of the PivotGrid control's elements when it's printed.
AutoScrollOffset Gets or sets where this control is scrolled to in ScrollControlIntoView(Control). Inherited from Control.
AutoSize This property is not relevant for this class. Inherited from Control.
BackColor Gets or sets the control's background color. Inherited from EditorContainer.
BackgroundImage This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
BackgroundImageLayout This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
BindingContext Gets or sets the BindingContext for the control. Inherited from Control.
BorderStyle Gets or sets the border style for the PivotGridControl.
Bottom Gets the distance, in pixels, between the bottom edge of the control and the top edge of its container's client area. Inherited from Control.
Bounds Gets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. Inherited from Control.
CanEnableIme protected Gets a value indicating whether the ImeMode property can be set to an active value, to enable IME support. Inherited from Control.
CanFocus Gets a value indicating whether the control can receive focus. Inherited from Control.
CanRaiseEvents protected Determines if events can be raised on the control. Inherited from Control.
CanSelect Gets a value indicating whether the control can be selected. Inherited from Control.
Capture Gets or sets a value indicating whether the control has captured the mouse. Inherited from Control.
CausesValidation Gets or sets a value indicating whether the control causes validation to be performed on any controls that require validation when it receives focus. Inherited from Control.
Cells Gets the object which contains information on the cells that are displayed by the control.
CheckForIllegalCrossThreadCalls static Gets or sets a value indicating whether to catch calls on the wrong thread that access a control's Handle property when an application is being debugged. Inherited from Control.
ClientRectangle Gets the rectangle that represents the client area of the control. Inherited from Control.
ClientSize Gets or sets the height and width of the client area of the control. Inherited from Control.
CompanyName Gets the name of the company or creator of the application containing the control. Inherited from Control.
Container Gets the IContainer that contains the Component. Inherited from Component.
ContainsFocus Gets a value indicating whether the control, or one of its child controls, currently has the input focus. Inherited from Control.
ContextMenu Gets or sets the shortcut menu associated with the control. Inherited from Control.
ContextMenuStrip Gets or sets the ContextMenuStrip associated with this control. Inherited from Control.
Controls Gets the collection of controls contained within the control. Inherited from Control.
Created Gets a value indicating whether the control has been created. Inherited from Control.
CreateParams protected Gets the required creation parameters when the control handle is created. Inherited from Control.
Cursor Gets or sets the cursor that is displayed when the mouse pointer is over the control. Inherited from Control.
CustomizationForm Provides access to the Customization Form.
CustomizationFormBounds Gets or sets the boundaries of the Customization Form.
CustomizationTreeNodeImages static Specifies the collection of images identifying nodes in the Customization Form used when the control is in OLAP mode.
CustomizationTreeNodeSvgImages static
DataBindings Gets the data bindings for the control. Inherited from Control.
DataMember Gets or sets the data source member which supplies data to the control.
DataSource Gets or sets the object used as the data source for the current control.
DefaultBackColor static Gets the default background color of the control. Inherited from Control.
DefaultCursor protected Gets or sets the default cursor for the control. Inherited from Control.
DefaultDataProcessingEngine static Gets or sets a default engine used to perform data processing in the pivot grid.
DefaultFilterEditorView Gets or sets the how an end-user can edit criteria in the Filter Editor.
DefaultFont static Gets the default font of the control. Inherited from Control.
DefaultForeColor static Gets the default foreground color of the control. Inherited from Control.
DefaultImeMode protected Gets the default Input Method Editor (IME) mode supported by the control. Inherited from Control.
DefaultMargin protected Gets the space, in pixels, that is specified by default between controls. Inherited from Control.
DefaultMaximumSize protected Gets the length and height, in pixels, that is specified as the default maximum size of a control. Inherited from Control.
DefaultMinimumSize protected Gets the length and height, in pixels, that is specified as the default minimum size of a control. Inherited from Control.
DefaultPadding protected Gets the internal spacing, in pixels, of the contents of a control. Inherited from Control.
DesignMode protected Gets a value that indicates whether the Component is currently in design mode. Inherited from Component.
DeviceDpi Gets the DPI value for the display device where the control is currently being displayed. Inherited from Control.
DisplayRectangle Gets the rectangle that represents the display area of the control. Inherited from Control.
Disposing Gets a value indicating whether the base Control class is in the process of disposing. Inherited from Control.
Dock Gets or sets which control borders are docked to its parent control and determines how a control is resized with its parent. Inherited from Control.
DoubleBuffered protected Gets or sets a value indicating whether this control should redraw its surface using a secondary buffer to reduce or prevent flicker. Inherited from Control.
EditValue Gets or sets the active editor's value.
Enabled Gets or sets a value indicating whether the control can respond to user interaction. Inherited from Control.
EndUpdateMode static Gets or sets whether the PivotGrid will be immediately redrawn after calling the PivotGridControl.EndUpdate method.
Events protected Gets the list of event handlers that are attached to this Component. Inherited from Component.
ExternalRepository Gets or sets the external repository of in-place editors. Inherited from EditorContainer.
Fields Provides access to a PivotGrid control's field collection.
FixedColumnFieldValues Provides access to the fixed columns collection.
FixedLineWidth
Focused Gets a value indicating whether the control has input focus. Inherited from Control.
Font Overrides the base class Font property.
FontHeight protected Gets or sets the height of the font of the control. Inherited from Control.
ForeColor Gets or sets the control's foreground color. Inherited from EditorContainer.
FormatConditions Gets the collection of style format conditions.
FormatRules Gets the collection of style format rules for a PivotGridControl.
Groups Gets the collection of field groups.
Handle Gets the window handle that the control is bound to. Inherited from Control.
HasChildren Gets a value indicating whether the control contains one or more child controls. Inherited from Control.
HeaderImages Gets or sets the source of images available for display within field headers.
Height Gets or sets the height of the control. Inherited from Control.
HtmlImages Gets or sets a collection of images which can be used in HTML string displayed in the field headers or values.
ImeMode Gets or sets the Input Method Editor (IME) mode of the control. Inherited from Control.
ImeModeBase protected Gets or sets the IME mode of a control. Inherited from Control.
InvokeRequired Gets a value indicating whether the caller must call an invoke method when making method calls to the control because the caller is on a different thread than the one the control was created on. Inherited from Control.
IsAccessible Gets or sets a value indicating whether the control is visible to accessibility applications. Inherited from Control.
IsAsyncInProgress Gets whether an asynchronous operation is in progress.
IsDesignMode This member supports the internal infrastructure, and is not intended to be used directly from your code. Inherited from EditorContainer.
IsDisposed Gets a value indicating whether the control has been disposed of. Inherited from Control.
IsDragging Indicates whether a field header is being dragged by a user.
IsHandleCreated Gets a value indicating whether the control has a handle associated with it. Inherited from Control.
IsLoading Gets whether the control is being initialized. Inherited from EditorContainer.
IsMirrored Gets a value indicating whether the control is mirrored. Inherited from Control.
IsOLAPDataSource Returns whether a connection string is specified via the PivotGridControl.OLAPConnectionString property, and so the control is bound to a cube in an MS Analysis Services database.
IsPrintingAvailable Indicates whether the Pivot Grid Control can be printed.
IsUpdateLocked Gets whether the PivotGridControl has been locked for updating.
LayoutEngine Gets a cached instance of the control's layout engine. Inherited from Control.
Left Gets or sets the distance, in pixels, between the left edge of the control and the left edge of its container's client area. Inherited from Control.
LeftTopCoord Gets or sets the column and row indexes of the data cell displayed in the top left corner.
ListSource Gets the actual data source whose data is displayed within the control.
LoadingPanelVisible
Location Gets or sets the coordinates of the upper-left corner of the control relative to the upper-left corner of its container. Inherited from Control.
LookAndFeel Provides access to the settings that control the Pivot Grid Control's look and feel.
Margin Gets or sets the space between controls. Inherited from Control.
MaximumSize Gets or sets the size that is the upper limit that GetPreferredSize(Size) can specify. Inherited from Control.
MenuManager Gets or sets an object that controls the look and feel of the popup menus. Inherited from EditorContainer.
MinimumSize Gets or sets the size that is the lower limit that GetPreferredSize(Size) can specify. Inherited from Control.
ModifierKeys static Gets a value indicating which of the modifier keys (SHIFT, CTRL, and ALT) is in a pressed state. Inherited from Control.
MouseButtons static Gets a value indicating which of the mouse buttons is in a pressed state. Inherited from Control.
MousePosition static Gets the position of the mouse cursor in screen coordinates. Inherited from Control.
MRUFilters
Name Gets or sets the name of the control. Inherited from Control.
OLAPConnectionString Specifies a connection string to a cube in an MS Analysis Services database.
OLAPDataProvider Gets or sets which data provider should be used to bind to an OLAP cube.
OptionsBehavior Provides access to the control's behavior options.
OptionsChartDataSource Provides access to the options controlling the display of the PivotGrid control's data in a chart control.
OptionsCustomization Provides access to the Pivot Grid Control's customization options.
OptionsData Provides access to the Pivot Grid Control's data specific options.
OptionsDataField Provides access to the options which control the presentation of the data fields in the PivotGrid.
OptionsFilter
OptionsFilterPopup Provides access to options that define the Classic filter popup's appearance and behavior.
OptionsHint Provides access to the Pivot Grid Control's hint options.
OptionsLayout Provides options that control how the Pivot Grid Control layout is stored to/restored from a storage (a stream, XML file or system registry).
OptionsMenu Provides access to the Pivot Grid Control's menu options.
OptionsOLAP Provides access to the Pivot Grid Control's OLAP mode specific options.
OptionsPrint Provides access to the Pivot Grid's appearance and layout options used when printing or exporting the control in WYSIWYG mode.
OptionsSelection Provides access to the Pivot Grid Control's selection options.
OptionsView Provides access to the Pivot Grid Control's display options.
Padding Gets or sets padding within the control. Inherited from Control.
PaintAppearance Provides access to the appearance settings currently used to paint the Pivot Grid Control's elements.
PaintAppearancePrint Provides access to the appearance settings used to paint the Pivot Grid Control's elements when it's printed.
Parent Gets or sets the parent container of the control. Inherited from Control.
PreferredSize Gets the size of a rectangular area into which the control can fit. Inherited from Control.
Prefilter Gets the Prefilter's settings.
ProductName Gets the product name of the assembly containing the control. Inherited from Control.
ProductVersion Gets the version of the assembly containing the control. Inherited from Control.
PropagatingImeMode protected static Gets an object that represents a propagating IME mode. Inherited from Control.
RecreatingHandle Gets a value indicating whether the control is currently re-creating its handle. Inherited from Control.
Region Gets or sets the window region associated with the control. Inherited from Control.
RenderRightToLeft protected This property is now obsolete. Inherited from Control.
RepositoryItems Provides access to the control's internal repository of in-place editors. Inherited from EditorContainer.
ResizeRedraw protected Gets or sets a value indicating whether the control redraws itself when resized. Inherited from Control.
Right Gets the distance, in pixels, between the right edge of the control and the left edge of its container's client area. Inherited from Control.
RightToLeft Gets or sets a value indicating whether control's elements are aligned to support locales using right-to-left fonts. Inherited from Control.
ScaleChildren protected Gets a value that determines the scaling of child controls. Inherited from Control.
ScaleFactor This member supports the internal infrastructure, and is not intended to be used directly from your code. Inherited from EditorContainer.
ShowCustomFunctions
ShowFocusCues protected Gets a value indicating whether the control should display focus rectangles. Inherited from Control.
ShowKeyboardCues protected Gets a value indicating whether the user interface is in the appropriate state to show or hide keyboard accelerators. Inherited from Control.
Site Gets or sets the site of the control. Inherited from Control.
Size Gets or sets the height and width of the control. Inherited from Control.
TabIndex Gets or sets the tab order of the control within its container. Inherited from Control.
TabStop Gets or sets a value indicating whether the user can give the focus to this control using the TAB key. Inherited from Control.
Tag Gets or sets the object that contains data about the control. Inherited from Control.
Text Gets or sets the string associated with the control.
ToolTipController Gets or sets the component that controls the behavior and appearance of hints displayed for a container control's visual elements. Inherited from EditorContainer.
Top Gets or sets the distance, in pixels, between the top edge of the control and the top edge of its container's client area. Inherited from Control.
TopLevelControl Gets the parent control that is not parented by another Windows Forms control. Typically, this is the outermost Form that the control is contained in. Inherited from Control.
UseDirectXPaint Gets or sets whether the DirectX Hardware Acceleration is enabled for this Pivot Grid Control.
UseDisabledStatePainter Gets or sets whether the control is painted grayed out, when in the disabled state.
UserAction Gets the end-user action performed on the PivotGridControl.
UseWaitCursor Gets or sets a value indicating whether to use the wait cursor for the current control and all child controls. Inherited from Control.
ValueImages Gets or sets the source of images that are available for display within field values.
Visible Gets or sets a value indicating whether the control and all its child controls are displayed. Inherited from Control.
Width Gets or sets the width of the control. Inherited from Control.
WindowTarget This property is not relevant for this class. Inherited from Control.

Methods

Name Description
About() static Activates the Pivot Grid Control's About dialog box.
AccessibilityNotifyClients(AccessibleEvents, Int32) protected Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control. Inherited from Control.
AccessibilityNotifyClients(AccessibleEvents, Int32, Int32) protected Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control . Inherited from Control.
BeginInit() Notifies the control that the initialization has started. Inherited from EditorContainer.
BeginInvoke(Delegate) Executes the specified delegate asynchronously on the thread that the control's underlying handle was created on. Inherited from Control.
BeginInvoke(Delegate, Object[]) Executes the specified delegate asynchronously with the specified arguments, on the thread that the control's underlying handle was created on. Inherited from Control.
BeginUpdate() Locks the PivotGridControl object by preventing visual updates of the object and its elements until the EndUpdate method is called.
BestFit() Resizes all columns to fit their contents.
BestFit(PivotGridField) Resizes the column(s) related to the specified field to fit the longest text currently displayed in the column.
BestFitColumnArea() Resizes columns in the Data Area to the minimum width required to display their contents.
BestFitDataHeaders(Boolean) Resizes the Data Header Area to the minimum width required to display data field headers.
BestFitRowArea() Resizes columns that display row field values to the minimum width required to display their contents.
BringToFront() Brings the control to the front of the z-order. Inherited from Control.
CalcHitInfo(Point) Returns information on the grid elements located at the specified point.
CanResizeField(Point) Indicates whether the field can be resized.
ChangeFieldExpandedAsync(PivotGridFieldBase, Boolean) Expands or collapses all values of the specified field asynchronously.
ChangeFieldExpandedAsync(PivotGridFieldBase, Boolean, AsyncCompletedHandler) Expands or collapses all values of the specified field asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
ChangeFieldSortOrderAsync(PivotGridField) Toggles the sort order of the specified field asynchronously.
ChangeFieldSortOrderAsync(PivotGridField, AsyncCompletedHandler) Toggles the sort order of the specified field asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
CheckActiveEditor(Control) static Returns whether the EditorContainer descendant is active. Inherited from EditorContainer.
ClearFieldSortingAsync(PivotGridField) Clears field sorting asynchronously in OLAP mode.
ClearFieldSortingAsync(PivotGridField, AsyncCompletedHandler) Clears field sorting asynchronously in OLAP mode. Allows you to specify custom actions to be performed after this operation is completed.
CloseEditor() Hides the active editor, saving changes made.
CloseEditor(AsyncCompletedHandler) Hides the active editor in the asynchronous mode, saving the changes.
CollapseAll() Collapses all the columns and rows in the PivotGridControl.
CollapseAllAsync() Collapses all columns and rows in a Pivot Grid Control asynchronously.
CollapseAllAsync(AsyncCompletedHandler) Collapses all columns and rows in Pivot Grid Control asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
CollapseAllColumns() Collapses all columns.
CollapseAllColumnsAsync() Collapses all columns asynchronously.
CollapseAllColumnsAsync(AsyncCompletedHandler) Collapses all columns asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
CollapseAllRows() Collapses all rows.
CollapseAllRowsAsync() Collapses all rows asynchronously.
CollapseAllRowsAsync(AsyncCompletedHandler) Collapses all columns asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
CollapseValue(Boolean, Object[]) Collapses a specific column or row that is identified by the specified values.
CollapseValueAsync(Boolean, Object[]) Collapses the specified column or row asynchronously.
CollapseValueAsync(Boolean, Object[], AsyncCompletedHandler) Collapses the specified column or row asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
Contains(Control) Retrieves a value indicating whether the specified control is a child of the control. Inherited from Control.
ConvertFormatConditionToFormatRules() Converts the PivotGridStyleFormatCondition object to the PivotGridFormatRule object.
CreateAccessibilityInstance() protected Creates a new accessibility object for the control. Inherited from Control.
CreateControl() Forces the creation of the visible control, including the creation of the handle and any visible child controls. Inherited from Control.
CreateControlsInstance() protected Creates a new instance of the control collection for the control. Inherited from Control.
CreateDrillDownDataSource() Returns data records used to calculate summary values for all cells.
CreateDrillDownDataSource(Int32, Int32) Returns a list of records used to calculate a summary value for the specified cell.
CreateDrillDownDataSource(Int32, Int32, List<String>) Returns data records used to calculate a summary value for the specified cell. Allows you to specify the columns to return.
CreateDrillDownDataSource(Int32, Int32, Int32) Returns data records used to calculate a summary value for the specified cell. Allows you to limit the number of returned records.
CreateDrillDownDataSource(Int32, Int32, Int32, List<String>) Returns data records used to calculate a summary value for the specified cell. Allows you to specify the columns and limit the number of records to return.
CreateDrillDownDataSourceAsync(AsyncCompletedHandler) Returns a list of records used to calculate summary values for all cells asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32, AsyncCompletedHandler) Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32, List<String>, AsyncCompletedHandler) Returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to specify the additional columns to return in (server mode) or returned columns in (OLAP mode).
CreateDrillDownDataSourceAsync(Int32, Int32, Int32, AsyncCompletedHandler) Returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to limit the number of records to be returned.
CreateDrillDownDataSourceAsync(Int32, Int32, Int32, List<String>, AsyncCompletedHandler) Returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to specify the additional columns to return in (server mode) or returned columns in (OLAP mode), and limit the number of returned records.
CreateGraphics() Creates the Graphics for the control. Inherited from Control.
CreateObjRef(Type) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. Inherited from MarshalByRefObject.
CreateOLAPDataSourceClone() Creates a copy of the current pivot grid's OLAP data source instance.
CreateOLAPDrillDownDataSource(Int32, Int32, List<String>) Obsolete. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns to be returned.
CreateOLAPDrillDownDataSource(Int32, Int32, Int32, List<String>) Obsolete. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns and limit the number of records to be returned.
CreateOLAPDrillDownDataSourceAsync(Int32, Int32, List<String>, AsyncCompletedHandler) Obsolete. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to specify which columns should be returned.
CreateOLAPDrillDownDataSourceAsync(Int32, Int32, Int32, List<String>, AsyncCompletedHandler) Obsolete. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to specify the columns and limit the number of records to be returned.
CreateServerModeDrillDownDataSource(Int32, Int32, List<String>) Obsolete. In server mode, returns a list of records used to calculate a summary value for the specified cell.
CreateServerModeDrillDownDataSource(Int32, Int32, Int32, List<String>) Obsolete. In server mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns and limit the number of records to be returned.
CreateServerModeDrillDownDataSourceAsync(Int32, Int32, List<String>, AsyncCompletedHandler) Obsolete. In server mode, returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to specify which columns should be returned.
CreateServerModeDrillDownDataSourceAsync(Int32, Int32, Int32, List<String>, AsyncCompletedHandler) Obsolete. In server mode, returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to specify the columns and limit the number of records to be returned.
CreateSummaryDataSource() Returns a summary data source.
DefWndProc(Message) protected Sends the specified message to the default window procedure. Inherited from Control.
DestroyCustomization() Closes the Customization Form.
DestroyHandle() protected Destroys the handle associated with the control. Inherited from Control.
Dispose() Releases all resources used by the Component. Inherited from Component.
DoDragDrop(Object, DragDropEffects) Begins a drag-and-drop operation. Inherited from Control.
DrawToBitmap(Bitmap, Rectangle) Supports rendering to the specified bitmap. Inherited from Control.
EndInit() Notifies the control that the initialization has been completed. Inherited from EditorContainer.
EndInvoke(IAsyncResult) Retrieves the return value of the asynchronous operation represented by the IAsyncResult passed. Inherited from Control.
EndUpdate() Unlocks the PivotGridControl object after a call to the BeginUpdate method and causes an immediate visual update.
EndUpdateAsync() Unlocks the Pivot Grid Control after the PivotGridControl.BeginUpdate method call, and starts an asynchronous update.
EndUpdateAsync(AsyncCompletedHandler) Unlocks the Pivot Grid Control after the PivotGridControl.BeginUpdate method call, and starts an asynchronous update. Allows you to specify custom actions, to be performed after this operation is completed.
EnsureViewInfoIsCalculated() Ensures that the Pivot Grid Control's view information has been calculated. If not, forces the Pivot Grid Control to calculate the view information.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
ExpandAll() Expands all the columns and rows in the PivotGridControl.
ExpandAllAsync() Expands all columns and rows in the Pivot Grid Control asynchronously.
ExpandAllAsync(AsyncCompletedHandler) Expands all columns and rows in the Pivot Grid Control asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
ExpandAllColumns() Expands all columns.
ExpandAllColumnsAsync() Expands all columns asynchronously.
ExpandAllColumnsAsync(AsyncCompletedHandler) Expands all columns asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
ExpandAllRows() Expands all rows.
ExpandAllRowsAsync() Expands all rows asynchronously.
ExpandAllRowsAsync(AsyncCompletedHandler) Expands all rows asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
ExpandValue(Boolean, Object[]) Expands a specific column or row that is identified by the specified values.
ExpandValueAsync(Boolean, Object[]) Expands the specified column or row asynchronously.
ExpandValueAsync(Boolean, Object[], AsyncCompletedHandler) Expands the specified column or row asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
ExportToCsv(Stream) Exports the control's data to the specified stream in CSV.
ExportToCsv(Stream, CsvExportOptions) Exports the control's data to the specified stream in CSV format using the specified options.
ExportToCsv(String) Exports the control's data to the specified file in CSV format.
ExportToCsv(String, CsvExportOptions) Exports the control's data to the specified file in CSV format using the specified options.
ExportToDocx(Stream) Exports the Pivot Grid Control's data to a DOCX document and sends it to the specified stream.
ExportToDocx(Stream, DocxExportOptions) Exports the control's data to the specified stream in DOCX format using the specified options.
ExportToDocx(String) Exports the Pivot Grid Control's data to the specified DOCX file.
ExportToDocx(String, DocxExportOptions) Exports the control's data to the specified file in DOCX format using the specified options.
ExportToHtml(Stream) Exports the Pivot Grid Control's data as HTML and sends it to the specified stream.
ExportToHtml(Stream, HtmlExportOptions) Exports the control's data to the specified stream in HTML format using the specified options.
ExportToHtml(Stream, String, String, Boolean) Exports the Pivot Grid Control's data to an HTML document with the specified encoding and title and sends it to the specified stream. The output file can be compressed (secondary characters e.g. spaces are removed) if required.
ExportToHtml(String) Exports the Pivot Grid Control's data to the specified file as HTML.
ExportToHtml(String, HtmlExportOptions) Exports the control's data to the specified file in HTML format using the specified options.
ExportToHtml(String, String) Exports the Pivot Grid Control's data to a HTML file with the specified encoding.
ExportToHtml(String, String, String, Boolean) Exports the Pivot Grid Control's data to an HTML file with the specified encoding and title. The output file can be compressed (secondary characters e.g. spaces are removed) if required.
ExportToImage(Stream) Exports the control's data to the specified stream in BMP format.
ExportToImage(Stream, ImageExportOptions) Exports the control's data to the specified stream in Image format using the specified Image-specific options.
ExportToImage(String) Exports the control's data to the specified file in BMP format.
ExportToImage(String, ImageExportOptions) Exports the control's data to the specified file in Image format using the specified Image-specific options.
ExportToMht(Stream, MhtExportOptions) Exports the control's data to the specified stream in MHT format using the specified options.
ExportToMht(Stream, String, String, Boolean) Exports the Pivot Grid Control's data to an MHT document (Web archive, single file) at the specified path and title and sends it to the specified stream. The output file can be compressed (secondary characters e.g. spaces are removed) if required.
ExportToMht(String) Exports the Pivot Grid Control's data to an MHT file (Web archive, single file) at the specified path.
ExportToMht(String, MhtExportOptions) Exports the control's data to the specified file in MHT format using the specified options.
ExportToMht(String, String) Exports the Pivot Grid Control's data to an MHT file (Web archive, single file) at the specified path and with the specified encoding.
ExportToMht(String, String, String, Boolean) Exports the Pivot Grid Control's data to an MHT file (Web archive, single file) with the specified path and title. The output file can be compressed (secondary characters e.g. spaces are removed) if required.
ExportToPdf(Stream) Exports the Pivot Grid Control's data to a PDF document and sends it to the specified stream.
ExportToPdf(Stream, PdfExportOptions) Exports the control's data to the specified stream in PDF format using the specified options.
ExportToPdf(String) Exports the Pivot Grid Control's data to the specified PDF file.
ExportToPdf(String, PdfExportOptions) Exports the control's data to the specified file in PDF format using the specified options.
ExportToRtf(Stream) Exports the Pivot Grid Control's data as Rich Text and sends it to the specified stream.
ExportToRtf(String) Exports the Pivot Grid Control's data to the specified RTF file.
ExportToText(Stream) Exports the Pivot Grid Control's data to a text document and sends it to the specified stream.
ExportToText(Stream, TextExportOptions) Exports the control's data to the specified stream in Text format using the specified options.
ExportToText(Stream, String) Exports the Pivot Grid Control's data to a text document with the specified separator string and sends it to the specified stream.
ExportToText(Stream, String, Encoding) Exports the Pivot Grid Control's data to a text document with the specified separator string, text encoding settings and sends it to the specified stream.
ExportToText(String) Exports the Pivot Grid Control's data to a text file at the specified path.
ExportToText(String, TextExportOptions) Exports the control's data to the specified file in Text format using the specified options.
ExportToText(String, String) Exports the Pivot Grid Control's data to a text file at the specified path and with the specified separator string.
ExportToText(String, String, Encoding) Exports the Pivot Grid Control's data to a text document with the specified separator string and text encoding settings, and sends it to the specified file.
ExportToXls(Stream) Exports the Pivot Grid Control's data as XLS and sends it to the specified stream.
ExportToXls(Stream, TextExportMode) Exports the control's data to the specified stream in XLS format using the specified options.
ExportToXls(Stream, XlsExportOptions) Exports the control's data to the specified stream in XLS format using the specified options.
ExportToXls(String) Exports the Pivot Grid Control's data to the specified file as XLS.
ExportToXls(String, TextExportMode) Exports the control's data to the specified file in XLS format using the specified options.
ExportToXls(String, XlsExportOptions) Exports the control's data to the specified file in XLS format using the specified options.
ExportToXlsx(Stream) Exports the control's data to the specified stream in XLSX (MS Excel 2007) format.
ExportToXlsx(Stream, TextExportMode) Exports the control's data to the specified file in XLSX (MS Excel 2007) format using the specified options.
ExportToXlsx(Stream, XlsxExportOptions) Exports the control's data to the specified file in XLSX (MS Excel 2007) format using the specified options.
ExportToXlsx(String) Exports the control's data to the specified file in XLSX (MS Excel 2007) format.
ExportToXlsx(String, TextExportMode) Exports the control's data to the specified file in XLSX (MS Excel 2007) format using the specified options.
ExportToXlsx(String, XlsxExportOptions) Exports the control's data to the specified file in XLSX (MS Excel 2007) format using the specified options.
FieldsCustomization() Invokes the Customization Form.
FieldsCustomization(Point) Invokes the Customization Form at the specified point.
FieldsCustomization(Control) Invokes the Customization Form.
FindForm() Retrieves the form that the control is on. Inherited from Control.
Focus() Sets input focus to the control. Inherited from Control.
ForceInitialize() Forces the Pivot Grid Control to finish its initialization.
FromChildHandle(IntPtr) static Retrieves the control that contains the specified handle. Inherited from Control.
FromHandle(IntPtr) static Returns the control that is currently associated with the specified handle. Inherited from Control.
GetAccessibilityObjectById(Int32) protected Retrieves the specified AccessibleObject. Inherited from Control.
GetAutoSizeMode() protected Retrieves a value indicating how a control will behave when its AutoSize property is enabled. Inherited from Control.
GetCellValue(Int32, Int32) Returns a cell value by the column and row indexes.
GetCellValue(Object[], Object[]) Returns a cell value calculated for the specified column and row field values.
GetCellValue(Object[], Object[], PivotGridField) Returns a cell value calculated for the specified column and row field values, against the specified data field.
GetChildAtPoint(Point) Retrieves the child control that is located at the specified coordinates. Inherited from Control.
GetChildAtPoint(Point, GetChildAtPointSkip) Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. Inherited from Control.
GetColumnIndex(Object[]) Returns the index of the specified column.
GetColumnIndex(Object[], PivotGridField) Returns the index of the specified column.
GetContainerControl() Returns the next ContainerControl up the control's chain of parent controls. Inherited from Control.
GetFieldAt(Point) Returns the field whose header is displayed at the specified point.
GetFieldByArea(PivotArea, Int32) Returns a field at the specified visual position in the specified area.
GetFieldList() Returns the list of fields that are available in the bound data source.
GetFieldsByArea(PivotArea) Returns a list of fields displayed in the specified area.
GetFieldValue(PivotGridField, Int32) Returns the specified column or row field's value for the cell addressed by its zero-based index in the Data Area.
GetFieldValueOLAPMember(PivotGridField, Int32) Returns an OLAP member for the specified field value.
GetFieldValueType(PivotGridField, Int32) Gets the type of a specific column/row field's value.
GetFieldValueType(Boolean, Int32) Gets the type of a field value in the column or row area.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetKPIBitmap(PivotKPIGraphic, Int32) Returns an image that corresponds to a specific KPI value.
GetLifetimeService() Retrieves the current lifetime service object that controls the lifetime policy for this instance. Inherited from MarshalByRefObject.
GetNextControl(Control, Boolean) Retrieves the next control forward or back in the tab order of child controls. Inherited from Control.
GetOLAPKPIList() Gets the list of key performance indicators (KPI) in a cube.
GetOLAPKPIMeasures(String) Returns the Measures dimension's members used to calculate the value, goal, status and weight of the specified Key Performance Indicator (KPI).
GetOLAPKPIServerGraphic(String, PivotKPIType) Returns a graphic set defined on the server for the specified KPI's trend and status.
GetOLAPKPIValue(String) Returns the specified KPI's value.
GetPreferredSize(Size) Retrieves the size of a rectangular area into which a control can be fitted. Inherited from Control.
GetRowIndex(Object[]) Returns the index of the specified row.
GetRowIndex(Object[], PivotGridField) Returns the index of the specified row.
GetScaledBounds(Rectangle, SizeF, BoundsSpecified) protected Retrieves the bounds within which the control is scaled. Inherited from Control.
GetService(Type) protected Returns an object that represents a service provided by the Component or by its Container. Inherited from Component.
GetStyle(ControlStyles) protected Retrieves the value of the specified control style bit for the control. Inherited from Control.
GetToolTipController() Returns the actual tooltip controller that controls the behavior and appearance of hints for the container editor. Inherited from EditorContainer.
GetTopLevel() protected Determines if the control is a top-level control. Inherited from Control.
GetType() Gets the Type of the current instance. Inherited from Object.
Hide() Conceals the control from the user. Inherited from Control.
HideCustomization() Closes the Customization Form.
HideEditor() Hides the active editor discarding any changes made.
InitializeLifetimeService() Obtains a lifetime service object to control the lifetime policy for this instance. Inherited from MarshalByRefObject.
InitLayout() protected Called after the control has been added to another container. Inherited from Control.
Invalidate() Invalidates the entire surface of the control and causes the control to be redrawn. Inherited from Control.
Invalidate(Boolean) Invalidates a specific region of the control and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control.
Invalidate(Rectangle) Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control.
Invalidate(Rectangle, Boolean) Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control.
Invalidate(Region) Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control.
Invalidate(Region, Boolean) Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control.
Invoke(Delegate) Executes the specified delegate on the thread that owns the control's underlying window handle. Inherited from Control.
Invoke(Delegate, Object[]) Executes the specified delegate, on the thread that owns the control's underlying window handle, with the specified list of arguments. Inherited from Control.
InvokeGotFocus(Control, EventArgs) protected Raises the GotFocus event for the specified control. Inherited from Control.
InvokeLostFocus(Control, EventArgs) protected Raises the LostFocus event for the specified control. Inherited from Control.
InvokeOnClick(Control, EventArgs) protected Raises the Click event for the specified control. Inherited from Control.
InvokePaint(Control, PaintEventArgs) protected Raises the Paint event for the specified control. Inherited from Control.
InvokePaintBackground(Control, PaintEventArgs) protected Raises the PaintBackground event for the specified control. Inherited from Control.
IsInputChar(Char) protected Determines if a character is an input character that the control recognizes. Inherited from Control.
IsInputKey(Keys) protected Determines whether the specified key is a regular input key or a special key that requires preprocessing. Inherited from Control.
IsKeyLocked(Keys) static Determines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. Inherited from Control.
IsMnemonic(Char, String) static Determines if the specified character is the mnemonic character assigned to the control in the specified string. Inherited from Control.
IsObjectCollapsed(PivotGridField, Int32) Returns whether the specified column field value or row field value is collapsed.
IsObjectCollapsed(Boolean, Int32, Int32) Returns whether the specified column field value or row field value is collapsed.
LayoutChanged() Updates a PivotGridControl.
LoadCollapsedStateFromFile(String) Restores the collapsed state of field values from the specified file.
LoadCollapsedStateFromStream(Stream) Restores the collapsed state of field values from the specified stream.
LogicalToDeviceUnits(Size) Transforms a size from logical to device units by scaling it for the current DPI and rounding down to the nearest integer value for width and height. Inherited from Control.
LogicalToDeviceUnits(Int32) Converts a Logical DPI value to its equivalent DeviceUnit DPI value. Inherited from Control.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
MemberwiseClone(Boolean) protected Creates a shallow copy of the current MarshalByRefObject object. Inherited from MarshalByRefObject.
NotifyInvalidate(Rectangle) protected Raises the Invalidated event with a specified region of the control to invalidate. Inherited from Control.
OnAutoSizeChanged(EventArgs) protected Raises the AutoSizeChanged event. Inherited from Control.
OnBackColorChanged(EventArgs) protected Raises the BackColorChanged event. Inherited from Control.
OnBackgroundImageChanged(EventArgs) protected Raises the BackgroundImageChanged event. Inherited from Control.
OnBackgroundImageLayoutChanged(EventArgs) protected Raises the BackgroundImageLayoutChanged event. Inherited from Control.
OnBindingContextChanged(EventArgs) protected Raises the BindingContextChanged event. Inherited from Control.
OnCausesValidationChanged(EventArgs) protected Raises the CausesValidationChanged event. Inherited from Control.
OnChangeUICues(UICuesEventArgs) protected Raises the ChangeUICues event. Inherited from Control.
OnClientSizeChanged(EventArgs) protected Raises the ClientSizeChanged event. Inherited from Control.
OnContextMenuChanged(EventArgs) protected Raises the ContextMenuChanged event. Inherited from Control.
OnContextMenuStripChanged(EventArgs) protected Raises the ContextMenuStripChanged event. Inherited from Control.
OnControlAdded(ControlEventArgs) protected Raises the ControlAdded event. Inherited from Control.
OnControlRemoved(ControlEventArgs) protected Raises the ControlRemoved event. Inherited from Control.
OnCursorChanged(EventArgs) protected Raises the CursorChanged event. Inherited from Control.
OnDockChanged(EventArgs) protected Raises the DockChanged event. Inherited from Control.
OnDpiChangedAfterParent(EventArgs) protected Raises the DpiChangedAfterParent event. Inherited from Control.
OnDpiChangedBeforeParent(EventArgs) protected Raises the DpiChangedBeforeParent event. Inherited from Control.
OnDragDrop(DragEventArgs) protected Raises the DragDrop event. Inherited from Control.
OnDragEnter(DragEventArgs) protected Raises the DragEnter event. Inherited from Control.
OnDragLeave(EventArgs) protected Raises the DragLeave event. Inherited from Control.
OnDragOver(DragEventArgs) protected Raises the DragOver event. Inherited from Control.
OnEnabledChanged(EventArgs) protected Raises the EnabledChanged event. Inherited from Control.
OnFontChanged(EventArgs) protected Raises the FontChanged event. Inherited from Control.
OnForeColorChanged(EventArgs) protected Raises the ForeColorChanged event. Inherited from Control.
OnGiveFeedback(GiveFeedbackEventArgs) protected Raises the GiveFeedback event. Inherited from Control.
OnHelpRequested(HelpEventArgs) protected Raises the HelpRequested event. Inherited from Control.
OnImeModeChanged(EventArgs) protected Raises the ImeModeChanged event. Inherited from Control.
OnInvalidated(InvalidateEventArgs) protected Raises the Invalidated event. Inherited from Control.
OnKeyUp(KeyEventArgs) protected Raises the KeyUp event. Inherited from Control.
OnLayout(LayoutEventArgs) protected Raises the Layout event. Inherited from Control.
OnLocationChanged(EventArgs) protected Raises the LocationChanged event. Inherited from Control.
OnMarginChanged(EventArgs) protected Raises the MarginChanged event. Inherited from Control.
OnMouseCaptureChanged(EventArgs) protected Raises the MouseCaptureChanged event. Inherited from Control.
OnMouseHover(EventArgs) protected Raises the MouseHover event. Inherited from Control.
OnMove(EventArgs) protected Raises the Move event. Inherited from Control.
OnNotifyMessage(Message) protected Notifies the control of Windows messages. Inherited from Control.
OnPaddingChanged(EventArgs) protected Raises the PaddingChanged event. Inherited from Control.
OnPaintBackground(PaintEventArgs) protected Paints the background of the control. Inherited from Control.
OnParentBackColorChanged(EventArgs) protected Raises the BackColorChanged event when the BackColor property value of the control's container changes. Inherited from Control.
OnParentBackgroundImageChanged(EventArgs) protected Raises the BackgroundImageChanged event when the BackgroundImage property value of the control's container changes. Inherited from Control.
OnParentBindingContextChanged(EventArgs) protected Raises the BindingContextChanged event when the BindingContext property value of the control's container changes. Inherited from Control.
OnParentCursorChanged(EventArgs) protected Raises the CursorChanged event. Inherited from Control.
OnParentEnabledChanged(EventArgs) protected Raises the EnabledChanged event when the Enabled property value of the control's container changes. Inherited from Control.
OnParentFontChanged(EventArgs) protected Raises the FontChanged event when the Font property value of the control's container changes. Inherited from Control.
OnParentForeColorChanged(EventArgs) protected Raises the ForeColorChanged event when the ForeColor property value of the control's container changes. Inherited from Control.
OnParentRightToLeftChanged(EventArgs) protected Raises the RightToLeftChanged event when the RightToLeft property value of the control's container changes. Inherited from Control.
OnParentVisibleChanged(EventArgs) protected Raises the VisibleChanged event when the Visible property value of the control's container changes. Inherited from Control.
OnPreviewKeyDown(PreviewKeyDownEventArgs) protected Raises the PreviewKeyDown event. Inherited from Control.
OnPrint(PaintEventArgs) protected Raises the Paint event. Inherited from Control.
OnQueryContinueDrag(QueryContinueDragEventArgs) protected Raises the QueryContinueDrag event. Inherited from Control.
OnRegionChanged(EventArgs) protected Raises the RegionChanged event. Inherited from Control.
OnResize(EventArgs) protected Raises the Resize event. Inherited from Control.
OnStyleChanged(EventArgs) protected Raises the StyleChanged event. Inherited from Control.
OnSystemColorsChanged(EventArgs) protected Raises the SystemColorsChanged event. Inherited from Control.
OnTabIndexChanged(EventArgs) protected Raises the TabIndexChanged event. Inherited from Control.
OnTabStopChanged(EventArgs) protected Raises the TabStopChanged event. Inherited from Control.
OnTextChanged(EventArgs) protected Raises the TextChanged event. Inherited from Control.
PerformLayout() Forces the control to apply layout logic to all its child controls. Inherited from Control.
PerformLayout(Control, String) Forces the control to apply layout logic to all its child controls. Inherited from Control.
PointToClient(Point) Computes the location of the specified screen point into client coordinates. Inherited from Control.
PointToScreen(Point) Computes the location of the specified client point into screen coordinates. Inherited from Control.
PostEditor() Posts the value being edited to the associated data source without closing the editor.
PostEditor(AsyncCompletedHandler) Posts the value being edited to the associated data source in the asynchronous mode without closing the editor.
PreProcessControlMessage(Message) Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control.
PreProcessMessage(Message) Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control.
Print() Prints the PivotGridControl.
ProcessCmdKey(Message, Keys) protected Processes a command key. Inherited from Control.
ProcessDialogChar(Char) protected Processes a dialog character. Inherited from Control.
ProcessKeyEventArgs(Message) protected Processes a key message and generates the appropriate control events. Inherited from Control.
ProcessKeyMessage(Message) protected Processes a keyboard message. Inherited from Control.
ProcessKeyPreview(Message) protected Previews a keyboard message. Inherited from Control.
ProcessMnemonic(Char) protected Processes a mnemonic character. Inherited from Control.
RaiseDragEvent(Object, DragEventArgs) protected Raises the appropriate drag event. Inherited from Control.
RaiseKeyEvent(Object, KeyEventArgs) protected Raises the appropriate key event. Inherited from Control.
RaiseMouseEvent(Object, MouseEventArgs) protected Raises the appropriate mouse event. Inherited from Control.
RaisePaintEvent(Object, PaintEventArgs) protected Raises the appropriate paint event. Inherited from Control.
RecreateHandle() protected Forces the re-creation of the handle for the control. Inherited from Control.
RectangleToClient(Rectangle) Computes the size and location of the specified screen rectangle in client coordinates. Inherited from Control.
RectangleToScreen(Rectangle) Computes the size and location of the specified client rectangle in screen coordinates. Inherited from Control.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ReflectMessage(IntPtr, Message) protected static Reflects the specified message to the control that is bound to the specified handle. Inherited from Control.
RefreshData() Reloads data from the control's data source and recalculates summaries.
RefreshDataAsync() Reloads data from the control data source and recalculates summaries asynchronously.
RefreshDataAsync(AsyncCompletedHandler) Reloads data from the control data source and recalculates summaries asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
RescaleConstantsForDpi(Int32, Int32) protected Provides constants for rescaling the control when a DPI change occurs. Inherited from Control.
ResetBackColor() Resets the BackColor property to its default value. Inherited from Control.
ResetBindings() Causes a control bound to the BindingSource to reread all the items in the list and refresh their displayed values. Inherited from Control.
ResetCursor() Resets the Cursor property to its default value. Inherited from Control.
ResetEditorsCache(RepositoryItem) For internal use. Inherited from EditorContainer.
ResetEditorsCache(Type) For internal use. Inherited from EditorContainer.
ResetFont() Resets the Font property to its default value. Inherited from Control.
ResetForeColor() Resets the ForeColor property to its default value. Inherited from Control.
ResetImeMode() Resets the ImeMode property to its default value. Inherited from Control.
ResetMouseEventArgs() protected Resets the control to handle the MouseLeave event. Inherited from Control.
ResetRightToLeft() Resets the RightToLeft property to its default value. Inherited from Control.
ResetText() Resets the Text property to its default value (Empty). Inherited from Control.
RestoreLayoutFromRegistry(String) Restores the layout stored at the specified system registry path.
RestoreLayoutFromRegistry(String, OptionsLayoutBase) Restores the Pivot Grid Control's layout stored at the specified system registry path, using the specified settings.
RestoreLayoutFromStream(Stream) Restores a Pivot Grid Control's layout from the specified stream.
RestoreLayoutFromStream(Stream, OptionsLayoutBase) Restores a Pivot Grid Control's layout from the specified stream, using the specified settings.
RestoreLayoutFromXml(String) Restores a Pivot Grid Control's layout from the specified XML file.
RestoreLayoutFromXml(String, OptionsLayoutBase) Restores a Pivot Grid Control's layout using the specified settings from the specified XML file.
ResumeLayout() Resumes usual layout logic. Inherited from Control.
ResumeLayout(Boolean) Resumes usual layout logic, optionally forcing an immediate layout of pending layout requests. Inherited from Control.
RetrieveFields() Creates PivotGridField objects for all the fields in the bound data source.
RetrieveFields(PivotArea, Boolean) Creates PivotGridField objects for all the fields in the bound data source, and moves the fields to the specified area, making them visible or hidden.
RetrieveFieldsAsync() Creates PivotGridField objects for all fields in a data source asynchronously.
RetrieveFieldsAsync(AsyncCompletedHandler) Creates PivotGridField objects for all fields in a data source asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
RetrieveFieldsAsync(PivotArea, Boolean) Creates PivotGridField objects for all fields in a data source, and moves them to the specified area, making them visible or hidden. Performs these actions asynchronously.
RetrieveFieldsAsync(PivotArea, Boolean, AsyncCompletedHandler) Creates PivotGridField objects for all fields in a data source, and moves them to the specified area, making them visible or hidden. Performs these actions asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
RtlTranslateAlignment(ContentAlignment) protected Converts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control.
RtlTranslateAlignment(HorizontalAlignment) protected Converts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control.
RtlTranslateAlignment(LeftRightAlignment) protected Converts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. Inherited from Control.
RtlTranslateContent(ContentAlignment) protected Converts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control.
RtlTranslateHorizontal(HorizontalAlignment) protected Converts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control.
RtlTranslateLeftRight(LeftRightAlignment) protected Converts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. Inherited from Control.
SaveCollapsedStateToFile(String) Saves the collapsed state of field values to the specified file.
SaveCollapsedStateToStream(Stream) Saves the collapsed state of field values to the specified stream.
SaveLayoutToRegistry(String) Saves a Pivot Grid Control's layout to a system registry path.
SaveLayoutToRegistry(String, OptionsLayoutBase) Saves a Pivot Grid Control's layout to the specified system registry path, using the specified settings.
SaveLayoutToStream(Stream) Saves a Pivot Grid Control's layout to the specified stream.
SaveLayoutToStream(Stream, OptionsLayoutBase) Saves a Pivot Grid Control's layout to the specified stream, using the specified settings.
SaveLayoutToXml(String) Saves a Pivot Grid Control's layout to an XML file.
SaveLayoutToXml(String, OptionsLayoutBase) Saves a Pivot Grid Control's layout to the specified XML file, using the specified settings.
SavePivotGridToFile(String) Saves the Pivot Grid Control's data and full layout to the specified file.
SavePivotGridToFile(String, Boolean) Saves the Pivot Grid Control's data and full layout to the specified file, and allows the data to be compressed.
SavePivotGridToStream(Stream) Saves the Pivot Grid Control's data and full layout to the specified stream.
SavePivotGridToStream(Stream, Boolean) Saves the Pivot Grid Control's data and full layout to the specified stream, and allows the data to be compressed.
Scale(SizeF) Scales the control and all child controls by the specified scaling factor. Inherited from Control.
Scale(Single) Scales the control and any child controls. Inherited from Control.
Scale(Single, Single) Scales the entire control and any child controls. Inherited from Control.
ScaleBitmapLogicalToDevice(Bitmap) Scales a logical bitmap value to it's equivalent device unit value when a DPI change occurs. Inherited from Control.
ScaleCore(Single, Single) protected This method is not relevant for this class. Inherited from Control.
Select() Activates the control. Inherited from Control.
Select(Boolean, Boolean) protected Activates a child control. Optionally specifies the direction in the tab order to select the control from. Inherited from Control.
SelectNextControl(Control, Boolean, Boolean, Boolean, Boolean) Activates the next control. Inherited from Control.
SendToBack() Sends the control to the back of the z-order. Inherited from Control.
SetAutoSizeMode(AutoSizeMode) protected Sets a value indicating how a control will behave when its AutoSize property is enabled. Inherited from Control.
SetBounds(Int32, Int32, Int32, Int32) Sets the bounds of the control to the specified location and size. Inherited from Control.
SetBounds(Int32, Int32, Int32, Int32, BoundsSpecified) Sets the specified bounds of the control to the specified location and size. Inherited from Control.
SetBoundsCore(Int32, Int32, Int32, Int32, BoundsSpecified) protected Performs the work of setting the specified bounds of this control. Inherited from Control.
SetClientSizeCore(Int32, Int32) protected Sets the size of the client area of the control. Inherited from Control.
SetDataSourceAsync(Object) Sets a data source for Pivot Grid Control and loads data asynchronously.
SetDataSourceAsync(Object, AsyncCompletedHandler) Sets a data source for the Pivot Grid Control and loads data asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
SetFieldSortingAsync(PivotGridField, PivotSortOrder) Sets the specified sort order for the specified field asynchronously.
SetFieldSortingAsync(PivotGridField, PivotSortOrder, AsyncCompletedHandler) Sets the specified sort order for the specified field asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
SetOLAPConnectionStringAsync(String) Sets a connection string to a cube in an MS Analysis Services database, and loads data from the cube asynchronously.
SetOLAPConnectionStringAsync(String, AsyncCompletedHandler) Sets a connection string to a cube in an MS Analysis Services database, and loads data from the cube asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
SetStyle(ControlStyles, Boolean) protected Sets a specified ControlStyles flag to either true or false. Inherited from Control.
SetTopLevel(Boolean) protected Sets the control as the top-level control. Inherited from Control.
SetVisibleCore(Boolean) protected Sets the control to the specified visible state. Inherited from Control.
Show() Displays the control to the user. Inherited from Control.
ShowCustomization() Invokes the Customization Form.
ShowEditor() Invokes the focused cell's editor.
ShowEditor(Point) Invokes the in-place editor for the cell at the specified position.
ShowPrintPreview() Opens the Print Preview window with a toolbar-based interface.
ShowRibbonPrintPreview() Opens the Print Preview window with a Ribbon-based interface.
ShowUnboundExpressionEditor(PivotGridField) Invokes the Expression Editor that enables editing a specified unbound field's expression.
SizeFromClientSize(Size) protected Determines the size of the entire control from the height and width of its client area. Inherited from Control.
SuspendLayout() Temporarily suspends the layout logic for the control. Inherited from Control.
IDropTarget.OnDragDrop(DragEventArgs) Raises the DragDrop event. Inherited from Control.
IDropTarget.OnDragEnter(DragEventArgs) Raises the DragEnter event. Inherited from Control.
IDropTarget.OnDragLeave(EventArgs) Raises the DragLeave event. Inherited from Control.
IDropTarget.OnDragOver(DragEventArgs) Raises the DragOver event. Inherited from Control.
ToString() Returns a String containing the name of the Component, if any. This method should not be overridden. Inherited from Component.
Update() Causes the control to redraw the invalidated regions within its client area. Inherited from Control.
UpdateBounds() protected Updates the bounds of the control with the current size and location. Inherited from Control.
UpdateBounds(Int32, Int32, Int32, Int32) protected Updates the bounds of the control with the specified size and location. Inherited from Control.
UpdateBounds(Int32, Int32, Int32, Int32, Int32, Int32) protected Updates the bounds of the control with the specified size, location, and client size. Inherited from Control.
UpdateStyles() protected Forces the assigned styles to be reapplied to the control. Inherited from Control.
UpdateZOrder() protected Updates the control in its parent's z-order. Inherited from Control.
ValidateEditor() Validates the active editor.
XtraFindFieldsItem(XtraItemEventArgs) For internal use.

Events

Name Description
ActiveFilterCriteriaChanged Occurs when the filter criteria, currently applied to the PivotGridControl, is changed.
AsyncOperationCompleted Occurs after an asynchronous operation has been completed.
AsyncOperationStarting Occurs before an asynchronous operation is started.
AutoSizeChanged This event is not relevant for this class. Inherited from Control.
BackColorChanged Occurs when the value of the BackColor property changes. Inherited from Control.
BackgroundImageChanged Occurs when the value of the BackgroundImage property changes. Inherited from Control.
BackgroundImageLayoutChanged Occurs when the BackgroundImageLayout property changes. Inherited from Control.
BeforeLoadLayout Occurs before a layout is restored from storage (a stream, xml file or the system registry).
BeginRefresh Occurs before the control's data recalculation starts.
BindingContextChanged Occurs when the value of the BindingContext property changes. Inherited from Control.
CausesValidationChanged Occurs when the value of the CausesValidation property changes. Inherited from Control.
CellClick Occurs when a cell is clicked.
CellDoubleClick Occurs when a cell is double-clicked.
CellSelectionChanged Occurs when the cell selection is modified.
ChangeUICues Occurs when the focus or keyboard user interface (UI) cues change. Inherited from Control.
Click Occurs when the control is clicked. Inherited from Control.
ClientSizeChanged Occurs when the value of the ClientSize property changes. Inherited from Control.
ContextMenuChanged Occurs when the value of the ContextMenu property changes. Inherited from Control.
ContextMenuStripChanged Occurs when the value of the ContextMenuStrip property changes. Inherited from Control.
ControlAdded Occurs when a new control is added to the Control.ControlCollection. Inherited from Control.
ControlRemoved Occurs when a control is removed from the Control.ControlCollection. Inherited from Control.
CursorChanged Occurs when the value of the Cursor property changes. Inherited from Control.
CustomAppearance Allows the appearances of cells to be dynamically customized when the control is displayed on screen and in the print output.
CustomCellDisplayText Enables custom display text to be provided for the cells displayed within the Data Area.
CustomCellEdit Allows you to assign editors for particular cells.
CustomCellEditForEditing Allows you to assign a custom editor to a cell for in-place editing, and override the default cell editor, which is used in both display and edit modes, by default.
CustomCellValue Allows you to replace cell values with values calculated in the event handler.
CustomChartDataSourceData Occurs when a PivotGridControl prepares data to be displayed in a ChartControl.
CustomChartDataSourceRows Allows you to customize pivot grid data before passing it to a chart control.
CustomColumnWidth Enables the column width to be customized.
CustomCustomizationFormSort Allows you to change fields and folders order in the Customization Form.
CustomDrawCell Enables data cells to be painted manually.
CustomDrawEmptyArea Enables a Pivot Grid Control's background to be custom painted.
CustomDrawFieldHeader Enables field headers to be painted manually.
CustomDrawFieldHeaderArea Enables header areas to be painted manually.
CustomDrawFieldValue Enables column and row headers to be painted manually.
CustomEditValue Enables you to change cell values.
CustomExportCell Enables you to render different content for individual cells in a printed or exported document, if the control is exported in the WYSIWYG mode.
CustomExportFieldValue Enables you to render different content for individual field values in a printed or exported document, if the PivotGrid is exported in the WYSIWYG mode.
CustomExportHeader Enables you to render different content for individual field headers in a printed or exported document, if the control is exported in the WYSIWYG mode.
CustomFieldSort Allows you to provide a custom sorting algorithm for the field values.
CustomFieldValueCells Allows you to customize field value cells.
CustomFilterDisplayText
CustomFilterPopupItems Allows you to customize items displayed in the Classic filter popup.
CustomGroupInterval Allows you to custom group values of column and row fields.
CustomRowHeight Enables the rows height to be customized.
CustomServerModeSort In OLAP and server mode, provides the capability to sort data using custom rules.
CustomSummary Allows you to calculate a custom summary.
CustomUnboundFieldData Enables providing data to unbound fields.
DataSourceChanged Fires when the Pivot Grid Control's data source changes.
Disposed Occurs when the component is disposed by a call to the Dispose() method. Inherited from Component.
DockChanged Occurs when the value of the Dock property changes. Inherited from Control.
DoubleClick Occurs when the control is double-clicked. Inherited from Control.
DpiChangedAfterParent Occurs when the DPI setting for a control is changed programmatically after the DPI of its parent control or form has changed. Inherited from Control.
DpiChangedBeforeParent Occurs when the DPI setting for a control is changed programmatically before a DPI change event for its parent control or form has occurred. Inherited from Control.
DragDrop Occurs when a drag-and-drop operation is completed. Inherited from Control.
DragEnter Occurs when an object is dragged into the control's bounds. Inherited from Control.
DragLeave Occurs when an object is dragged out of the control's bounds. Inherited from Control.
DragOver Occurs when an object is dragged over the control's bounds. Inherited from Control.
EditorKeyDown Occurs when a key is pressed within an in-place editor that belongs to the container control. Inherited from EditorContainer.
EditorKeyPress Occurs when a character key is pressed within an in-place editor that belongs to the container control. Inherited from EditorContainer.
EditorKeyUp Occurs when a pressed key is released within an in-place editor that belongs to the container control. Inherited from EditorContainer.
EditValueChanged Occurs when the cell value changes and allows you to save the changed value.
EnabledChanged Occurs when the Enabled property value has changed. Inherited from Control.
EndRefresh Occurs after the control's data recalculation has been completed.
Enter Occurs when the control is entered. Inherited from Control.
ExportFinished Occurs after the PivotGrid's export has been completed.
ExportStarted Occurs after the PivotGrid's export has been started.
FieldAreaChanged Occurs after a field location or visibility has been changed.
FieldAreaChanging Enables you to control whether the dragged field header can be dropped at the area it's currently located over.
FieldAreaIndexChanged Occurs after a field has been moved.
FieldExpandedInFieldGroupChanged Fires when the expansion status of fields combined into a field group is changed.
FieldFilterChanged Occurs after a specific field's filter criteria was changed.
FieldFilterChanging Allows you to customize the filter that is being applied or cancel filtering.
FieldPropertyChanged Occurs after a field's property has been changed.
FieldTooltipShowing Occurs before a tooltip is invoked.
FieldUnboundExpressionChanged Fires after the PivotGridFieldBase.UnboundExpression property's value has been changed.
FieldValueCollapsed Fires after a field value has been collapsed.
FieldValueCollapsing Enables you to control whether field values can be collapsed.
FieldValueDisplayText Allows you to change the display text and display field's data in a more user-friendly format.
FieldValueExpanded Fires after a field value has been expanded.
FieldValueExpanding Enables you to control whether field values can be expanded.
FieldValueImageIndex Enables images to be shown within column and row headers.
FieldValueNotExpanded Occurs in OLAP mode, when an end-user clicks an expand button or selects Expand All from the context menu, and the field value cannot be expanded.
FieldVisibleChanged Occurs after a field has been shown or hidden.
FieldWidthChanged Provides a notification that the field's width has been changed.
FilterEditorCreated
FilterPopupExcelCustomizeTemplate Allows you to customize templates used by Excel-style filter popups and external editors generated using Filtering UI Context.
FilterPopupExcelData Allows you to add, remove, and modify data values and customize predefined filters in the Excel style pop-up filter menus. Filter items added manually on this event must be unique and sorted.
FilterPopupExcelParseFilterCriteria Allows you to parse the filter criteria applied to data and select the corresponding values in the filter menu.
FilterPopupExcelPrepareTemplate Allows you to replace templates used by Excel-style filter popups and external editors generated using Filtering UI Context.
FilterPopupExcelQueryFilterCriteria Fires when a filter criteria is about to be applied to data and allows you to customize the filter criteria.
FocusedCellChanged Fires in response to cell focus changing.
FontChanged Occurs when the Font property value changes. Inherited from Control.
ForeColorChanged Occurs when the ForeColor property value changes. Inherited from Control.
GiveFeedback Occurs during a drag operation. Inherited from Control.
GotFocus Occurs when the control receives focus. Inherited from Control.
GridLayout Fires after the control's layout has been changed.
GroupFilterChanged Occurs after a group filter condition was changed.
HandleCreated Occurs when a handle is created for the control. Inherited from Control.
HandleDestroyed Occurs when the control's handle is in the process of being destroyed. Inherited from Control.
HelpRequested Occurs when the user requests help for a control. Inherited from Control.
HiddenEditor Fires after an in-place editor has been closed.
HideCustomizationForm Fires before the Customization Form is closed.
ImeModeChanged Occurs when the ImeMode property has changed. Inherited from Control.
Invalidated Occurs when a control's display requires redrawing. Inherited from Control.
InvalidValueException Enables you to provide a proper response to entering an invalid cell value.
KeyDown Occurs when a key is pressed while the control has focus. Inherited from Control.
KeyPress Occurs when a character. space or backspace key is pressed while the control has focus. Inherited from Control.
KeyUp Occurs when a key is released while the control has focus. Inherited from Control.
Layout Occurs when a control should reposition its child controls. Inherited from Control.
LayoutUpgrade Occurs when a layout is restored from a data store (a stream, xml file or the system registry) and its version is different than that of the control's current layout version.
Leave Occurs when the input focus leaves the control. Inherited from Control.
LeftTopCellChanged Occurs after the Pivot Grid Control is scrolled.
LocationChanged Occurs when the Location property value has changed. Inherited from Control.
LostFocus Occurs when the control loses focus. Inherited from Control.
MarginChanged Occurs when the control's margin changes. Inherited from Control.
MenuItemClick Allows custom responses to be provided for clicks on context menu items.
MouseCaptureChanged Occurs when the control loses mouse capture. Inherited from Control.
MouseClick Occurs when the control is clicked by the mouse. Inherited from Control.
MouseDoubleClick Occurs when the control is double clicked by the mouse. Inherited from Control.
MouseDown Occurs when the mouse pointer is over the control and a mouse button is pressed. Inherited from Control.
MouseEnter Occurs when the mouse pointer enters the control. Inherited from Control.
MouseHover Occurs when the mouse pointer rests on the control. Inherited from Control.
MouseLeave Occurs when the mouse pointer leaves the control. Inherited from Control.
MouseMove Occurs when the mouse pointer is moved over the control. Inherited from Control.
MouseUp Occurs when the mouse pointer is over the control and a mouse button is released. Inherited from Control.
MouseWheel Occurs when the mouse wheel moves while the control has focus. Inherited from Control.
Move Occurs when the control is moved. Inherited from Control.
OLAPException Obsolete. Raised when a query processing error occurs on a bound OLAP server, or when the connection to this server is lost.
OLAPQueryData Allows you to get a query used to obtain data in PivotGrid.
OLAPQueryTimeout Fires after a specific interval of time has elapsed when sending a query to an OLAP server.
PaddingChanged Occurs when the control's padding changes. Inherited from Control.
Paint Occurs when the control is redrawn. Inherited from Control.
PaintEx
ParentChanged Occurs when the Parent property value changes. Inherited from Control.
PopupMenuShowing Allows you to customize context menus.
PrefilterCriteriaChanged Fires when the Prefilter's criteria are changed.
PreviewKeyDown Occurs before the KeyDown event when a key is pressed while focus is on this control. Inherited from Control.
QueryAccessibilityHelp Occurs when AccessibleObject is providing help to accessibility applications. Inherited from Control.
QueryContinueDrag Occurs during a drag-and-drop operation and enables the drag source to determine whether the drag-and-drop operation should be canceled. Inherited from Control.
QueryCustomFunctions
QueryException Occurs when a query processing error occurs on a bound server providing data for the PivotGridControl.
RegionChanged Occurs when the value of the Region property changes. Inherited from Control.
Resize Occurs when the control is resized. Inherited from Control.
RightToLeftChanged Occurs when the RightToLeft property value changes. Inherited from Control.
ShowCustomizationForm Fires immediately after the Customization Form has been invoked.
ShowFilterPopupExcel Allows you to customize the Excel-style filter popup (for instance, to hide specific filtering conditions from the "Filters" tab).
ShowingCustomizationForm Occurs before the Customization Form is displayed.
ShowingEditor Allows you to cancel editor activation.
ShownEditor Fires after a cell editor has been invoked.
SizeChanged Occurs when the Size property value changes. Inherited from Control.
StyleChanged Occurs when the control style changes. Inherited from Control.
SystemColorsChanged Occurs when the system colors change. Inherited from Control.
TabIndexChanged Occurs when the TabIndex property value changes. Inherited from Control.
TabStopChanged Occurs when the TabStop property value changes. Inherited from Control.
TextChanged Occurs when the Text property value changes. Inherited from Control.
UnboundExpressionEditorCreated
UserActionChanged Allows you to respond to end-user actions performed on the PivotGridControl.
Validated Occurs when the control is finished validating. Inherited from Control.
Validating Occurs when the control is validating. Inherited from Control.
ValidatingEditor Enables you to manually validate cell values.
VisibleChanged Occurs when the Visible property value changes. Inherited from Control.
See Also