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.
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	Gets or sets a vector image that identifies nodes in the Customization Form when the control is in OLAP mode.
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.
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	Gets or sets the width of pinned columns separators.
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	Gets or sets whether the animated loading panel that indicates the data load process is displayed.
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	Inherited from EditorContainer.
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	Gets the recently applied filters list (see MRU Filter List article).
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	Provides access to the Pivot Grid’s filter options.
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.
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	Gets or sets whether to show custom function-based filters.
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, Int32) protected	Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control . Inherited from Control.
AccessibilityNotifyClients(AccessibleEvents, 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, 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.
BeginInvoke(Delegate)	Executes the specified delegate asynchronously 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 Pivot Grid field asynchronously.
ChangeFieldSortOrderAsync(PivotGridField)	Toggles the sort order of the specified field asynchronously.
CheckActiveEditor(Control) static	Returns whether the EditorContainer descendant is active. Inherited from EditorContainer.
ClearFieldSortingAsync(PivotGridField)	Clears field sorting asynchronously in OLAP mode.
CloseEditor()	Hides the active editor, saving changes made.
CloseEditorAsync()
CollapseAll()	Collapses all the columns and rows in the PivotGridControl.
CollapseAllAsync()	Collapses all columns and rows in a Pivot Grid control asynchronously.
CollapseAllColumns()	Collapses all columns.
CollapseAllColumnsAsync()	Collapses all columns asynchronously.
CollapseAllRows()	Collapses all rows.
CollapseAllRowsAsync()	Collapses all rows asynchronously.
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.
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.
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, 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, 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.
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)	Returns a list of records used to calculate a summary value for the specified cell.
CreateDrillDownDataSourceAsync()	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32, List<String>)	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32, Int32, List<String>)	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32, Int32)	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32)	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
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.
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.
CreateSummaryDataSource()	Returns a summary data source.
DefWndProc(Message) protected	Sends the specified message to the default window procedure. Inherited from Control.
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.
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, Object) static	Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)	Determines whether the specified object is equal to the current object. 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.
ExpandAllColumns()	Expands all columns.
ExpandAllColumnsAsync()	Expands all columns asynchronously.
ExpandAllRows()	Expands all rows.
ExpandAllRowsAsync()	Expands all rows asynchronously.
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.
ExportToCsv(Stream, CsvExportOptions)	Exports the control’s data to the specified stream in CSV format using the specified options.
ExportToCsv(Stream)	Exports the control’s data to the specified stream in CSV.
ExportToCsv(String, CsvExportOptions)	Exports the control’s data to the specified file in CSV format using the specified options.
ExportToCsv(String)	Exports the control’s data to the specified file in CSV format.
ExportToDocx(Stream, DocxExportOptions)	Exports the control’s data to the specified stream in DOCX 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(String, DocxExportOptions)	Exports the control’s data to the specified file in DOCX format using the specified options.
ExportToDocx(String)	Exports the Pivot Grid Control’s data to the specified DOCX file.
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(Stream)	Exports the Pivot Grid Control’s data as HTML and sends it to the specified stream.
ExportToHtml(String, HtmlExportOptions)	Exports the control’s data to the specified file in HTML format using the specified options.
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.
ExportToHtml(String, String)	Exports the Pivot Grid Control’s data to a HTML file with the specified encoding.
ExportToHtml(String)	Exports the Pivot Grid Control’s data to the specified file as HTML.
ExportToImage(Stream, ImageExportOptions)	Exports the control’s data to the specified stream in Image format using the specified Image-specific options.
ExportToImage(Stream)	Exports the control’s data to the specified stream in BMP format.
ExportToImage(String, ImageExportOptions)	Exports the control’s data to the specified file in Image format using the specified Image-specific options.
ExportToImage(String)	Exports the control’s data to the specified file in BMP format.
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, MhtExportOptions)	Exports the control’s data to the specified file in MHT format using the specified options.
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.
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)	Exports the Pivot Grid Control’s data to an MHT file (Web archive, single file) at the specified path.
ExportToPdf(Stream, PdfExportOptions)	Exports the control’s data to the specified stream in PDF format using the specified options.
ExportToPdf(Stream)	Exports the Pivot Grid Control’s data to a PDF document and sends it to the specified stream.
ExportToPdf(String, PdfExportOptions)	Exports the control’s data to the specified file in PDF format using the specified options.
ExportToPdf(String)	Exports the Pivot Grid Control’s data to the specified PDF file.
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, TextExportOptions)	Exports the control’s data to the specified stream in Text format using the specified options.
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(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)	Exports the Pivot Grid Control’s data to a text document and sends it to the specified stream.
ExportToText(String, TextExportOptions)	Exports the control’s data to the specified file in Text format using the specified options.
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.
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)	Exports the Pivot Grid Control’s data to a text file at the specified path.
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(Stream)	Exports the Pivot Grid Control’s data as XLS and sends it to the specified stream.
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.
ExportToXls(String)	Exports the Pivot Grid Control’s data to the specified file as XLS.
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(Stream)	Exports the control’s data to the specified stream 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.
ExportToXlsx(String)	Exports the control’s data to the specified file in XLSX (MS Excel 2007) format.
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.
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[], PivotGridField)	Returns a cell value calculated for the specified column and row field values, against the specified data field.
GetCellValue(Object[], Object[])	Returns a cell value calculated for the specified column and row field values.
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.
GetChildAtPoint(Point)	Retrieves the child control that is located at the specified coordinates. Inherited from Control.
GetColumnIndex(Object[], PivotGridField)	Returns the index of the specified column.
GetColumnIndex(Object[])	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.
GetKPISvgBitmap(PivotKPIGraphic, Int32)
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[], PivotGridField)	Returns the index of the specified row.
GetRowIndex(Object[])	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, 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(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(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.
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.
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.
Invoke(Delegate)	Executes the specified delegate on the thread that owns the control’s underlying window handle. 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.
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.
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.
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.
PostEditorAsync()
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.
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, OptionsLayoutBase)	Restores the Pivot Grid Control’s layout stored at the specified system registry path, using the specified settings.
RestoreLayoutFromRegistry(String)	Restores the layout stored at the specified system registry path.
RestoreLayoutFromStream(Stream, OptionsLayoutBase)	Restores a Pivot Grid Control’s layout from the specified stream, using the specified settings.
RestoreLayoutFromStream(Stream)	Restores a Pivot Grid Control’s layout from the specified stream.
RestoreLayoutFromXml(String, OptionsLayoutBase)	Restores a Pivot Grid Control’s layout using the specified settings from the specified XML file.
RestoreLayoutFromXml(String)	Restores a Pivot Grid Control’s layout 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 columns in the bound data source.
RetrieveFields(PivotArea, Boolean)	Creates PivotGridField objects for all columns in the bound data source, and moves the fields to the specified area, making them visible or hidden.
RetrieveFieldsAsync()	Creates PivotGridField objects for all columns in a data source asynchronously.
RetrieveFieldsAsync(PivotArea, Boolean)	Creates PivotGridField objects for all columns in a data source and specifies the area and visibility of the fields. This method executes these actions asynchronously.
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, OptionsLayoutBase)	Saves a Pivot Grid Control’s layout to the specified system registry path, using the specified settings.
SaveLayoutToRegistry(String)	Saves a Pivot Grid Control’s layout to a system registry path.
SaveLayoutToStream(Stream, OptionsLayoutBase)	Saves a Pivot Grid Control’s layout to the specified stream, using the specified settings.
SaveLayoutToStream(Stream)	Saves a Pivot Grid Control’s layout to the specified stream.
SaveLayoutToXml(String, OptionsLayoutBase)	Saves a Pivot Grid Control’s layout to the specified XML file, using the specified settings.
SaveLayoutToXml(String)	Saves a Pivot Grid Control’s layout to an XML 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.
SavePivotGridToFile(String)	Saves the Pivot Grid Control’s data and full layout to the specified file.
SavePivotGridToStream(Stream, Boolean)	Saves the Pivot Grid Control’s data and full layout to the specified stream, and allows the data to be compressed.
SavePivotGridToStream(Stream)	Saves the Pivot Grid Control’s data and full layout to the specified stream.
Scale(SizeF)	Scales the control and all child controls by the specified scaling factor. Inherited from Control.
Scale(Single, Single)	Scales the entire control and any child controls. Inherited from Control.
Scale(Single)	Scales the control and any child controls. 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, BoundsSpecified)	Sets the specified bounds of the control to the specified location and size. Inherited from Control.
SetBounds(Int32, Int32, Int32, Int32)	Sets the 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 the data source for the Pivot Grid control and loads data asynchronously.
SetFieldSortingAsync(PivotGridField, PivotSortOrder)	Sets the sort order for the specified field asynchronously.
SetOLAPConnectionStringAsync(String)	Sets a connection string to a cube in an MS Analysis Services database, and loads data from the cube asynchronously.
SetOLAPFilterByUniqueName(Boolean)
SetOLAPFilterByUniqueNameAsync(Boolean)
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.
ShowContextMenu()
ShowCustomization()	Displays the Customization Form.
ShowCustomization(Point)	Displays the Customization Form at the specified point.
ShowCustomization(Control)	Displays the Customization Form and assigns it to the specified parent.
ShowEditor()	Invokes the focused cell’s editor.
ShowEditor(Point)	Invokes the in-place editor for the cell at the specified position.
ShowExpressionEditor(PivotGridField)	Invokes the Expression Editor where a user can edit the specified field’s binding expression.
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, Int32, Int32) protected	Updates the bounds of the control with the specified size, location, and client size. Inherited from Control.
UpdateBounds(Int32, Int32, Int32, Int32) protected	Updates the bounds of the control with the specified size and location. 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. To avoid performance issues and increased memory consumption, assign repository items that already exist in the PivotGridControl.RepositoryItems collection. Do not create new repository items in this handler.
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. To avoid performance issues and increased memory consumption, assign repository items that already exist in the PivotGridControl.RepositoryItems collection. Do not create new repository items in this handler.
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 implement a custom sorting algorithm for field values.
CustomFieldValueCells	Allows you to customize field value cells.
CustomFilterDisplayText	Enables custom text to be displayed in the Filter Panel.
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	Allows you to implement a custom sorting algorithm for the field values in OLAP and server modes.
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.
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.
ExpressionEditorCreated
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	Allows you to customize the Filter Editor before it is displayed on-screen.
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	A DirectX-compatible method that replaces the standard Control.Paint method.
ParentChanged	Occurs when the Parent property value changes. Inherited from Control.
PopupMenuShowing	Allows you to customize context menus.
PreviewKeyDown	Occurs before the KeyDown event when a key is pressed while focus is on this control. Inherited from Control.
PropertyDeserializing
PropertySerializing
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	Allows you to add custom-function-based filters (for example, ‘discount is more than 15%’) to Excel-style pop-up filter menus and/or the filter editor.
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	Fires after an Expression Editor is created for an unbound field.
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.