Skip to main content
A newer version of this page is available. .

PivotGridControl Properties

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