Back to Devexpress

PivotGridControl Members

windowsforms-devexpress-dot-xtrapivotgrid-dot-pivotgridcontrol-dot-underscore-members.md

latest208.3 KB
Original Source

PivotGridControl Members

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

Constructors

NameDescription
PivotGridControl()Initializes a new instance of the PivotGridControl class.

Properties

NameDescription
AccessibilityObjectGets the AccessibleObject assigned to the control. Inherited from Control.
AccessibleDefaultActionDescriptionGets or sets the default action description of the control for use by accessibility client applications. Inherited from Control.
AccessibleDescriptionGets or sets the description of the control used by accessibility client applications. Inherited from Control.
AccessibleNameGets or sets the name of the control used by accessibility client applications. Inherited from Control.
AccessibleRoleGets or sets the accessible role of the control. Inherited from Control.
ActiveEditorGets the PivotGrid’s active editor.
ActiveFilterProvides access to settings of the filter applied to the PivotGridControl‘s data.
ActiveFilterCriteriaGets or sets the filter criteria applied to the PivotGridControl‘s data.
ActiveFilterEnabledGets or sets whether to apply the filter criteria specified using the PivotGridControl.ActiveFilterCriteria or PivotGridControl.ActiveFilterString.
ActiveFilterStringGets or sets a string that specifies the filter criteria applied to the PivotGridControl‘s data.
AllowDropGets or sets a value indicating whether the control can accept data that the user drags onto it. Inherited from Control.
AllowTouchGesturesGets or sets whether the EditorContainer allows touch gestures when the app runs on touch-enabled devices. Inherited from EditorContainer.
AnchorGets 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.
AppearanceProvides access to the properties that control the appearance of the PivotGrid control’s elements.
AppearancePrintProvides access to the properties that specify the appearances of the PivotGrid control’s elements when it’s printed.
AutoScrollOffsetGets or sets where this control is scrolled to in ScrollControlIntoView(Control). Inherited from Control.
AutoSizeThis property is not relevant for this class. Inherited from Control.
BackColorGets or sets the control’s background color. Inherited from EditorContainer.
BackgroundImageThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
BackgroundImageLayoutThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
BindingContextGets or sets the BindingContext for the control. Inherited from Control.
BorderStyleGets or sets the border style for the PivotGridControl.
BottomGets the distance, in pixels, between the bottom edge of the control and the top edge of its container’s client area. Inherited from Control.
BoundsGets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. Inherited from Control.
CanEnableIme protectedGets a value indicating whether the ImeMode property can be set to an active value, to enable IME support. Inherited from Control.
CanFocusGets a value indicating whether the control can receive focus. Inherited from Control.
CanRaiseEvents protectedDetermines if events can be raised on the control. Inherited from Control.
CanSelectGets a value indicating whether the control can be selected. Inherited from Control.
CaptureGets or sets a value indicating whether the control has captured the mouse. Inherited from Control.
CausesValidationGets 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.
CellsGets the object which contains information on the cells that are displayed by the control.
CheckForIllegalCrossThreadCalls staticGets 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.
ClientRectangleGets the rectangle that represents the client area of the control. Inherited from Control.
ClientSizeGets or sets the height and width of the client area of the control. Inherited from Control.
CompanyNameGets the name of the company or creator of the application containing the control. Inherited from Control.
ContainerGets the IContainer that contains the Component. Inherited from Component.
ContainsFocusGets a value indicating whether the control, or one of its child controls, currently has the input focus. Inherited from Control.
ContextMenuGets or sets the shortcut menu associated with the control. Inherited from Control.
ControlsGets the collection of controls contained within the control. Inherited from Control.
CreatedGets a value indicating whether the control has been created. Inherited from Control.
CreateParams protectedGets the required creation parameters when the control handle is created. Inherited from Control.
CursorGets or sets the cursor that is displayed when the mouse pointer is over the control. Inherited from Control.
CustomizationFormProvides access to the Customization Form.
CustomizationFormBoundsGets or sets the boundaries of the Customization Form.
CustomizationTreeNodeImages staticSpecifies the collection of images identifying nodes in the Customization Form used when the control is in OLAP mode.
CustomizationTreeNodeSvgImages staticGets or sets a vector image that identifies nodes in the Customization Form when the control is in OLAP mode.
DataBindingsGets the data bindings for the control. Inherited from Control.
DataMemberGets or sets the data source member which supplies data to the control.
DataSourceGets or sets the object used as the data source for the current control.
DefaultBackColor staticGets the default background color of the control. Inherited from Control.
DefaultCursor protectedGets or sets the default cursor for the control. Inherited from Control.
DefaultDataProcessingEngine staticGets or sets a default engine used to perform data processing in the pivot grid.
DefaultFilterEditorViewGets or sets the how an end-user can edit criteria in the Filter Editor. This property is obsolete. Use the PivotGridControl.OptionsFilter.DefaultFilterEditorView property instead.
DefaultFont staticGets the default font of the control. Inherited from Control.
DefaultForeColor staticGets the default foreground color of the control. Inherited from Control.
DefaultImeMode protectedGets the default Input Method Editor (IME) mode supported by the control. Inherited from Control.
DefaultMargin protectedGets the space, in pixels, that is specified by default between controls. Inherited from Control.
DefaultMaximumSize protectedGets the length and height, in pixels, that is specified as the default maximum size of a control. Inherited from Control.
DefaultMinimumSize protectedGets the length and height, in pixels, that is specified as the default minimum size of a control. Inherited from Control.
DefaultPadding protectedGets the internal spacing, in pixels, of the contents of a control. Inherited from Control.
DesignMode protectedGets a value that indicates whether the Component is currently in design mode. Inherited from Component.
DisplayRectangleGets the rectangle that represents the display area of the control. Inherited from Control.
DisposingGets a value indicating whether the base Control class is in the process of disposing. Inherited from Control.
DockGets 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 protectedGets or sets a value indicating whether this control should redraw its surface using a secondary buffer to reduce or prevent flicker. Inherited from Control.
EditValueGets or sets the active editor’s value.
EnabledGets or sets a value indicating whether the control can respond to user interaction. Inherited from Control.
EndUpdateMode staticGets or sets whether the PivotGrid will be immediately redrawn after calling the PivotGridControl.EndUpdate method.
Events protectedGets the list of event handlers that are attached to this Component. Inherited from Component.
ExternalRepositoryGets or sets the external repository of in-place editors. Inherited from EditorContainer.
FieldsProvides access to a PivotGrid control’s field collection.
FixedColumnFieldValuesProvides access to the fixed columns collection.
FixedLineWidthGets or sets the width of pinned columns separators.
FocusedGets a value indicating whether the control has input focus. Inherited from Control.
FontOverrides the base class Font property.
FontHeight protectedGets or sets the height of the font of the control. Inherited from Control.
ForeColorGets or sets the control’s foreground color. Inherited from EditorContainer.
FormatConditionsGets the collection of style format conditions.
FormatRulesGets the collection of style format rules for a PivotGridControl.
GroupsGets the collection of field groups.
HandleGets the window handle that the control is bound to. Inherited from Control.
HasChildrenGets a value indicating whether the control contains one or more child controls. Inherited from Control.
HeaderImagesGets or sets the source of images available for display within field headers.
HeightGets or sets the height of the control. Inherited from Control.
HtmlImagesGets or sets a collection of images which can be used in HTML string displayed in the field headers or values.
ImeModeGets or sets the Input Method Editor (IME) mode of the control. Inherited from Control.
ImeModeBase protectedGets or sets the IME mode of a control. Inherited from Control.
InvokeRequiredGets 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.
IsAccessibleGets or sets a value indicating whether the control is visible to accessibility applications. Inherited from Control.
IsAsyncInProgressGets whether an asynchronous operation is in progress.
IsDesignModeThis member supports the internal infrastructure, and is not intended to be used directly from your code. Inherited from EditorContainer.
IsDisposedGets a value indicating whether the control has been disposed of. Inherited from Control.
IsDraggingIndicates whether a field header is being dragged by a user.
IsHandleCreatedGets a value indicating whether the control has a handle associated with it. Inherited from Control.
IsLoadingGets whether the control is being initialized. Inherited from EditorContainer.
IsMirroredGets a value indicating whether the control is mirrored. Inherited from Control.
IsOLAPDataSourceReturns 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.
IsPrintingAvailableIndicates whether the Pivot Grid Control can be printed.
IsUpdateLockedGets whether the PivotGridControl has been locked for updating.
LayoutEngineGets a cached instance of the control’s layout engine. Inherited from Control.
LeftGets 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.
LeftTopCoordGets or sets the column and row indexes of the data cell displayed in the top left corner.
ListSourceGets the actual data source whose data is displayed within the control.
LoadingPanelVisibleGets or sets whether the animated loading panel that indicates the data load process is displayed.
LocationGets or sets the coordinates of the upper-left corner of the control relative to the upper-left corner of its container. Inherited from Control.
LookAndFeelInherited from EditorContainer.
MarginGets or sets the space between controls. Inherited from Control.
MaximumSizeGets or sets the size that is the upper limit that GetPreferredSize(Size) can specify. Inherited from Control.
MenuManagerGets or sets an object that controls the look and feel of the popup menus. Inherited from EditorContainer.
MinimumSizeGets or sets the size that is the lower limit that GetPreferredSize(Size) can specify. Inherited from Control.
ModifierKeys staticGets a value indicating which of the modifier keys (SHIFT, CTRL, and ALT) is in a pressed state. Inherited from Control.
MouseButtons staticGets a value indicating which of the mouse buttons is in a pressed state. Inherited from Control.
MousePosition staticGets the position of the mouse cursor in screen coordinates. Inherited from Control.
MRUFiltersGets the recently applied filters list (see MRU Filter List article).
NameGets or sets the name of the control. Inherited from Control.
OLAPConnectionStringSpecifies a connection string to a cube in an MS Analysis Services database.
OLAPDataProviderGets or sets which data provider should be used to bind to an OLAP cube.
OptionsBehaviorProvides access to the control’s behavior options.
OptionsChartDataSourceProvides access to the options controlling the display of the PivotGrid control’s data in a chart control.
OptionsCustomizationProvides access to the Pivot Grid Control’s customization options.
OptionsDataProvides access to the Pivot Grid Control’s data specific options.
OptionsDataFieldProvides access to the options which control the presentation of the data fields in the PivotGrid.
OptionsFilterProvides access to the Pivot Grid’s filter options.
OptionsFilterPopupProvides access to options that define the Classic filter popup’s appearance and behavior.
OptionsHintProvides access to the Pivot Grid Control’s hint options.
OptionsLayoutContains options that specify how the Pivot Grid Control layout is stored to/restored from a storage (a stream, XML file or system registry).
OptionsMenuProvides access to the Pivot Grid Control’s menu options.
OptionsOLAPProvides access to the Pivot Grid Control’s OLAP mode specific options.
OptionsPrintProvides access to the Pivot Grid’s appearance and layout options used when printing or exporting the control in WYSIWYG mode.
OptionsSelectionProvides access to the Pivot Grid Control’s selection options.
OptionsViewProvides access to the Pivot Grid Control’s display options.
PaddingGets or sets padding within the control. Inherited from Control.
PaintAppearanceProvides access to the appearance settings currently used to paint the Pivot Grid Control’s elements.
PaintAppearancePrintProvides access to the appearance settings used to paint the Pivot Grid Control’s elements when it’s printed.
ParentGets or sets the parent container of the control. Inherited from Control.
PreferredSizeGets the size of a rectangular area into which the control can fit. Inherited from Control.
ProductNameGets the product name of the assembly containing the control. Inherited from Control.
ProductVersionGets the version of the assembly containing the control. Inherited from Control.
PropagatingImeMode protected staticGets an object that represents a propagating IME mode. Inherited from Control.
RecreatingHandleGets a value indicating whether the control is currently re-creating its handle. Inherited from Control.
RegionGets or sets the window region associated with the control. Inherited from Control.
RenderRightToLeft protectedThis property is now obsolete. Inherited from Control.
RepositoryItemsProvides access to the control’s internal repository of in-place editors. Inherited from EditorContainer.
ResizeRedraw protectedGets or sets a value indicating whether the control redraws itself when resized. Inherited from Control.
RightGets the distance, in pixels, between the right edge of the control and the left edge of its container’s client area. Inherited from Control.
RightToLeftGets or sets a value indicating whether control’s elements are aligned to support locales using right-to-left fonts. Inherited from Control.
ScaleChildren protectedGets a value that determines the scaling of child controls. Inherited from Control.
ScaleFactorThis member supports the internal infrastructure, and is not intended to be used directly from your code. Inherited from EditorContainer.
ShowCustomFunctionsGets or sets whether to show custom function-based filters.
ShowFocusCues protectedGets a value indicating whether the control should display focus rectangles. Inherited from Control.
ShowKeyboardCues protectedGets a value indicating whether the user interface is in the appropriate state to show or hide keyboard accelerators. Inherited from Control.
SiteGets or sets the site of the control. Inherited from Control.
SizeGets or sets the height and width of the control. Inherited from Control.
TabIndexGets or sets the tab order of the control within its container. Inherited from Control.
TabStopGets or sets a value indicating whether the user can give the focus to this control using the TAB key. Inherited from Control.
TagGets or sets the object that contains data about the control. Inherited from Control.
TextGets or sets the string associated with the control.
ToolTipControllerGets or sets the component that controls the behavior and appearance of hints displayed for a container control’s visual elements. Inherited from EditorContainer.
TopGets 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.
TopLevelControlGets 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.
UseDirectXPaintGets or sets whether the DirectX Hardware Acceleration is enabled for this Pivot Grid Control.
UseDisabledStatePainterGets or sets whether the control is painted grayed out, when in the disabled state.
UserActionGets the end-user action performed on the PivotGridControl.
UseWaitCursorGets or sets a value indicating whether to use the wait cursor for the current control and all child controls. Inherited from Control.
ValueImagesGets or sets the source of images that are available for display within field values.
VisibleGets or sets a value indicating whether the control and all its child controls are displayed. Inherited from Control.
WidthGets or sets the width of the control. Inherited from Control.
WindowTargetThis property is not relevant for this class. Inherited from Control.

