PivotGridControl Events

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

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.