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.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
   [Expand]FieldValueCell Class
    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]PivotGridAppearances Class
   [Expand]PivotGridAppearancesBase Class
   [Expand]PivotGridAppearancesPrint Class
   [Expand]PivotGridCells Class
   [Collapse]PivotGridControl Class
     PivotGridControl Members
     PivotGridControl Constructor
    [Expand]PivotGridControl Properties
    [Expand]PivotGridControl Events
    [Collapse]PivotGridControl Methods
      About Method
      BeginUpdate Method
     [Expand]BestFit Method
      BestFitColumnArea Method
      BestFitDataHeaders Method
      BestFitRowArea Method
      CalcHitInfo Method
      CanResizeField Method
     [Expand]ChangeFieldExpandedAsync Method
     [Expand]ChangeFieldSortOrderAsync Method
     [Expand]ClearFieldSortingAsync Method
     [Expand]CloseEditor Method
      CollapseAll Method
     [Expand]CollapseAllAsync Method
      CollapseAllColumns Method
     [Expand]CollapseAllColumnsAsync Method
      CollapseAllRows Method
     [Expand]CollapseAllRowsAsync Method
      CollapseValue Method
     [Expand]CollapseValueAsync Method
      ConvertFormatConditionToFormatRules Method
     [Expand]CreateDrillDownDataSource Method
     [Expand]CreateDrillDownDataSourceAsync Method
      CreateOLAPDataSourceClone Method
     [Expand]CreateOLAPDrillDownDataSource Method
     [Expand]CreateOLAPDrillDownDataSourceAsync Method
     [Expand]CreateServerModeDrillDownDataSource Method
     [Expand]CreateServerModeDrillDownDataSourceAsync Method
      CreateSummaryDataSource Method
      DestroyCustomization Method
      EndUpdate Method
     [Expand]EndUpdateAsync Method
      EnsureViewInfoIsCalculated Method
      ExpandAll Method
     [Expand]ExpandAllAsync Method
      ExpandAllColumns Method
     [Expand]ExpandAllColumnsAsync Method
      ExpandAllRows Method
     [Expand]ExpandAllRowsAsync Method
      ExpandValue Method
     [Expand]ExpandValueAsync Method
     [Expand]ExportToCsv Method
     [Expand]ExportToHtml Method
     [Expand]ExportToImage Method
     [Expand]ExportToMht Method
     [Expand]ExportToPdf Method
     [Expand]ExportToRtf Method
     [Expand]ExportToText Method
     [Expand]ExportToXls Method
     [Expand]ExportToXlsx Method
     [Expand]FieldsCustomization Method
      ForceInitialize Method
     [Expand]GetCellValue Method
     [Expand]GetColumnIndex Method
      GetFieldAt Method
      GetFieldByArea Method
      GetFieldList Method
      GetFieldsByArea Method
      GetFieldValue Method
      GetFieldValueOLAPMember Method
     [Expand]GetFieldValueType Method
      GetKPIBitmap Method
      GetOLAPKPIList Method
      GetOLAPKPIMeasures Method
      GetOLAPKPIServerGraphic Method
      GetOLAPKPIValue Method
     [Expand]GetRowIndex Method
      HideCustomization Method
      HideEditor Method
     [Expand]IsObjectCollapsed Method
      LayoutChanged Method
      LoadCollapsedStateFromFile Method
      LoadCollapsedStateFromStream Method
     [Expand]PostEditor Method
      Print Method
      RefreshData Method
     [Expand]RefreshDataAsync Method
     [Expand]RestoreLayoutFromRegistry Method
     [Expand]RestoreLayoutFromStream Method
     [Expand]RestoreLayoutFromXml Method
     [Expand]RetrieveFields Method
     [Expand]RetrieveFieldsAsync Method
      SaveCollapsedStateToFile Method
      SaveCollapsedStateToStream Method
     [Expand]SaveLayoutToRegistry Method
     [Expand]SaveLayoutToStream Method
     [Expand]SaveLayoutToXml Method
     [Expand]SavePivotGridToFile Method
     [Expand]SavePivotGridToStream Method
     [Expand]SetDataSourceAsync Method
     [Expand]SetFieldSortingAsync Method
     [Expand]SetOLAPConnectionStringAsync Method
      ShowCustomization Method
     [Expand]ShowEditor Method
      ShowPrintPreview Method
      ShowRibbonPrintPreview Method
      ShowUnboundExpressionEditor Method
      ValidateEditor Method
      XtraFindFieldsItem Method
   [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]PivotGridFieldOptionsEx 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]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]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

PivotGridControl Methods

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

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 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. Allows you to specify custom actions to be performed after this operation is completed.
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. Allows you to specify custom actions to be performed after this operation is completed.
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. Allows you to specify custom actions to be performed after this operation is completed.
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 which columns should 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 the columns and limit the number of records to 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 method Equals Determines whether the specified System.Object is equal to the current System.Object. (Inherited from System.Object)
Public methodStatic member Equals Determines whether the specified System.Object instances are considered equal. (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. Allows you to specify custom actions to be performed after this operation is completed.
Public method ExpandAllColumns Expands all columns.
Public method ExpandAllColumnsAsync Overloaded. Expands all columns asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
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 ExportToHtml Overloaded. Exports the control's data to the specified file in HTML format using the specified options.
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 and text encoding settings, and sends it to the specified file.
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 in the asynchronous mode 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. Allows you to specify custom actions to be performed after this operation is completed.
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 Pivot Grid Control's layout stored at the specified system registry path, using the specified settings.
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. (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, and allows the data to be compressed.
Public method SavePivotGridToStream Overloaded. Saves the Pivot Grid Control's data and full layout to the specified stream, and allows the data to be compressed.
Public method Scale Obsolete. Scales the entire control and any child controls. (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 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.
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 in-place editor for the cell at the specified position.
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 an Expression Editor that enables editing an expression for the specified unbound field.
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 See Also

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