Methods

NameDescription
About() staticActivates the Pivot Grid Control’s About dialog box.
AccessibilityNotifyClients(AccessibleEvents, Int32, Int32) protectedNotifies the accessibility client applications of the specified AccessibleEvents for the specified child control . Inherited from Control.
AccessibilityNotifyClients(AccessibleEvents, Int32) protectedNotifies 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) staticReturns 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() protectedCreates 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) protectedSends the specified message to the default window procedure. Inherited from Control.
DestroyHandle() protectedDestroys 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) staticDetermines 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) staticRetrieves the control that contains the specified handle. Inherited from Control.
FromHandle(IntPtr) staticReturns the control that is currently associated with the specified handle. Inherited from Control.
GetAutoSizeMode() protectedRetrieves 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) protectedRetrieves the bounds within which the control is scaled. Inherited from Control.
GetService(Type) protectedReturns an object that represents a service provided by the Component or by its Container. Inherited from Component.
GetStyle(ControlStyles) protectedRetrieves 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() protectedDetermines 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() protectedCalled 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) protectedRaises the GotFocus event for the specified control. Inherited from Control.
InvokeLostFocus(Control, EventArgs) protectedRaises the LostFocus event for the specified control. Inherited from Control.
InvokeOnClick(Control, EventArgs) protectedRaises the Click event for the specified control. Inherited from Control.
InvokePaint(Control, PaintEventArgs) protectedRaises the Paint event for the specified control. Inherited from Control.
InvokePaintBackground(Control, PaintEventArgs) protectedRaises the PaintBackground event for the specified control. Inherited from Control.
IsInputChar(Char) protectedDetermines if a character is an input character that the control recognizes. Inherited from Control.
IsInputKey(Keys) protectedDetermines whether the specified key is a regular input key or a special key that requires preprocessing. Inherited from Control.
IsKeyLocked(Keys) staticDetermines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. Inherited from Control.
IsMnemonic(Char, String) staticDetermines 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() protectedCreates a shallow copy of the current Object. Inherited from Object.
MemberwiseClone(Boolean) protectedCreates a shallow copy of the current MarshalByRefObject object. Inherited from MarshalByRefObject.
NotifyInvalidate(Rectangle) protectedRaises the Invalidated event with a specified region of the control to invalidate. Inherited from Control.
OnAutoSizeChanged(EventArgs) protectedRaises the AutoSizeChanged event. Inherited from Control.
OnBackColorChanged(EventArgs) protectedRaises the BackColorChanged event. Inherited from Control.
OnBackgroundImageChanged(EventArgs) protectedRaises the BackgroundImageChanged event. Inherited from Control.
OnBackgroundImageLayoutChanged(EventArgs) protectedRaises the BackgroundImageLayoutChanged event. Inherited from Control.
OnCausesValidationChanged(EventArgs) protectedRaises the CausesValidationChanged event. Inherited from Control.
OnChangeUICues(UICuesEventArgs) protectedRaises the ChangeUICues event. Inherited from Control.
OnClientSizeChanged(EventArgs) protectedRaises the ClientSizeChanged event. Inherited from Control.
OnContextMenuChanged(EventArgs) protectedRaises the ContextMenuChanged event. Inherited from Control.
OnContextMenuStripChanged(EventArgs) protectedRaises the ContextMenuStripChanged event. Inherited from Control.
OnControlAdded(ControlEventArgs) protectedRaises the ControlAdded event. Inherited from Control.
OnControlRemoved(ControlEventArgs) protectedRaises the ControlRemoved event. Inherited from Control.
OnCursorChanged(EventArgs) protectedRaises the CursorChanged event. Inherited from Control.
OnDockChanged(EventArgs) protectedRaises the DockChanged event. Inherited from Control.
OnDragDrop(DragEventArgs) protectedRaises the DragDrop event. Inherited from Control.
OnDragEnter(DragEventArgs) protectedRaises the DragEnter event. Inherited from Control.
OnDragLeave(EventArgs) protectedRaises the DragLeave event. Inherited from Control.
OnDragOver(DragEventArgs) protectedRaises the DragOver event. Inherited from Control.
OnEnabledChanged(EventArgs) protectedRaises the EnabledChanged event. Inherited from Control.
OnFontChanged(EventArgs) protectedRaises the FontChanged event. Inherited from Control.
OnForeColorChanged(EventArgs) protectedRaises the ForeColorChanged event. Inherited from Control.
OnGiveFeedback(GiveFeedbackEventArgs) protectedRaises the GiveFeedback event. Inherited from Control.
OnHelpRequested(HelpEventArgs) protectedRaises the HelpRequested event. Inherited from Control.
OnImeModeChanged(EventArgs) protectedRaises the ImeModeChanged event. Inherited from Control.
OnInvalidated(InvalidateEventArgs) protectedRaises the Invalidated event. Inherited from Control.
OnKeyUp(KeyEventArgs) protectedRaises the KeyUp event. Inherited from Control.
OnLayout(LayoutEventArgs) protectedRaises the Layout event. Inherited from Control.
OnLocationChanged(EventArgs) protectedRaises the LocationChanged event. Inherited from Control.
OnMarginChanged(EventArgs) protectedRaises the MarginChanged event. Inherited from Control.
OnMouseCaptureChanged(EventArgs) protectedRaises the MouseCaptureChanged event. Inherited from Control.
OnMouseHover(EventArgs) protectedRaises the MouseHover event. Inherited from Control.
OnMove(EventArgs) protectedRaises the Move event. Inherited from Control.
OnNotifyMessage(Message) protectedNotifies the control of Windows messages. Inherited from Control.
OnPaddingChanged(EventArgs) protectedRaises the PaddingChanged event. Inherited from Control.
OnPaintBackground(PaintEventArgs) protectedPaints the background of the control. Inherited from Control.
OnParentBackColorChanged(EventArgs) protectedRaises the BackColorChanged event when the BackColor property value of the control’s container changes. Inherited from Control.
OnParentBackgroundImageChanged(EventArgs) protectedRaises the BackgroundImageChanged event when the BackgroundImage property value of the control’s container changes. Inherited from Control.
OnParentBindingContextChanged(EventArgs) protectedRaises the BindingContextChanged event when the BindingContext property value of the control’s container changes. Inherited from Control.
OnParentCursorChanged(EventArgs) protectedRaises the CursorChanged event. Inherited from Control.
OnParentEnabledChanged(EventArgs) protectedRaises the EnabledChanged event when the Enabled property value of the control’s container changes. Inherited from Control.
OnParentFontChanged(EventArgs) protectedRaises the FontChanged event when the Font property value of the control’s container changes. Inherited from Control.
OnParentForeColorChanged(EventArgs) protectedRaises the ForeColorChanged event when the ForeColor property value of the control’s container changes. Inherited from Control.
OnParentRightToLeftChanged(EventArgs) protectedRaises the RightToLeftChanged event when the RightToLeft property value of the control’s container changes. Inherited from Control.
OnParentVisibleChanged(EventArgs) protectedRaises the VisibleChanged event when the Visible property value of the control’s container changes. Inherited from Control.
OnPreviewKeyDown(PreviewKeyDownEventArgs) protectedRaises the PreviewKeyDown event. Inherited from Control.
OnPrint(PaintEventArgs) protectedRaises the Paint event. Inherited from Control.
OnQueryContinueDrag(QueryContinueDragEventArgs) protectedRaises the QueryContinueDrag event. Inherited from Control.
OnRegionChanged(EventArgs) protectedRaises the RegionChanged event. Inherited from Control.
OnResize(EventArgs) protectedRaises the Resize event. Inherited from Control.
OnStyleChanged(EventArgs) protectedRaises the StyleChanged event. Inherited from Control.
OnSystemColorsChanged(EventArgs) protectedRaises the SystemColorsChanged event. Inherited from Control.
OnTabIndexChanged(EventArgs) protectedRaises the TabIndexChanged event. Inherited from Control.
OnTabStopChanged(EventArgs) protectedRaises the TabStopChanged event. Inherited from Control.
OnTextChanged(EventArgs) protectedRaises 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) protectedProcesses a command key. Inherited from Control.
ProcessDialogChar(Char) protectedProcesses a dialog character. Inherited from Control.
ProcessKeyEventArgs(Message) protectedProcesses a key message and generates the appropriate control events. Inherited from Control.
ProcessKeyMessage(Message) protectedProcesses a keyboard message. Inherited from Control.
ProcessKeyPreview(Message) protectedPreviews a keyboard message. Inherited from Control.
ProcessMnemonic(Char) protectedProcesses a mnemonic character. Inherited from Control.
RaiseDragEvent(Object, DragEventArgs) protectedRaises the appropriate drag event. Inherited from Control.
RaiseKeyEvent(Object, KeyEventArgs) protectedRaises the appropriate key event. Inherited from Control.
RaiseMouseEvent(Object, MouseEventArgs) protectedRaises the appropriate mouse event. Inherited from Control.
RaisePaintEvent(Object, PaintEventArgs) protectedRaises the appropriate paint event. Inherited from Control.
RecreateHandle() protectedForces 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) staticDetermines whether the specified Object instances are the same instance. Inherited from Object.
ReflectMessage(IntPtr, Message) protected staticReflects 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() protectedResets 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.
RestoreLayoutFromJson(Stream, OptionsLayoutBase)Loads the Pivot Grid’s layout settings specified by the options parameter from a file in JSON format.
RestoreLayoutFromJson(Stream)Loads the Pivot Grid’s layout settings specified by the OptionsLayout property from a file in JSON format.
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) protectedConverts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control.
RtlTranslateAlignment(HorizontalAlignment) protectedConverts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control.
RtlTranslateAlignment(LeftRightAlignment) protectedConverts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. Inherited from Control.
RtlTranslateContent(ContentAlignment) protectedConverts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control.
RtlTranslateHorizontal(HorizontalAlignment) protectedConverts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control.
RtlTranslateLeftRight(LeftRightAlignment) protectedConverts 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.
SaveLayoutToJson(Stream, OptionsLayoutBase)Saves the Pivot Grid’s layout settings specified by the options parameter to a file in JSON format.
SaveLayoutToJson(Stream)Saves the Pivot Grid’s layout settings specified by the OptionsLayout property to a file in JSON format.
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) protectedThis method is not relevant for this class. Inherited from Control.
Select()Activates the control. Inherited from Control.
Select(Boolean, Boolean) protectedActivates 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) protectedSets 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.
SetClientSizeCore(Int32, Int32) protectedSets 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) protectedSets a specified ControlStyles flag to either true or false. Inherited from Control.
SetTopLevel(Boolean) protectedSets the control as the top-level control. Inherited from Control.
SetVisibleCore(Boolean) protectedSets 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) protectedDetermines 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() protectedUpdates the bounds of the control with the current size and location. Inherited from Control.
UpdateBounds(Int32, Int32, Int32, Int32, Int32, Int32) protectedUpdates the bounds of the control with the specified size, location, and client size. Inherited from Control.
UpdateBounds(Int32, Int32, Int32, Int32) protectedUpdates the bounds of the control with the specified size and location. Inherited from Control.
UpdateStyles() protectedForces the assigned styles to be reapplied to the control. Inherited from Control.
UpdateZOrder() protectedUpdates the control in its parent’s z-order. Inherited from Control.
ValidateEditor()Validates the active editor.
XtraFindFieldsItem(XtraItemEventArgs)For internal use.

