Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Expand]Controls and Libraries
 [Expand]Common Features
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.DocumentView.Controls
  [Expand]DevExpress.LookAndFeel
  [Expand]DevExpress.LookAndFeel.Helpers
  [Expand]DevExpress.Skins
  [Expand]DevExpress.Snap
  [Expand]DevExpress.Snap.API.Native
  [Expand]DevExpress.Snap.Core
  [Expand]DevExpress.Snap.Core.API
  [Expand]DevExpress.Snap.Core.Fields
  [Expand]DevExpress.Snap.Core.Forms
  [Expand]DevExpress.Snap.Core.Options
  [Expand]DevExpress.Snap.Core.Services
  [Expand]DevExpress.Snap.Extensions
  [Expand]DevExpress.Snap.Extensions.Localization
  [Expand]DevExpress.Snap.Extensions.UI
  [Expand]DevExpress.Snap.Localization
  [Expand]DevExpress.Snap.Options
  [Expand]DevExpress.Snap.Services
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Animation
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Drawing
  [Expand]DevExpress.Utils.Menu
  [Expand]DevExpress.Utils.Taskbar
  [Expand]DevExpress.Utils.Taskbar.Core
  [Expand]DevExpress.Utils.UI.Localization
  [Expand]DevExpress.Utils.VisualEffects
  [Expand]DevExpress.Utils.Win
  [Expand]DevExpress.XtraBars
  [Expand]DevExpress.XtraBars.Alerter
  [Expand]DevExpress.XtraBars.Docking
  [Expand]DevExpress.XtraBars.Docking2010
  [Expand]DevExpress.XtraBars.Docking2010.Customization
  [Expand]DevExpress.XtraBars.Docking2010.Views
  [Expand]DevExpress.XtraBars.Docking2010.Views.NativeMdi
  [Expand]DevExpress.XtraBars.Docking2010.Views.Tabbed
  [Expand]DevExpress.XtraBars.Docking2010.Views.Widget
  [Expand]DevExpress.XtraBars.Docking2010.Views.WindowsUI
  [Expand]DevExpress.XtraBars.Localization
  [Expand]DevExpress.XtraBars.Navigation
  [Expand]DevExpress.XtraBars.Ribbon
  [Expand]DevExpress.XtraBars.Ribbon.Gallery
  [Expand]DevExpress.XtraBars.Ribbon.ViewInfo
  [Expand]DevExpress.XtraBars.ToastNotifications
  [Expand]DevExpress.XtraBars.Utils
  [Expand]DevExpress.XtraBars.WinRTLiveTiles
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Designer
  [Expand]DevExpress.XtraCharts.Wizard
  [Expand]DevExpress.XtraDataLayout
  [Expand]DevExpress.XtraDiagram
  [Expand]DevExpress.XtraDiagram.Options
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.ButtonPanel
  [Expand]DevExpress.XtraEditors.Calendar
  [Expand]DevExpress.XtraEditors.Camera
  [Expand]DevExpress.XtraEditors.Container
  [Expand]DevExpress.XtraEditors.Controls
  [Expand]DevExpress.XtraEditors.CustomEditor
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraEditors.Filtering
  [Expand]DevExpress.XtraEditors.Mask
  [Expand]DevExpress.XtraEditors.Persistent
  [Expand]DevExpress.XtraEditors.Repository
  [Expand]DevExpress.XtraEditors.ViewInfo
  [Expand]DevExpress.XtraFilterEditor
  [Expand]DevExpress.XtraGauges.Presets.Styles
  [Expand]DevExpress.XtraGauges.Win
  [Expand]DevExpress.XtraGauges.Win.Base
  [Expand]DevExpress.XtraGauges.Win.Gauges.Circular
  [Expand]DevExpress.XtraGauges.Win.Gauges.Digital
  [Expand]DevExpress.XtraGauges.Win.Gauges.Linear
  [Expand]DevExpress.XtraGauges.Win.Gauges.State
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraGrid.Columns
  [Expand]DevExpress.XtraGrid.EditForm
  [Expand]DevExpress.XtraGrid.FilterEditor
  [Expand]DevExpress.XtraGrid.Localization
  [Expand]DevExpress.XtraGrid.Views.BandedGrid
  [Expand]DevExpress.XtraGrid.Views.BandedGrid.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Base
  [Expand]DevExpress.XtraGrid.Views.Base.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Card
  [Expand]DevExpress.XtraGrid.Views.Card.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Grid
  [Expand]DevExpress.XtraGrid.Views.Grid.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Layout
  [Expand]DevExpress.XtraGrid.Views.Layout.Events
  [Expand]DevExpress.XtraGrid.Views.Layout.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Printing
  [Expand]DevExpress.XtraGrid.Views.Tile
  [Expand]DevExpress.XtraGrid.Views.WinExplorer
  [Expand]DevExpress.XtraGrid.WinExplorer
  [Expand]DevExpress.XtraLayout
  [Expand]DevExpress.XtraLayout.Customization
  [Expand]DevExpress.XtraLayout.HitInfo
  [Expand]DevExpress.XtraLayout.Localization
  [Expand]DevExpress.XtraLayout.Utils
  [Expand]DevExpress.XtraMap
  [Expand]DevExpress.XtraMap.Printing
  [Expand]DevExpress.XtraNavBar
  [Expand]DevExpress.XtraNavBar.ViewInfo
  [Expand]DevExpress.XtraPdfViewer
  [Expand]DevExpress.XtraPdfViewer.Commands
  [Expand]DevExpress.XtraPdfViewer.Localization
  [Collapse]DevExpress.XtraPivotGrid
   [Expand]CancelPivotCellEditEventArgs Class
   [Expand]CustomCustomizationFormSortEventArgs Class
   [Expand]CustomEditValueEventArgs Class
    CustomEditValueEventHandler Delegate
   [Expand]CustomExportCellEventArgs Class
   [Expand]CustomExportFieldValueEventArgs Class
   [Expand]CustomExportHeaderEventArgs Class
   [Expand]CustomFieldDataEventArgs Class
    CustomFieldDataEventHandler Delegate
   [Expand]CustomizationFormShowingEventArgs Class
    CustomizationFormShowingEventHandler Delegate
   [Expand]CustomizePivotCellEventArgs Class
    CustomizePivotCellEventHandler Delegate
   [Expand]CustomServerModeSortEventArgs Class
   [Expand]EditValueChangedEventArgs Class
    EditValueChangedEventHandler Delegate
    ExcelFilterDateTimeValuesTabFilterType Enumeration
    ExcelFilterDefaultTab Enumeration
    ExcelFilterEnumFilters Enumeration
    ExcelFilterNumericValuesTabFilterType Enumeration
    ExcelFilterTextFilters Enumeration
    FieldFilterPopupMode Enumeration
   [Expand]FieldValueCell Class
   [Expand]FilterPopupExcelCustomizeTemplateEventArgs Class
    FilterPopupExcelCustomizeTemplateEventHandler Delegate
   [Expand]FilterPopupExcelDataEventArgs Class
    FilterPopupExcelDataEventHandler Delegate
   [Expand]FilterPopupExcelEventArgs Class
    FilterPopupExcelEventHandler Delegate
   [Expand]FilterPopupExcelPrepareTemplateEventArgs Class
    FilterPopupExcelPrepareTemplateEventHandler Delegate
   [Expand]FilterPopupExcelQueryFilterCriteriaEventArgs Class
    FilterPopupExcelQueryFilterCriteriaEventHandler Delegate
    FilterPopupToolbarButtons Enumeration
   [Expand]FormatRuleFieldIntersectionSettings Class
   [Expand]FormatRuleSettings Class
   [Expand]FormatRuleTotalTypeSettings Class
   [Expand]PivotAreaChangingEventArgs Class
    PivotAreaChangingEventHandler Delegate
   [Expand]PivotCellBaseEventArgs Class
   [Expand]PivotCellDisplayTextEventArgs Class
    PivotCellDisplayTextEventHandler Delegate
   [Expand]PivotCellEditEventArgs Class
   [Expand]PivotCellEventArgs Class
    PivotCellEventHandler Delegate
   [Expand]PivotCellValueEventArgs Class
   [Expand]PivotContextMenuIds Class
   [Expand]PivotCustomAppearanceEventArgs Class
    PivotCustomAppearanceEventHandler Delegate
   [Expand]PivotCustomAppearanceThreadSafeEventArgs Class
   [Expand]PivotCustomCellEditEventArgs Class
   [Expand]PivotCustomChartDataSourceDataEventArgs Class
    PivotCustomChartDataSourceDataEventHandler Delegate
   [Expand]PivotCustomChartDataSourceRowsEventArgs Class
    PivotCustomChartDataSourceRowsEventHandler Delegate
   [Expand]PivotCustomColumnWidthEventArgs Class
   [Expand]PivotCustomDrawBaseThreadSafeEventArgs Class
   [Expand]PivotCustomDrawCellBaseEventArgs Class
   [Expand]PivotCustomDrawCellBaseThreadSafeEventArgs Class
   [Expand]PivotCustomDrawCellEventArgs Class
    PivotCustomDrawCellEventHandler Delegate
   [Expand]PivotCustomDrawCellThreadSafeEventArgs Class
   [Expand]PivotCustomDrawEventArgs Class
    PivotCustomDrawEventHandler Delegate
   [Expand]PivotCustomDrawFieldHeaderEventArgs Class
    PivotCustomDrawFieldHeaderEventHandler Delegate
   [Expand]PivotCustomDrawFieldHeaderThreadSafeEventArgs Class
   [Expand]PivotCustomDrawFieldValueEventArgs Class
    PivotCustomDrawFieldValueEventHandler Delegate
   [Expand]PivotCustomDrawFieldValueThreadSafeEventArgs Class
   [Expand]PivotCustomDrawHeaderAreaEventArgs Class
    PivotCustomDrawHeaderAreaEventHandler Delegate
   [Expand]PivotCustomDrawHeaderAreaThreadSafeEventArgs Class
   [Expand]PivotCustomDrawThreadSafeEventArgs Class
   [Expand]PivotCustomFieldValueCellsEventArgs Class
    PivotCustomFieldValueCellsEventHandler Delegate
   [Expand]PivotCustomFilterPopupItemsEventArgs Class
    PivotCustomFilterPopupItemsEventHandler Delegate
   [Expand]PivotCustomGroupIntervalEventArgs Class
    PivotCustomGroupIntervalEventHandler Delegate
   [Expand]PivotCustomRowHeightEventArgs Class
    PivotEndUpdateMode Enumeration
   [Expand]PivotFieldDisplayTextEventArgs Class
    PivotFieldDisplayTextEventHandler Delegate
   [Expand]PivotFieldEventArgs Class
    PivotFieldEventHandler Delegate
   [Expand]PivotFieldFilterChangingEventArgs Class
    PivotFieldFilterChangingEventHandler Delegate
   [Expand]PivotFieldImageIndexEventArgs Class
    PivotFieldImageIndexEventHandler Delegate
   [Expand]PivotFieldImageIndexThreadSafeEventArgs Class
   [Expand]PivotFieldPropertyChangedEventArgs Class
    PivotFieldPropertyChangedEventHandler Delegate
   [Expand]PivotFieldTooltipShowingEventArgs Class
    PivotFieldTooltipShowingEventHandler Delegate
   [Expand]PivotFieldValueCancelEventArgs Class
    PivotFieldValueCancelEventHandler Delegate
   [Expand]PivotFieldValueEventArgs Class
    PivotFieldValueEventHandler Delegate
   [Expand]PivotFieldValueHitInfo Class
   [Expand]PivotFilter Class
   [Expand]PivotGridAppearances Class
   [Expand]PivotGridAppearancesBase Class
   [Expand]PivotGridAppearancesPrint Class
   [Expand]PivotGridCells Class
   [Collapse]PivotGridControl Class
     PivotGridControl Members
     PivotGridControl Constructor
    [Expand]PivotGridControl Properties
    [Expand]PivotGridControl Events
    [Expand]PivotGridControl Methods
   [Expand]PivotGridCustomFieldSortEventArgs Class
    PivotGridCustomFieldSortEventHandler Delegate
   [Expand]PivotGridCustomSummaryEventArgs Class
    PivotGridCustomSummaryEventHandler Delegate
   [Expand]PivotGridCustomTotal Class
   [Expand]PivotGridCustomTotalCollection Class
   [Expand]PivotGridField Class
   [Expand]PivotGridFieldAppearances Class
   [Expand]PivotGridFieldCollection Class
   [Expand]PivotGridFieldImageOptions Class
   [Expand]PivotGridFieldOptionsEx Class
   [Expand]PivotGridFieldOptionsFilter Class
   [Expand]PivotGridFieldToolTips Class
   [Expand]PivotGridFormatConditionCollection Class
   [Expand]PivotGridFormatRule Class
   [Expand]PivotGridFormatRuleCollection Class
    PivotGridHeaderHitTest Enumeration
   [Expand]PivotGridHeadersAreaHitInfo Class
   [Expand]PivotGridHitInfo Class
    PivotGridHitTest Enumeration
   [Expand]PivotGridMenuEventArgs Class
   [Expand]PivotGridMenuEventArgsBase Class
    PivotGridMenuEventHandler Delegate
   [Expand]PivotGridMenuItemClickEventArgs Class
   [Expand]PivotGridMenuItemClickEventArgsBase Class
    PivotGridMenuItemClickEventHandler Delegate
    PivotGridMenuType Enumeration
   [Expand]PivotGridOptionsBehavior Class
   [Expand]PivotGridOptionsCustomizationEx Class
   [Expand]PivotGridOptionsFilterPopup Class
   [Expand]PivotGridOptionsHint Class
   [Expand]PivotGridOptionsMenu Class
   [Expand]PivotGridOptionsView Class
    PivotGridScrolling Enumeration
   [Expand]PivotGridStyleFormatCondition Class
    PivotGridValueHitTest Enumeration
   [Expand]PivotGroupEventArgs Class
    PivotGroupEventHandler Delegate
   [Expand]PivotLeftTopCellChangedEventArgs Class
   [Expand]PivotOlapExceptionEventArgs Class
    PivotOlapExceptionEventHandler Delegate
   [Expand]PivotQueryExceptionEventArgs Class
    PivotQueryExceptionEventHandler Delegate
    PivotShowButtonModeEnum Enumeration
   [Expand]PivotUserActionEventArgs Class
    PivotUserActionEventHandler Delegate
   [Expand]PivotXlsExportOptions Class
   [Expand]PivotXlsxExportOptions Class
   [Expand]PopupMenuShowingEventArgs Class
    PopupMenuShowingEventHandler Delegate
   [Expand]Prefilter Class
    UserAction Enumeration
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.Control
  [Expand]DevExpress.XtraPrinting.Preview
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Menu
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Printing
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Reporting.UI
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpellChecker.Localization
  [Expand]DevExpress.XtraSplashForm
  [Expand]DevExpress.XtraSplashScreen
  [Expand]DevExpress.XtraSpreadsheet
  [Expand]DevExpress.XtraSpreadsheet.Services
  [Expand]DevExpress.XtraTab
  [Expand]DevExpress.XtraTab.Buttons
  [Expand]DevExpress.XtraTab.ViewInfo
  [Expand]DevExpress.XtraTabbedMdi
  [Expand]DevExpress.XtraToolbox
  [Expand]DevExpress.XtraTreeList
  [Expand]DevExpress.XtraTreeList.Columns
  [Expand]DevExpress.XtraTreeList.Data
  [Expand]DevExpress.XtraTreeList.Localization
  [Expand]DevExpress.XtraTreeList.Menu
  [Expand]DevExpress.XtraTreeList.Nodes
  [Expand]DevExpress.XtraTreeList.Nodes.Operations
  [Expand]DevExpress.XtraTreeList.StyleFormatConditions
  [Expand]DevExpress.XtraTreeMap
  [Expand]DevExpress.XtraVerticalGrid
  [Expand]DevExpress.XtraVerticalGrid.Events
  [Expand]DevExpress.XtraVerticalGrid.Localization
  [Expand]DevExpress.XtraVerticalGrid.Rows
  [Expand]DevExpress.XtraWaitForm
  [Expand]DevExpress.XtraWizard
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

PivotGridControl Members

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

Expanded Public Constructors

Show: Inherited
  Name Description
Public method PivotGridControl Initializes a new instance of the PivotGridControl class.
Top

Expanded Public Properties

Show: Inherited
  Name Description
Public property AccessibilityObject Gets the System.Windows.Forms.AccessibleObject assigned to the control. (Inherited from System.Windows.Forms.Control)
Public property AccessibleDefaultActionDescription Gets or sets the default action description of the control for use by accessibility client applications. (Inherited from System.Windows.Forms.Control)
Public property AccessibleDescription Gets or sets the description of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control)
Public property AccessibleName Gets or sets the name of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control)
Public property AccessibleRole Gets or sets the accessible role of the control (Inherited from System.Windows.Forms.Control)
Public property ActiveEditor Gets the PivotGrid's active editor.
Public property ActiveFilter
Public property ActiveFilterCriteria
Public property ActiveFilterEnabled
Public property ActiveFilterString
Public property AllowDrop Gets or sets a value indicating whether the control can accept data that the user drags onto it. (Inherited from System.Windows.Forms.Control)
Public property 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 System.Windows.Forms.Control)
Public property Appearance Provides access to the properties that control the appearance of the PivotGrid control's elements.
Public property AppearancePrint Provides access to the properties that specify the appearances of the PivotGrid control's elements when it's printed.
Public property AutoScrollOffset Gets or sets where this control is scrolled to in System.Windows.Forms.ScrollableControl.ScrollControlIntoView. (Inherited from System.Windows.Forms.Control)
Public property AutoSize This property is not relevant for this class. (Inherited from System.Windows.Forms.Control)
Public property BackColor Gets or sets the background color for the control. (Inherited from System.Windows.Forms.Control)
Public property BackgroundImage This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Public property BackgroundImageLayout This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Public property BindingContext Gets or sets the System.Windows.Forms.BindingContext for the control. (Inherited from System.Windows.Forms.Control)
Public property BorderStyle Gets or sets the border style for the PivotGridControl.
Public property 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 System.Windows.Forms.Control)
Public property Bounds Gets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. (Inherited from System.Windows.Forms.Control)
Public property CanFocus Gets a value indicating whether the control can receive focus. (Inherited from System.Windows.Forms.Control)
Public property CanSelect Gets a value indicating whether the control can be selected. (Inherited from System.Windows.Forms.Control)
Public property Capture Gets or sets a value indicating whether the control has captured the mouse. (Inherited from System.Windows.Forms.Control)
Public property 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 System.Windows.Forms.Control)
Public property Cells Gets the object which contains information on the cells that are displayed by the control.
Public propertyStatic member CheckForIllegalCrossThreadCalls Gets or sets a value indicating whether to catch calls on the wrong thread that access a control's System.Windows.Forms.Control.Handle property when an application is being debugged. (Inherited from System.Windows.Forms.Control)
Public property ClientRectangle Gets the rectangle that represents the client area of the control. (Inherited from System.Windows.Forms.Control)
Public property ClientSize Gets or sets the height and width of the client area of the control. (Inherited from System.Windows.Forms.Control)
Public property CompanyName ControlCompanyNameDescr (Inherited from System.Windows.Forms.Control)
Public property Container Gets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
Public property ContainsFocus Gets a value indicating whether the control, or one of its child controls, currently has the input focus. (Inherited from System.Windows.Forms.Control)
Public property ContextMenu Gets or sets the shortcut menu associated with the control. (Inherited from System.Windows.Forms.Control)
Public property ContextMenuStrip Gets or sets the System.Windows.Forms.ContextMenuStrip associated with this control. (Inherited from System.Windows.Forms.Control)
Public property Controls Gets the collection of controls contained within the control. (Inherited from System.Windows.Forms.Control)
Public property Created Gets a value indicating whether the control has been created. (Inherited from System.Windows.Forms.Control)
Public property Cursor Gets or sets the cursor that is displayed when the mouse pointer is over the control. (Inherited from System.Windows.Forms.Control)
Public property CustomizationForm Provides access to the Customization Form.
Public property CustomizationFormBounds Gets or sets the boundaries of the Customization Form.
Public propertyStatic member CustomizationTreeNodeImages Specifies the collection of images identifying nodes in the Customization Form used when the control is in OLAP mode.
Public property DataBindings Gets the data bindings for the control. (Inherited from System.Windows.Forms.Control)
Public property DataMember Gets or sets the data source member which supplies data to the control.
Public property DataSource Gets or sets the object used as the data source for the current control.
Public propertyStatic member DefaultBackColor Gets the default background color of the control. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member DefaultDataProcessingEngine Gets or sets a default engine used to perform data processing in the pivot grid.
Public propertyStatic member DefaultFont Gets the default font of the control. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member DefaultForeColor Gets the default foreground color of the control. (Inherited from System.Windows.Forms.Control)
Public property DeviceDpi (Inherited from System.Windows.Forms.Control)
Public property DisplayRectangle Gets the rectangle that represents the display area of the control. (Inherited from System.Windows.Forms.Control)
Public property Disposing Gets a value indicating whether the base System.Windows.Forms.Control class is in the process of disposing. (Inherited from System.Windows.Forms.Control)
Public property 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 System.Windows.Forms.Control)
Public property EditValue Gets or sets the active editor's value.
Public property Enabled Gets or sets a value indicating whether the control can respond to user interaction. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member EndUpdateMode Gets or sets whether the PivotGrid will be immediately redrawn after calling the EndUpdate method.
Public property Fields Provides access to a PivotGrid control's field collection.
Public property Focused Gets a value indicating whether the control has input focus. (Inherited from System.Windows.Forms.Control)
Public property Font Overrides the base class Font property.
Public property ForeColor Gets or sets the foreground color of the control. (Inherited from System.Windows.Forms.Control)
Public property FormatConditions Gets the collection of style format conditions.
Public property FormatRules Gets the collection of style format rules for a PivotGridControl.
Public property Groups Gets the collection of field groups.
Public property Handle Gets the window handle that the control is bound to. (Inherited from System.Windows.Forms.Control)
Public property HasChildren Gets a value indicating whether the control contains one or more child controls. (Inherited from System.Windows.Forms.Control)
Public property HeaderImages Gets or sets the source of images available for display within field headers.
Public property Height Gets or sets the height of the control. (Inherited from System.Windows.Forms.Control)
Public property ImeMode Gets or sets the Input Method Editor (IME) mode of the control. (Inherited from System.Windows.Forms.Control)
Public property 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 System.Windows.Forms.Control)
Public property IsAccessible Gets or sets a value indicating whether the control is visible to accessibility applications. (Inherited from System.Windows.Forms.Control)
Public property IsAsyncInProgress Gets whether an asynchronous operation is in progress.
Public property IsDisposed Gets a value indicating whether the control has been disposed of. (Inherited from System.Windows.Forms.Control)
Public property IsDragging Indicates whether a field header is being dragged by a user.
Public property IsHandleCreated Gets a value indicating whether the control has a handle associated with it. (Inherited from System.Windows.Forms.Control)
Public property IsLoading (Inherited from DevExpress.XtraPivotGrid.ViewInfo.BaseControl)
Public property IsMirrored Gets a value indicating whether the control is mirrored. (Inherited from System.Windows.Forms.Control)
Public property IsOLAPDataSource Returns whether a connection string is specified via the OLAPConnectionString property, and so the control is bound to a cube in an MS Analysis Services database.
Public property IsPrintingAvailable Indicates whether the Pivot Grid Control can be printed.
Public property IsUpdateLocked Gets whether the PivotGridControl has been locked for updating.
Public property LayoutEngine Gets a cached instance of the control's layout engine. (Inherited from System.Windows.Forms.Control)
Public property 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 System.Windows.Forms.Control)
Public property LeftTopCoord Gets or sets the column and row indexes of the data cell displayed in the top left corner.
Public property ListSource Gets the actual data source whose data is displayed within the control.
Public property 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 System.Windows.Forms.Control)
Public property LookAndFeel Provides access to the settings that control the Pivot Grid Control's look and feel.
Public property Margin Gets or sets the space between controls. (Inherited from System.Windows.Forms.Control)
Public property MaximumSize Gets or sets the size that is the upper limit that System.Windows.Forms.Control.GetPreferredSize can specify. (Inherited from System.Windows.Forms.Control)
Public property MenuManager Gets or sets the menu manager which controls the look and feel of the context menus.
Public property MinimumSize Gets or sets the size that is the lower limit that System.Windows.Forms.Control.GetPreferredSize can specify. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member ModifierKeys Gets a value indicating which of the modifier keys (SHIFT, CTRL, and ALT) is in a pressed state. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member MouseButtons Gets a value indicating which of the mouse buttons is in a pressed state. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member MousePosition Gets the position of the mouse cursor in screen coordinates. (Inherited from System.Windows.Forms.Control)
Public property Name Gets or sets the name of the control. (Inherited from System.Windows.Forms.Control)
Public property OLAPConnectionString Specifies a connection string to a cube in an MS Analysis Services database.
Public property OLAPDataProvider Gets or sets which data provider should be used to bind to an OLAP cube.
Public property OptionsBehavior Provides access to the control's behavior options.
Public property OptionsChartDataSource Provides access to the options controlling the display of the PivotGrid control's data in a chart control.
Public property OptionsCustomization Provides access to the Pivot Grid Control's customization options.
Public property OptionsData Provides access to the Pivot Grid Control's data specific options.
Public property OptionsDataField Provides access to the options which control the presentation of the data fields in the PivotGrid.
Public property OptionsFilterPopup Contains settings that specify the appearance and behavior of filter dropdown windows.
Public property OptionsHint Provides access to the Pivot Grid Control's hint options.
Public property 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).
Public property OptionsMenu Provides access to the Pivot Grid Control's menu options.
Public property OptionsOLAP Provides access to the Pivot Grid Control's OLAP mode specific options.
Public property OptionsPrint Provides access to the Pivot Grid Control's print options.
Public property OptionsSelection Provides access to the Pivot Grid Control's selection options.
Public property OptionsView Provides access to the Pivot Grid Control's display options.
Public property Padding Gets or sets padding within the control. (Inherited from System.Windows.Forms.Control)
Public property PaintAppearance Provides access to the appearance settings currently used to paint the Pivot Grid Control's elements.
Public property PaintAppearancePrint Provides access to the appearance settings used to paint the Pivot Grid Control's elements when it's printed.
Public property Parent Gets or sets the parent container of the control. (Inherited from System.Windows.Forms.Control)
Public property PreferredSize Gets the size of a rectangular area into which the control can fit. (Inherited from System.Windows.Forms.Control)
Public property Prefilter Gets the Prefilter's settings.
Public property ProductName Gets the product name of the assembly containing the control. (Inherited from System.Windows.Forms.Control)
Public property ProductVersion Gets the version of the assembly containing the control. (Inherited from System.Windows.Forms.Control)
Public property RecreatingHandle Gets a value indicating whether the control is currently re-creating its handle. (Inherited from System.Windows.Forms.Control)
Public property Region Gets or sets the window region associated with the control. (Inherited from System.Windows.Forms.Control)
Public property RepositoryItems Returns the collection of repository items (inplace editors).
Public property 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 System.Windows.Forms.Control)
Public property RightToLeft Gets or sets a value indicating whether control's elements are aligned to support locales using right-to-left fonts. (Inherited from System.Windows.Forms.Control)
Public property Site Gets or sets the site of the control. (Inherited from System.Windows.Forms.Control)
Public property Size Gets or sets the height and width of the control. (Inherited from System.Windows.Forms.Control)
Public property TabIndex Gets or sets the tab order of the control within its container. (Inherited from System.Windows.Forms.Control)
Public property TabStop Gets or sets a value indicating whether the user can give the focus to this control using the TAB key. (Inherited from System.Windows.Forms.Control)
Public property Tag Gets or sets the object that contains data about the control. (Inherited from System.Windows.Forms.Control)
Public property Text Gets or sets the string associated with the control.
Public property ToolTipController Gets or sets the tooltip controller component that controls the appearance, position and the content of the hints displayed by the PivotGrid control.
Public property 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 System.Windows.Forms.Control)
Public property TopLevelControl Gets the parent control that is not parented by another Windows Forms control. Typically, this is the outermost System.Windows.Forms.Form that the control is contained in. (Inherited from System.Windows.Forms.Control)
Public property UseDisabledStatePainter Gets or sets whether the control is painted grayed out, when in the disabled state.
Public property UserAction Gets the end-user action performed on the PivotGridControl.
Public property UseWaitCursor Gets or sets a value indicating whether to use the wait cursor for the current control and all child controls. (Inherited from System.Windows.Forms.Control)
Public property ValueImages Gets or sets the source of images that are available for display within field values.
Public property Visible Gets or sets a value indicating whether the control and all its parent controls are displayed. (Inherited from System.Windows.Forms.Control)
Public property Width Gets or sets the width of the control. (Inherited from System.Windows.Forms.Control)
Public property WindowTarget This property is not relevant for this class. (Inherited from System.Windows.Forms.Control)
Top