Events

NameDescription
ActiveFilterCriteriaChangedOccurs when the filter criteria, currently applied to the PivotGridControl, is changed.
AsyncOperationCompletedOccurs after an asynchronous operation has been completed.
AsyncOperationStartingOccurs before an asynchronous operation is started.
AutoSizeChangedThis event is not relevant for this class. Inherited from Control.
BackColorChangedOccurs when the value of the BackColor property changes. Inherited from Control.
BackgroundImageChangedOccurs when the value of the BackgroundImage property changes. Inherited from Control.
BackgroundImageLayoutChangedOccurs when the BackgroundImageLayout property changes. Inherited from Control.
BeforeLoadLayoutOccurs before a layout is restored from storage (a stream, xml file or the system registry).
BeginRefreshOccurs before the control’s data recalculation starts.
BindingContextChangedOccurs when the value of the BindingContext property changes. Inherited from Control.
CausesValidationChangedOccurs when the value of the CausesValidation property changes. Inherited from Control.
CellClickOccurs when a cell is clicked.
CellDoubleClickOccurs when a cell is double-clicked.
CellSelectionChangedOccurs when the cell selection is modified.
ChangeUICuesOccurs when the focus or keyboard user interface (UI) cues change. Inherited from Control.
ClickOccurs when the control is clicked. Inherited from Control.
ClientSizeChangedOccurs when the value of the ClientSize property changes. Inherited from Control.
ContextMenuChangedOccurs when the value of the ContextMenu property changes. Inherited from Control.
ContextMenuStripChangedOccurs when the value of the ContextMenuStrip property changes. Inherited from Control.
ControlAddedOccurs when a new control is added to the Control.ControlCollection. Inherited from Control.
ControlRemovedOccurs when a control is removed from the Control.ControlCollection. Inherited from Control.
CursorChangedOccurs when the value of the Cursor property changes. Inherited from Control.
CustomAppearanceAllows the appearances of cells to be dynamically customized when the control is displayed on screen and in the print output.
CustomCellDisplayTextEnables custom display text to be provided for the cells displayed within the Data Area.
CustomCellEditAllows 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.
CustomCellEditForEditingAllows 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.
CustomCellValueAllows you to replace cell values with values calculated in the event handler.
CustomChartDataSourceDataOccurs when a PivotGridControl prepares data to be displayed in a ChartControl.
CustomChartDataSourceRowsAllows you to customize pivot grid data before passing it to a chart control.
CustomColumnWidthEnables the column width to be customized.
CustomCustomizationFormSortAllows you to change fields and folders order in the Customization Form.
CustomDrawCellEnables data cells to be painted manually.
CustomDrawEmptyAreaEnables a Pivot Grid Control’s background to be custom painted.
CustomDrawFieldHeaderEnables field headers to be painted manually.
CustomDrawFieldHeaderAreaEnables header areas to be painted manually.
CustomDrawFieldValueEnables column and row headers to be painted manually.
CustomEditValueEnables you to change cell values.
CustomExportCellEnables you to render different content for individual cells in a printed or exported document, if the control is exported in the WYSIWYG mode.
CustomExportFieldValueEnables you to render different content for individual field values in a printed or exported document, if the PivotGrid is exported in the WYSIWYG mode.
CustomExportHeaderEnables you to render different content for individual field headers in a printed or exported document, if the control is exported in the WYSIWYG mode.
CustomFieldSortAllows you to implement a custom sorting algorithm for field values.
CustomFieldValueCellsAllows you to customize field value cells.
CustomFilterDisplayTextEnables custom text to be displayed in the Filter Panel.
CustomFilterPopupItemsAllows you to customize items displayed in the Classic filter popup.
CustomGroupIntervalAllows you to custom group values of column and row fields.
CustomRowHeightEnables the rows height to be customized.
CustomServerModeSortAllows you to implement a custom sorting algorithm for the field values in OLAP and server modes.
CustomSummaryAllows you to calculate a custom summary.
CustomUnboundFieldDataEnables providing data to unbound fields.
DataSourceChangedFires when the Pivot Grid Control’s data source changes.
DisposedOccurs when the component is disposed by a call to the Dispose() method. Inherited from Component.
DockChangedOccurs when the value of the Dock property changes. Inherited from Control.
DoubleClickOccurs when the control is double-clicked. Inherited from Control.
DragDropOccurs when a drag-and-drop operation is completed. Inherited from Control.
DragEnterOccurs when an object is dragged into the control’s bounds. Inherited from Control.
DragLeaveOccurs when an object is dragged out of the control’s bounds. Inherited from Control.
DragOverOccurs when an object is dragged over the control’s bounds. Inherited from Control.
EditorKeyDownOccurs when a key is pressed within an in-place editor that belongs to the container control. Inherited from EditorContainer.
EditorKeyPressOccurs when a character key is pressed within an in-place editor that belongs to the container control. Inherited from EditorContainer.
EditorKeyUpOccurs when a pressed key is released within an in-place editor that belongs to the container control. Inherited from EditorContainer.
EditValueChangedOccurs when the cell value changes and allows you to save the changed value.
EnabledChangedOccurs when the Enabled property value has changed. Inherited from Control.
EndRefreshOccurs after the control’s data recalculation has been completed.
EnterOccurs when the control is entered. Inherited from Control.
ExportFinishedOccurs after the PivotGrid’s export has been completed.
ExportStartedOccurs after the PivotGrid’s export has been started.
ExpressionEditorCreated
FieldAreaChangedOccurs after a field location or visibility has been changed.
FieldAreaChangingEnables you to control whether the dragged field header can be dropped at the area it’s currently located over.
FieldAreaIndexChangedOccurs after a field has been moved.
FieldExpandedInFieldGroupChangedFires when the expansion status of fields combined into a field group is changed.
FieldFilterChangedOccurs after a specific field’s filter criteria was changed.
FieldFilterChangingAllows you to customize the filter that is being applied or cancel filtering.
FieldPropertyChangedOccurs after a field’s property has been changed.
FieldTooltipShowingOccurs before a tooltip is invoked.
FieldUnboundExpressionChangedFires after the PivotGridFieldBase.UnboundExpression property’s value has been changed.
FieldValueCollapsedFires after a field value has been collapsed.
FieldValueCollapsingEnables you to control whether field values can be collapsed.
FieldValueDisplayTextAllows you to change the display text and display field’s data in a more user-friendly format.
FieldValueExpandedFires after a field value has been expanded.
FieldValueExpandingEnables you to control whether field values can be expanded.
FieldValueImageIndexEnables images to be shown within column and row headers.
FieldValueNotExpandedOccurs 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.
FieldVisibleChangedOccurs after a field has been shown or hidden.
FieldWidthChangedProvides a notification that the field’s width has been changed.
FilterEditorCreatedAllows you to customize the Filter Editor before it is displayed on-screen.
FilterPopupExcelCustomizeTemplateAllows you to customize templates used by Excel-style filter popups and external editors generated using Filtering UI Context.
FilterPopupExcelDataAllows 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.
FilterPopupExcelParseFilterCriteriaAllows you to parse the filter criteria applied to data and select the corresponding values in the filter menu.
FilterPopupExcelPrepareTemplateAllows you to replace templates used by Excel-style filter popups and external editors generated using Filtering UI Context.
FilterPopupExcelQueryFilterCriteriaFires when a filter criteria is about to be applied to data and allows you to customize the filter criteria.
FocusedCellChangedFires in response to cell focus changing.
FontChangedOccurs when the Font property value changes. Inherited from Control.
ForeColorChangedOccurs when the ForeColor property value changes. Inherited from Control.
GiveFeedbackOccurs during a drag operation. Inherited from Control.
GotFocusOccurs when the control receives focus. Inherited from Control.
GridLayoutFires after the control’s layout has been changed.
GroupFilterChangedOccurs after a group filter condition was changed.
HandleCreatedOccurs when a handle is created for the control. Inherited from Control.
HandleDestroyedOccurs when the control’s handle is in the process of being destroyed. Inherited from Control.
HelpRequestedOccurs when the user requests help for a control. Inherited from Control.
HiddenEditorFires after an in-place editor has been closed.
HideCustomizationFormFires before the Customization Form is closed.
ImeModeChangedOccurs when the ImeMode property has changed. Inherited from Control.
InvalidatedOccurs when a control’s display requires redrawing. Inherited from Control.
InvalidValueExceptionEnables you to provide a proper response to entering an invalid cell value.
KeyDownOccurs when a key is pressed while the control has focus. Inherited from Control.
KeyPressOccurs when a character. space or backspace key is pressed while the control has focus. Inherited from Control.
KeyUpOccurs when a key is released while the control has focus. Inherited from Control.
LayoutOccurs when a control should reposition its child controls. Inherited from Control.
LayoutUpgradeOccurs 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.
LeaveOccurs when the input focus leaves the control. Inherited from Control.
LeftTopCellChangedOccurs after the Pivot Grid Control is scrolled.
LocationChangedOccurs when the Location property value has changed. Inherited from Control.
LostFocusOccurs when the control loses focus. Inherited from Control.
MarginChangedOccurs when the control’s margin changes. Inherited from Control.
MenuItemClickAllows custom responses to be provided for clicks on context menu items.
MouseCaptureChangedOccurs when the control loses mouse capture. Inherited from Control.
MouseClickOccurs when the control is clicked by the mouse. Inherited from Control.
MouseDoubleClickOccurs when the control is double clicked by the mouse. Inherited from Control.
MouseDownOccurs when the mouse pointer is over the control and a mouse button is pressed. Inherited from Control.
MouseEnterOccurs when the mouse pointer enters the control. Inherited from Control.
MouseHoverOccurs when the mouse pointer rests on the control. Inherited from Control.
MouseLeaveOccurs when the mouse pointer leaves the control. Inherited from Control.
MouseMoveOccurs when the mouse pointer is moved over the control. Inherited from Control.
MouseUpOccurs when the mouse pointer is over the control and a mouse button is released. Inherited from Control.
MouseWheelOccurs when the mouse wheel moves while the control has focus. Inherited from Control.
MoveOccurs when the control is moved. Inherited from Control.
OLAPExceptionObsolete. Raised when a query processing error occurs on a bound OLAP server, or when the connection to this server is lost.
OLAPQueryDataAllows you to get a query used to obtain data in PivotGrid.
OLAPQueryTimeoutFires after a specific interval of time has elapsed when sending a query to an OLAP server.
PaddingChangedOccurs when the control’s padding changes. Inherited from Control.
PaintOccurs when the control is redrawn. Inherited from Control.
PaintExA DirectX-compatible method that replaces the standard Control.Paint method.
ParentChangedOccurs when the Parent property value changes. Inherited from Control.
PopupMenuShowingAllows you to customize built-in context menus or invoke custom menus.
PreviewKeyDownOccurs before the KeyDown event when a key is pressed while focus is on this control. Inherited from Control.
PropertyDeserializing
PropertySerializing
QueryAccessibilityHelpOccurs when AccessibleObject is providing help to accessibility applications. Inherited from Control.
QueryContinueDragOccurs 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.
QueryCustomFunctionsAllows 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.
QueryExceptionOccurs when a query processing error occurs on a bound server providing data for the PivotGridControl.
RegionChangedOccurs when the value of the Region property changes. Inherited from Control.
ResizeOccurs when the control is resized. Inherited from Control.
RightToLeftChangedOccurs when the RightToLeft property value changes. Inherited from Control.
ShowCustomizationFormFires immediately after the Customization Form has been invoked.
ShowFilterPopupExcelAllows you to customize the Excel-style filter popup (for instance, to hide specific filter conditions from the Filters tab).
ShowingCustomizationFormOccurs before the Customization Form is displayed.
ShowingEditorAllows you to cancel editor activation.
ShownEditorFires after a cell editor has been invoked.
SizeChangedOccurs when the Size property value changes. Inherited from Control.
StyleChangedOccurs when the control style changes. Inherited from Control.
SystemColorsChangedOccurs when the system colors change. Inherited from Control.
TabIndexChangedOccurs when the TabIndex property value changes. Inherited from Control.
TabStopChangedOccurs when the TabStop property value changes. Inherited from Control.
TextChangedOccurs when the Text property value changes. Inherited from Control.
UnboundExpressionEditorCreatedFires after an Expression Editor is created for an unbound field.
UserActionChangedAllows you to respond to end-user actions performed on the PivotGridControl.
ValidatedOccurs when the control is finished validating. Inherited from Control.
ValidatingOccurs when the control is validating. Inherited from Control.
ValidatingEditorEnables you to manually validate cell values.
VisibleChangedOccurs when the Visible property value changes. Inherited from Control.

See Also

PivotGridControl Class

DevExpress.XtraPivotGrid Namespace