Expanded Public Methods

Show: Inherited
  Name Description
Public methodStatic member About Activates the Pivot Grid Control's About dialog box.
Public method BeginInit (Inherited from DevExpress.XtraPivotGrid.ViewInfo.BaseControl)
Public method BeginInvoke Executes the specified delegate asynchronously with the specified arguments, on the thread that the control's underlying handle was created on. (Inherited from System.Windows.Forms.Control)
Public method BeginUpdate Locks the PivotGridControl object by preventing visual updates of the object and its elements until the EndUpdate method is called.
Public method BestFit Overloaded. Resizes columns that correspond to the specified field to the minimum width required to completely display their contents.
Public method BestFitColumnArea Resizes columns in the Data Area to the minimum width required to completely display their contents.
Public method BestFitDataHeaders Resizes the Data Header Area to the minimum width required to completely display data field headers.
Public method BestFitRowArea Resizes columns that display row field values to the minimum width required to completely display their contents.
Public method BringToFront Brings the control to the front of the z-order. (Inherited from System.Windows.Forms.Control)
Public method CalcHitInfo Returns information on the grid elements located at the specified point.
Public method CanResizeField Indicates whether the field can be resized.
Public method ChangeFieldExpandedAsync Overloaded. Expands or collapses all values of the specified field asynchronously.
Public method ChangeFieldSortOrderAsync Overloaded. Toggles the sort order of the specified field asynchronously.
Public method ClearFieldSortingAsync Overloaded. Clears field sorting asynchronously in OLAP mode.
Public method CloseEditor Overloaded. Hides the active editor, saving changes made.
Public method CollapseAll Collapses all the columns and rows in the PivotGridControl.
Public method CollapseAllAsync Overloaded. Collapses all columns and rows in a Pivot Grid Control asynchronously.
Public method CollapseAllColumns Collapses all columns.
Public method CollapseAllColumnsAsync Overloaded. Collapses all columns asynchronously.
Public method CollapseAllRows Collapses all rows.
Public method CollapseAllRowsAsync Overloaded. Collapses all rows asynchronously.
Public method CollapseValue Collapses a specific column or row that is identified by the specified values.
Public method CollapseValueAsync Overloaded. Collapses the specified column or row asynchronously.
Public method Contains Retrieves a value indicating whether the specified control is a child of the control. (Inherited from System.Windows.Forms.Control)
Public method ConvertFormatConditionToFormatRules Converts the PivotGridStyleFormatCondition object to the PivotGridFormatRule object.
Public method CreateControl Forces the creation of the control, including the creation of the handle and any child controls. (Inherited from System.Windows.Forms.Control)
Public method CreateDrillDownDataSource Overloaded. Returns a list of records used to calculate a summary value for the specified cell. Allows you to limit the number of records to be returned.
Public method CreateDrillDownDataSourceAsync Overloaded. Returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to specify the columns and limit the number of records to be returned.
Public method CreateGraphics Creates the System.Drawing.Graphics for the control. (Inherited from System.Windows.Forms.Control)
Public method CreateObjRef Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
Public method CreateOLAPDataSourceClone Creates a copy of the current pivot grid's OLAP data source instance.
Public method CreateOLAPDrillDownDataSource Overloaded. 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.
Public method CreateOLAPDrillDownDataSourceAsync Overloaded. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to specify which columns should be returned.
Public method CreateServerModeDrillDownDataSource Overloaded. 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.
Public method CreateServerModeDrillDownDataSourceAsync Overloaded. In server mode, returns a list of records used to calculate a summary value for the specified cell asynchronously. Allows you to specify which columns should be returned.
Public method CreateSummaryDataSource Returns a summary data source.
Public method DestroyCustomization Closes the Customization Form.
Public method Dispose Releases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
Public method DoDragDrop Begins a drag-and-drop operation. (Inherited from System.Windows.Forms.Control)
Public method DrawToBitmap Supports rendering to the specified bitmap. (Inherited from System.Windows.Forms.Control)
Public method EndInit (Inherited from DevExpress.XtraPivotGrid.ViewInfo.BaseControl)
Public method EndInvoke Retrieves the return value of the asynchronous operation represented by the System.IAsyncResult passed. (Inherited from System.Windows.Forms.Control)
Public method EndUpdate Unlocks the PivotGridControl object after a call to the BeginUpdate method and causes an immediate visual update.
Public method EndUpdateAsync Overloaded. Unlocks the Pivot Grid Control after the BeginUpdate method call, and starts an asynchronous update.
Public method 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.
Public methodStatic member Equals Determines whether the specified System.Object instances are considered equal. (Inherited from System.Object)
Public method Equals Determines whether the specified System.Object is equal to the current System.Object. (Inherited from System.Object)
Public method ExpandAll Expands all the columns and rows in the PivotGridControl.
Public method ExpandAllAsync Overloaded. Expands all columns and rows in the Pivot Grid Control asynchronously.
Public method ExpandAllColumns Expands all columns.
Public method ExpandAllColumnsAsync Overloaded. Expands all columns asynchronously.
Public method ExpandAllRows Expands all rows.
Public method ExpandAllRowsAsync Overloaded. Expands all rows asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
Public method ExpandValue Expands a specific column or row that is identified by the specified values.
Public method ExpandValueAsync Overloaded. Expands the specified column or row asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
Public method ExportToCsv Overloaded. Exports the control's data to the specified stream in CSV format using the specified options.
Public method ExportToDocx Overloaded. Exports the Pivot Grid Control's data to a DOCX document and sends it to the specified stream.
Public method ExportToHtml Overloaded. 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.
Public method ExportToImage Overloaded. Exports the control's data to the specified stream in BMP format.
Public method ExportToMht Overloaded. 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.
Public method ExportToPdf Overloaded. Exports the Pivot Grid Control's data to the specified PDF file.
Public method ExportToRtf Overloaded. Exports the Pivot Grid Control's data as Rich Text and sends it to the specified stream.
Public method ExportToText Overloaded. 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.
Public method ExportToXls Overloaded. Exports the Pivot Grid Control's data to the specified file as XLS.
Public method ExportToXlsx Overloaded. Exports the control's data to the specified file in XLSX (MS Excel 2007) format using the specified options.
Public method FieldsCustomization Overloaded. Invokes the Customization Form.
Public method FindForm Retrieves the form that the control is on. (Inherited from System.Windows.Forms.Control)
Public method Focus Sets input focus to the control. (Inherited from System.Windows.Forms.Control)
Public method ForceInitialize Forces the Pivot Grid Control to finish its initialization.
Public methodStatic member FromChildHandle Retrieves the control that contains the specified handle. (Inherited from System.Windows.Forms.Control)
Public methodStatic member FromHandle Returns the control that is currently associated with the specified handle. (Inherited from System.Windows.Forms.Control)
Public method GetCellValue Overloaded. Returns a cell value by the column and row indexes.
Public method GetChildAtPoint Retrieves the child control that is located at the specified coordinates. (Inherited from System.Windows.Forms.Control)
Public method GetColumnIndex Overloaded. Returns the index of the specified column.
Public method GetContainerControl Returns the next System.Windows.Forms.ContainerControl up the control's chain of parent controls. (Inherited from System.Windows.Forms.Control)
Public method GetFieldAt Returns the field whose header is displayed at the specified point.
Public method GetFieldByArea Returns a field at the specified visual position in the specified area.
Public method GetFieldList Returns the list of fields that are available in the bound data source.
Public method GetFieldsByArea Returns a list of fields displayed in the specified area.
Public method GetFieldValue Returns the specified column or row field's value for the cell addressed by its zero-based index in the Data Area.
Public method GetFieldValueOLAPMember Returns an OLAP member for the specified field value.
Public method GetFieldValueType Overloaded. Gets the type of a field value in the column or row area.
Public method GetHashCode Serves as a hash function for a particular type. System.Object.GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from System.Object)
Public method GetKPIBitmap Returns an image that corresponds to a specific KPI value.
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
Public method GetNextControl Retrieves the next control forward or back in the tab order of child controls. (Inherited from System.Windows.Forms.Control)
Public method GetOLAPKPIList Gets the list of key performance indicators (KPI) in a cube.
Public method GetOLAPKPIMeasures Returns the Measures dimension's members used to calculate the value, goal, status and weight of the specified Key Performance Indicator (KPI).
Public method GetOLAPKPIServerGraphic Returns a graphic set defined on the server for the specified KPI's trend and status.
Public method GetOLAPKPIValue Returns the specified KPI's value.
Public method GetPreferredSize Retrieves the size of a rectangular area into which a control can be fitted. (Inherited from System.Windows.Forms.Control)
Public method GetRowIndex Overloaded. Returns the index of the specified row.
Public method GetType Gets the System.Type of the current instance. (Inherited from System.Object)
Public method Hide Conceals the control from the user. (Inherited from System.Windows.Forms.Control)
Public method HideCustomization Closes the Customization Form.
Public method HideEditor Hides the active editor discarding any changes made.
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
Public method Invalidate 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 System.Windows.Forms.Control)
Public method Invoke Executes the specified delegate, on the thread that owns the control's underlying window handle, with the specified list of arguments. (Inherited from System.Windows.Forms.Control)
Public methodStatic member IsKeyLocked Determines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. (Inherited from System.Windows.Forms.Control)
Public methodStatic member IsMnemonic Determines if the specified character is the mnemonic character assigned to the control in the specified string. (Inherited from System.Windows.Forms.Control)
Public method IsObjectCollapsed Overloaded. Returns whether the specified column field value or row field value is collapsed.
Public method LayoutChanged Updates a PivotGridControl.
Public method LoadCollapsedStateFromFile Restores the collapsed state of field values from the specified file.
Public method LoadCollapsedStateFromStream Restores the collapsed state of field values from the specified stream.
Public method LogicalToDeviceUnits (Inherited from System.Windows.Forms.Control)
Public method PerformLayout Forces the control to apply layout logic to all its child controls. (Inherited from System.Windows.Forms.Control)
Public method PointToClient Computes the location of the specified screen point into client coordinates. (Inherited from System.Windows.Forms.Control)
Public method PointToScreen Computes the location of the specified client point into screen coordinates. (Inherited from System.Windows.Forms.Control)
Public method PostEditor Overloaded. Posts the value being edited to the associated data source without closing the editor.
Public method PreProcessControlMessage Preprocesses keyboard or input messages within the message loop before they are dispatched. (Inherited from System.Windows.Forms.Control)
Public method PreProcessMessage Preprocesses keyboard or input messages within the message loop before they are dispatched. (Inherited from System.Windows.Forms.Control)
Public method Print Prints the PivotGridControl.
Public method RectangleToClient Computes the size and location of the specified screen rectangle in client coordinates. (Inherited from System.Windows.Forms.Control)
Public method RectangleToScreen Computes the size and location of the specified client rectangle in screen coordinates. (Inherited from System.Windows.Forms.Control)
Public methodStatic member ReferenceEquals Determines whether the specified System.Object instances are the same instance. (Inherited from System.Object)
Public method Refresh (Inherited from DevExpress.XtraPivotGrid.ViewInfo.BaseViewInfoControl)
Public method RefreshData Reloads data from the control's data source and recalculates summaries.
Public method RefreshDataAsync Overloaded. Reloads data from the control data source and recalculates summaries asynchronously.
Public method ResetBackColor Resets the System.Windows.Forms.Control.BackColor property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetBindings Causes a control bound to the System.Windows.Forms.BindingSource to reread all the items in the list and refresh their displayed values. (Inherited from System.Windows.Forms.Control)
Public method ResetCursor Resets the System.Windows.Forms.Control.Cursor property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetFont Resets the System.Windows.Forms.Control.Font property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetForeColor Resets the System.Windows.Forms.Control.ForeColor property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetImeMode Resets the System.Windows.Forms.Control.ImeMode property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetRightToLeft Resets the System.Windows.Forms.Control.RightToLeft property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetText Resets the System.Windows.Forms.Control.Text property to its default value. (Inherited from System.Windows.Forms.Control)
Public method RestoreLayoutFromRegistry Overloaded. Restores the layout stored at the specified system registry path.
Public method RestoreLayoutFromStream Overloaded. Restores a Pivot Grid Control's layout from the specified stream, using the specified settings.
Public method RestoreLayoutFromXml Overloaded. Restores a Pivot Grid Control's layout from the specified XML file.
Public method ResumeLayout Resumes usual layout logic, optionally forcing an immediate layout of pending layout requests. (Inherited from System.Windows.Forms.Control)
Public method RetrieveFields Overloaded. Creates PivotGridField objects for all the fields in the bound data source.
Public method RetrieveFieldsAsync Overloaded. Creates PivotGridField objects for all fields in a data source, and moves them to the specified area, making them visible or hidden. Performs these actions asynchronously.
Public method SaveCollapsedStateToFile Saves the collapsed state of field values to the specified file.
Public method SaveCollapsedStateToStream Saves the collapsed state of field values to the specified stream.
Public method SaveLayoutToRegistry Overloaded. Saves a Pivot Grid Control's layout to a system registry path.
Public method SaveLayoutToStream Overloaded. Saves a Pivot Grid Control's layout to the specified stream, using the specified settings.
Public method SaveLayoutToXml Overloaded. Saves a Pivot Grid Control's layout to an XML file.
Public method SavePivotGridToFile Overloaded. Saves the Pivot Grid Control's data and full layout to the specified file.
Public method SavePivotGridToStream Overloaded. Saves the Pivot Grid Control's data and full layout to the specified stream.
Public method Scale Scales the control and all child controls by the specified scaling factor. (Inherited from System.Windows.Forms.Control)
Public method ScaleBitmapLogicalToDevice (Inherited from System.Windows.Forms.Control)
Public method Select Activates the control. (Inherited from System.Windows.Forms.Control)
Public method SelectNextControl Activates the next control. (Inherited from System.Windows.Forms.Control)
Public method SendToBack Sends the control to the back of the z-order. (Inherited from System.Windows.Forms.Control)
Public method SetBounds Sets the specified bounds of the control to the specified location and size. (Inherited from System.Windows.Forms.Control)
Public method SetDataSourceAsync Overloaded. Sets a data source for the Pivot Grid Control and loads data asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
Public method SetFieldSortingAsync Overloaded. Sets the specified sort order for the specified field asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
Public method SetOLAPConnectionStringAsync Overloaded. Sets a connection string to a cube in an MS Analysis Services database, and loads data from the cube asynchronously.
Public method Show Displays the control to the user. (Inherited from System.Windows.Forms.Control)
Public method ShowCustomization Invokes the Customization Form.
Public method ShowEditor Overloaded. Invokes the focused cell's editor.
Public method ShowPrintPreview Opens the Print Preview window with a toolbar-based interface.
Public method ShowRibbonPrintPreview Opens the Print Preview window with a Ribbon-based interface.
Public method ShowUnboundExpressionEditor Invokes the Expression Editor that enables editing a specified unbound field's expression.
Public method SuspendLayout Temporarily suspends the layout logic for the control. (Inherited from System.Windows.Forms.Control)
Public method ToString Returns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component)
Public method Update Causes the control to redraw the invalidated regions within its client area. (Inherited from System.Windows.Forms.Control)
Public method ValidateEditor Validates the active editor.
Public method XtraFindFieldsItem For internal use.
Top

Expanded Public Events

Show: Inherited
  Name Description
Public event AsyncOperationCompleted Occurs after an asynchronous operation has been completed.
Public event AsyncOperationStarting Occurs before an asynchronous operation is started.
Public event AutoSizeChanged This event is not relevant for this class. (Inherited from System.Windows.Forms.Control)
Public event BackColorChanged Occurs when the value of the System.Windows.Forms.Control.BackColor property changes. (Inherited from System.Windows.Forms.Control)
Public event BackgroundImageChanged Occurs when the value of the System.Windows.Forms.Control.BackgroundImage property changes. (Inherited from System.Windows.Forms.Control)
Public event BackgroundImageLayoutChanged Occurs when the System.Windows.Forms.Control.BackgroundImageLayout property changes. (Inherited from System.Windows.Forms.Control)
Public event BeforeLoadLayout Occurs before a layout is restored from storage (a stream, xml file or the system registry).
Public event BeginRefresh Occurs before the control's data recalculation starts.
Public event BindingContextChanged Occurs when the value of the System.Windows.Forms.BindingContext property changes. (Inherited from System.Windows.Forms.Control)
Public event CausesValidationChanged Occurs when the value of the System.Windows.Forms.Control.CausesValidation property changes. (Inherited from System.Windows.Forms.Control)
Public event CellClick Occurs when a cell is clicked.
Public event CellDoubleClick Occurs when a cell is double-clicked.
Public event CellSelectionChanged Occurs when the cell selection is modified.
Public event ChangeUICues Occurs when the focus or keyboard user interface (UI) cues change. (Inherited from System.Windows.Forms.Control)
Public event Click Occurs when the control is clicked. (Inherited from System.Windows.Forms.Control)
Public event ClientSizeChanged Occurs when the value of the System.Windows.Forms.Control.ClientSize property changes. (Inherited from System.Windows.Forms.Control)
Public event ContextMenuChanged Occurs when the value of the System.Windows.Forms.Control.ContextMenu property changes. (Inherited from System.Windows.Forms.Control)
Public event ContextMenuStripChanged Occurs when the value of the System.Windows.Forms.Control.ContextMenuStrip property changes. (Inherited from System.Windows.Forms.Control)
Public event ControlAdded Occurs when a new control is added to the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
Public event ControlRemoved Occurs when a control is removed from the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
Public event CursorChanged Occurs when the value of the System.Windows.Forms.Control.Cursor property changes. (Inherited from System.Windows.Forms.Control)
Public event CustomAppearance Allows the appearances of cells to be dynamically customized when the control is displayed on screen and in the print output.
Public event CustomCellDisplayText Enables custom display text to be provided for the cells displayed within the Data Area.
Public event CustomCellEdit Allows you to assign editors for particular cells.
Public event 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.
Public event CustomCellValue Allows you to replace cell values with custom ones.
Public event CustomChartDataSourceData Occurs when a PivotGridControl prepares data to be displayed in a ChartControl.
Public event CustomChartDataSourceRows Allows you to customize pivot grid data before passing it to a chart control.
Public event CustomColumnWidth Enables the column width to be customized.
Public event CustomCustomizationFormSort Allows you to change fields and folders order in the Customization Form.
Public event CustomDrawCell Enables data cells to be painted manually.
Public event CustomDrawEmptyArea Enables a Pivot Grid Control's background to be custom painted.
Public event CustomDrawFieldHeader Enables field headers to be painted manually.
Public event CustomDrawFieldHeaderArea Enables header areas to be painted manually.
Public event CustomDrawFieldValue Enables column and row headers to be painted manually.
Public event CustomEditValue Enables you to change cell values.
Public event 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.
Public event 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.
Public event 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.
Public event CustomFieldSort Provides the capability to sort data using custom rules.
Public event CustomFieldValueCells Allows you to customize field value cells.
Public event CustomFilterPopupItems Allows you to customize the filter drop-down list items.
Public event CustomGroupInterval Allows you to custom group values of column and row fields.
Public event CustomRowHeight Enables the rows height to be customized.
Public event CustomServerModeSort In OLAP and server mode, provides the capability to sort data using custom rules.
Public event CustomSummary Enables summary values to be calculated manually.
Public event CustomUnboundFieldData Enables providing data to unbound fields.
Public event DataSourceChanged Fires when the Pivot Grid Control's data source changes.
Public event Disposed Occurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component)
Public event DockChanged Occurs when the value of the System.Windows.Forms.Control.Dock property changes. (Inherited from System.Windows.Forms.Control)
Public event DoubleClick Occurs when the control is double-clicked. (Inherited from System.Windows.Forms.Control)
Public event DpiChangedAfterParent (Inherited from System.Windows.Forms.Control)
Public event DpiChangedBeforeParent (Inherited from System.Windows.Forms.Control)
Public event DragDrop Occurs when a drag-and-drop operation is completed. (Inherited from System.Windows.Forms.Control)
Public event DragEnter Occurs when an object is dragged into the control's bounds. (Inherited from System.Windows.Forms.Control)
Public event DragLeave Occurs when an object is dragged out of the control's bounds. (Inherited from System.Windows.Forms.Control)
Public event DragOver Occurs when an object is dragged over the control's bounds. (Inherited from System.Windows.Forms.Control)
Public event EditValueChanged Fires after a cell value has been changed, allowing you to save changes.
Public event EnabledChanged Occurs when the System.Windows.Forms.Control.Enabled property value has changed. (Inherited from System.Windows.Forms.Control)
Public event EndRefresh Occurs after the control's data recalculation has been completed.
Public event Enter Occurs when the control is entered. (Inherited from System.Windows.Forms.Control)
Public event ExportFinished Occurs after the PivotGrid's export has been completed.
Public event ExportStarted Occurs after the PivotGrid's export has been started.
Public event FieldAreaChanged Occurs after a field location or visibility has been changed.
Public event FieldAreaChanging Enables you to control whether the dragged field header can be dropped at the area it's currently located over.
Public event FieldAreaIndexChanged Occurs after a field has been moved.
Public event FieldExpandedInFieldGroupChanged Fires when the expansion status of fields combined into a field group is changed.
Public event FieldFilterChanged Occurs after the filter criteria have been changed for a specific field.
Public event FieldFilterChanging Allows you to customize the filter that is being applied or cancel filtering.
Public event FieldPropertyChanged Occurs after a field's property has been changed.
Public event FieldTooltipShowing Occurs before a tooltip is invoked.
Public event FieldUnboundExpressionChanged Fires after the DevExpress.XtraPivotGrid.PivotGridFieldBase.UnboundExpression property's value has been changed.
Public event FieldValueCollapsed Fires after a field value has been collapsed.
Public event FieldValueCollapsing Enables you to control whether field values can be collapsed.
Public event FieldValueDisplayText Enables the display text of individual column and row headers and filter dropdown items to be customized.
Public event FieldValueExpanded Fires after a field value has been expanded.
Public event FieldValueExpanding Enables you to control whether field values can be expanded.
Public event FieldValueImageIndex Enables images to be shown within column and row headers.
Public event 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.
Public event FieldVisibleChanged Occurs after a field has been shown or hidden.
Public event FieldWidthChanged Provides a notification that the field's width has been changed.
Public event FilterPopupExcelCustomizeTemplate
Public event FilterPopupExcelData
Public event FilterPopupExcelPrepareTemplate
Public event FilterPopupExcelQueryFilterCriteria
Public event FocusedCellChanged Fires in response to cell focus changing.
Public event FontChanged Occurs when the System.Windows.Forms.Control.Font property value changes. (Inherited from System.Windows.Forms.Control)
Public event ForeColorChanged Occurs when the System.Windows.Forms.Control.ForeColor property value changes. (Inherited from System.Windows.Forms.Control)
Public event GiveFeedback Occurs during a drag operation. (Inherited from System.Windows.Forms.Control)
Public event GotFocus Occurs when the control receives focus. (Inherited from System.Windows.Forms.Control)
Public event GridLayout Fires after the control's layout has been changed.
Public event GroupFilterChanged Occurs after a group filter condition has been changed.
Public event HandleCreated Occurs when a handle is created for the control. (Inherited from System.Windows.Forms.Control)
Public event HandleDestroyed Occurs when the control's handle is in the process of being destroyed. (Inherited from System.Windows.Forms.Control)
Public event HelpRequested Occurs when the user requests help for a control. (Inherited from System.Windows.Forms.Control)
Public event HiddenEditor Fires after an in-place editor has been closed.
Public event HideCustomizationForm Fires before the Customization Form is closed.
Public event ImeModeChanged Occurs when the System.Windows.Forms.Control.ImeMode property has changed. (Inherited from System.Windows.Forms.Control)
Public event Invalidated Occurs when a control's display requires redrawing. (Inherited from System.Windows.Forms.Control)
Public event InvalidValueException Enables you to provide a proper response to entering an invalid cell value.
Public event KeyDown Occurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
Public event KeyPress Occurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
Public event KeyUp Occurs when a key is released while the control has focus. (Inherited from System.Windows.Forms.Control)
Public event Layout Occurs when a control should reposition its child controls. (Inherited from System.Windows.Forms.Control)
Public event 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.
Public event Leave Occurs when the input focus leaves the control. (Inherited from System.Windows.Forms.Control)
Public event LeftTopCellChanged Occurs after the Pivot Grid Control is scrolled.
Public event LocationChanged Occurs when the System.Windows.Forms.Control.Location property value has changed. (Inherited from System.Windows.Forms.Control)
Public event LostFocus Occurs when the control loses focus. (Inherited from System.Windows.Forms.Control)
Public event MarginChanged Occurs when the control's margin changes. (Inherited from System.Windows.Forms.Control)
Public event MenuItemClick Allows custom responses to be provided for clicks on context menu items.
Public event MouseCaptureChanged Occurs when the control loses or gains mouse capture. (Inherited from System.Windows.Forms.Control)
Public event MouseClick Occurs when the control is clicked by the mouse. (Inherited from System.Windows.Forms.Control)
Public event MouseDoubleClick Occurs when the control is double clicked by the mouse. (Inherited from System.Windows.Forms.Control)
Public event MouseDown Occurs when the mouse pointer is over the control and a mouse button is pressed. (Inherited from System.Windows.Forms.Control)
Public event MouseEnter Occurs when the mouse pointer enters the control. (Inherited from System.Windows.Forms.Control)
Public event MouseHover Occurs when the mouse pointer rests on the control. (Inherited from System.Windows.Forms.Control)
Public event MouseLeave Occurs when the mouse pointer leaves the control. (Inherited from System.Windows.Forms.Control)
Public event MouseMove Occurs when the mouse pointer is moved over the control. (Inherited from System.Windows.Forms.Control)
Public event MouseUp Occurs when the mouse pointer is over the control and a mouse button is released. (Inherited from System.Windows.Forms.Control)
Public event MouseWheel Occurs when the mouse wheel moves while the control has focus. (Inherited from System.Windows.Forms.Control)
Public event Move Occurs when the control is moved. (Inherited from System.Windows.Forms.Control)
Public event OLAPException Obsolete. Raised when a query processing error occurs on a bound OLAP server, or when the connection to this server is lost.
Public event OLAPQueryTimeout Fires after a specific interval of time has elapsed when sending a query to an OLAP server.
Public event PaddingChanged Occurs when the control's padding changes. (Inherited from System.Windows.Forms.Control)
Public event Paint Occurs when the control is redrawn. (Inherited from System.Windows.Forms.Control)
Public event ParentChanged Occurs when the System.Windows.Forms.Control.Parent property value changes. (Inherited from System.Windows.Forms.Control)
Public event PopupMenuShowing Allows you to customize context menus.
Public event PrefilterCriteriaChanged Fires when the Prefilter's criteria are changed.
Public event PreviewKeyDown Occurs before the System.Windows.Forms.Control.KeyDown event when a key is pressed while focus is on this control. (Inherited from System.Windows.Forms.Control)
Public event QueryAccessibilityHelp Occurs when System.Windows.Forms.AccessibleObject is providing help to accessibility applications. (Inherited from System.Windows.Forms.Control)
Public event 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 System.Windows.Forms.Control)
Public event QueryException Occurs when a query processing error occurs on a bound server providing data for the PivotGridControl.
Public event RegionChanged Occurs when the value of the System.Windows.Forms.Control.Region property changes. (Inherited from System.Windows.Forms.Control)
Public event Resize Occurs when the control is resized. (Inherited from System.Windows.Forms.Control)
Public event RightToLeftChanged Occurs when the System.Windows.Forms.Control.RightToLeft property value changes. (Inherited from System.Windows.Forms.Control)
Public event ShowCustomizationForm Fires immediately after the Customization Form has been invoked.
Public event ShowFilterPopupExcel
Public event ShowingCustomizationForm Occurs before the Customization Form is displayed.
Public event ShowingEditor Allows you to cancel editor activation.
Public event ShownEditor Fires after a cell editor has been invoked.
Public event SizeChanged Occurs when the System.Windows.Forms.Control.Size property value changes. (Inherited from System.Windows.Forms.Control)
Public event StyleChanged Occurs when the control style changes. (Inherited from System.Windows.Forms.Control)
Public event SystemColorsChanged Occurs when the system colors change. (Inherited from System.Windows.Forms.Control)
Public event TabIndexChanged Occurs when the System.Windows.Forms.Control.TabIndex property value changes. (Inherited from System.Windows.Forms.Control)
Public event TabStopChanged Occurs when the System.Windows.Forms.Control.TabStop property value changes. (Inherited from System.Windows.Forms.Control)
Public event TextChanged Occurs when the System.Windows.Forms.Control.Text property value changes. (Inherited from System.Windows.Forms.Control)
Public event UserActionChanged Allows you to respond to end-user actions performed on the PivotGridControl.
Public event Validated Occurs when the control is finished validating. (Inherited from System.Windows.Forms.Control)
Public event Validating Occurs when the control is validating. (Inherited from System.Windows.Forms.Control)
Public event ValidatingEditor Enables you to manually validate cell values.
Public event VisibleChanged Occurs when the System.Windows.Forms.Control.Visible property value changes. (Inherited from System.Windows.Forms.Control)
Top

Expanded See Also

How would you rate this topic?​​​​​​​