[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Expand]Controls and Libraries
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.Data
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Expand]DevExpress.Xpf.Core.FilteringUI
  [Expand]DevExpress.Xpf.Core.Native
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Expand]DevExpress.Xpf.DataAccess.DataSourceWizard
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Dialogs
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DataPager
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Native
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gantt
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Expand]DevExpress.Xpf.Grid
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Collapse]DevExpress.Xpf.PivotGrid
    AllowHideFieldsType Enumeration
    AsyncCompletedHandler Delegate
   [Expand]AsyncOperationResult Class
   [Expand]CellElement Class
   [Expand]CellElementData Class
   [Expand]CellInfo Class
   [Expand]ColorScaleFormatCondition Class
    CopyCollapsedValuesMode Enumeration
    CopyMultiSelectionMode Enumeration
   [Expand]CustomPrefilterDisplayTextEventArgs Class
    CustomPrefilterDisplayTextEventHandler Delegate
   [Expand]CustomServerModeSortEventArgs Class
   [Expand]DataAreaElement Class
   [Expand]DataAreaElementData Class
   [Expand]DataBarFormatCondition Class
    DataFieldArea Enumeration
    DataHeadersDisplayMode Enumeration
    DataProcessingEngine Enumeration
   [Expand]DefaultMenuItemNames Class
   [Expand]EventArgsToCellInfoConverter Class
   [Expand]EventArgsToFieldValueInfoConverter Class
   [Expand]ExpressionConditionBase Class
    FieldAllowedAreas Enumeration
    FieldArea Enumeration
    FieldBestFitArea Enumeration
    FieldColumnTotalsLocation Enumeration
    FieldFilterType Enumeration
   [Expand]FieldFilterValues Class
    FieldGroupInterval Enumeration
    FieldListAllowedLayouts Enumeration
    FieldListArea Enumeration
   [Expand]FieldListControlBase Class
    FieldListLayout Enumeration
    FieldListOrientation Enumeration
    FieldListStyle Enumeration
    FieldOLAPFilterUsingWhereClause Enumeration
    FieldPropertyName Enumeration
    FieldRowTotalsLocation Enumeration
    FieldSortBySummaryOrder Enumeration
    FieldSortLocation Enumeration
    FieldSortMode Enumeration
    FieldSortOrder Enumeration
    FieldSummaryDisplayType Enumeration
    FieldSummaryType Enumeration
    FieldTopValueMode Enumeration
    FieldTopValueType Enumeration
    FieldTotalsVisibility Enumeration
    FieldUnboundColumnType Enumeration
    FieldUnboundExpressionMode Enumeration
   [Expand]FieldValueCell Class
   [Expand]FieldValueElement Class
   [Expand]FieldValueElementData Class
   [Expand]FieldValueInfo Class
    FieldValueType Enumeration
    FilterPopupMode Enumeration
   [Expand]FormatCondition Class
   [Expand]FormatConditionBase Class
   [Expand]FormatConditionCollection Class
   [Expand]FormatConditionCommandParameters Class
   [Expand]GroupChangedEventArgs Class
    GroupChangedEventHandler Delegate
    GroupChangeType Enumeration
    GroupFilterMode Enumeration
   [Expand]GroupFilterValue Class
   [Expand]GroupFilterValues Class
   [Expand]GroupFilterValuesCollection Class
   [Expand]IconSetFormatCondition Class
   [Expand]IndicatorFormatConditionBase Class
   [Expand]IThreadSafeField Interface
   [Expand]LightweightCellElement Class
   [Expand]LightweightFieldValueElement Class
    OlapDataProvider Enumeration
   [Expand]PivotBrushChangedEventArgs Class
    PivotBrushChangedEventHandler Delegate
    PivotBrushType Enumeration
   [Expand]PivotCellBaseEventArgs Class
   [Expand]PivotCellDisplayTextEventArgs Class
    PivotCellDisplayTextEventHandler Delegate
   [Expand]PivotCellEventArgs Class
    PivotCellEventHandler Delegate
   [Expand]PivotCellValueEventArgs Class
    PivotCellValueEventHandler Delegate
    PivotChartDataProvideMode Enumeration
    PivotChartDataProvidePriority Enumeration
   [Expand]PivotChartDataSourceRow Class
    PivotChartExportFieldValueMode Enumeration
    PivotChartFieldValuesProvideMode Enumeration
    PivotChartItemDataMember Enumeration
    PivotChartItemType Enumeration
   [Expand]PivotCustomCellAppearanceEventArgs Class
    PivotCustomCellAppearanceEventHandler Delegate
   [Expand]PivotCustomChartDataSourceDataEventArgs Class
    PivotCustomChartDataSourceDataEventHandler Delegate
   [Expand]PivotCustomChartDataSourceRowsEventArgs Class
    PivotCustomChartDataSourceRowsEventHandler Delegate
   [Expand]PivotCustomFieldDataEventArgs Class
    PivotCustomFieldDataEventHandler Delegate
   [Expand]PivotCustomFieldListSortEventArgs Class
   [Expand]PivotCustomFieldSortEventArgs Class
    PivotCustomFieldSortEventHandler Delegate
   [Expand]PivotCustomFieldValueCellsEventArgs Class
    PivotCustomFieldValueCellsEventHandler Delegate
   [Expand]PivotCustomFilterPopupItemsEventArgs Class
    PivotCustomFilterPopupItemsEventHandler Delegate
   [Expand]PivotCustomGroupIntervalEventArgs Class
    PivotCustomGroupIntervalEventHandler Delegate
   [Expand]PivotCustomSummaryEventArgs Class
    PivotCustomSummaryEventHandler Delegate
   [Expand]PivotCustomValueAppearanceEventArgs Class
    PivotCustomValueAppearanceEventHandler Delegate
    PivotDefaultMemberFields Enumeration
   [Expand]PivotDrillDownDataRow Class
   [Expand]PivotDrillDownDataSource Class
   [Expand]PivotExcelFieldListControl Class
   [Expand]PivotFieldAreaChangingEventArgs Class
    PivotFieldAreaChangingEventHandler Delegate
   [Expand]PivotFieldDisplayTextEventArgs Class
    PivotFieldDisplayTextEventHandler Delegate
   [Expand]PivotFieldEventArgs Class
    PivotFieldEventHandler Delegate
   [Expand]PivotFieldFilterChangingEventArgs Class
    PivotFieldFilterChangingEventHandler Delegate
   [Expand]PivotFieldListControl Class
   [Expand]PivotFieldPropertyChangedEventArgs Class
    PivotFieldPropertyChangedEventHandler Delegate
   [Expand]PivotFieldValueCancelEventArgs Class
    PivotFieldValueCancelEventHandler Delegate
   [Expand]PivotFieldValueEventArgs Class
    PivotFieldValueEventHandler Delegate
   [Expand]PivotFilterEditorEventArgs Class
    PivotFilterEditorEventHandler Delegate
   [Expand]PivotGridCellMenuInfo Class
   [Expand]PivotGridCommands Class
   [Collapse]PivotGridControl Class
     PivotGridControl Members
     PivotGridControl Constructor
    [Expand]PivotGridControl Properties
    [Expand]PivotGridControl Events
    [Collapse]PivotGridControl Methods
      AddFormatCondition Method
      AddMRUFilter Method
      BeginInit Method
      BeginUpdate Method
     [Expand]BestFit Method
      BestFitColumn Method
      BestFitRow Method
     [Expand]ChangeFieldExpandedAsync Method
     [Expand]ChangeFieldSortOrderAsync Method
     [Expand]ClearFieldSortingAsync Method
      ClearFormatConditionsFromAllMeasures Method
      ClearFormatConditionsFromIntersection Method
      ClearFormatConditionsFromMeasure Method
      ClearMRUFilter Method
      CollapseAll Method
     [Expand]CollapseAllAsync Method
      CollapseAllColumns Method
     [Expand]CollapseAllColumnsAsync Method
      CollapseAllRows Method
     [Expand]CollapseAllRowsAsync Method
      CollapseValue Method
     [Expand]CollapseValueAsync Method
      CopySelectionToClipboard Method
     [Expand]CreateDrillDownDataSource Method
     [Expand]CreateDrillDownDataSourceAsync Method
     [Expand]CreateOlapDrillDownDataSource Method
     [Expand]CreateOlapDrillDownDataSourceAsync Method
     [Expand]CreateServerModeDrillDownDataSource Method
     [Expand]CreateServerModeDrillDownDataSourceAsync Method
      CreateSummaryDataSource Method
      EndInit Method
      EndUpdate Method
     [Expand]EndUpdateAsync 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]ExportToDocx 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]ExportToXps Method
      GetCellInfo Method
     [Expand]GetCellValue Method
     [Expand]GetColumnIndex Method
      GetData Method
      GetFieldByArea Method
      GetFieldCountByArea Method
      GetFieldHeaderDragIndicatorSize Method
      GetFieldList Method
      GetFieldsByArea Method
     [Expand]GetFieldValue Method
      GetFieldValueOlapMember Method
     [Expand]GetFieldValueType Method
      GetFocusedCellInfo Method
      GetKpiBitmap Method
      GetOlapKpiList Method
      GetOlapKpiMeasures Method
      GetOlapKpiServerGraphic Method
      GetOlapKpiValue Method
      GetPivotGrid Method
     [Expand]GetRowIndex Method
      GetShowBorder Method
      GetShowHeaders Method
      HideAllTotals Method
      HideFieldList Method
      HidePrefilter Method
      HideUnboundExpressionEditor Method
     [Expand]IsFieldValueCollapsed Method
      LayoutChanged Method
      MakeCellVisible Method
      OnApplyTemplate Method
      Print Method
     [Expand]PrintDirect Method
      RefreshData Method
      ReloadData Method
     [Expand]ReloadDataAsync Method
      RemoveMRUFilter Method
      ResetPrefilter Method
      RestoreCollapsedStateFromFile Method
      RestoreCollapsedStateFromStream Method
     [Expand]RestoreCollapsedStateFromStreamAsync Method
      RestoreLayoutFromStream Method
      RestoreLayoutFromStreamAsync Method
      RestoreLayoutFromXml Method
      RestoreLayoutFromXmlAsync Method
      RestorePivotGridFromFile Method
      RestorePivotGridFromStream Method
     [Expand]RetrieveFields Method
     [Expand]RetrieveFieldsAsync Method
      SaveCollapsedStateToFile Method
      SaveCollapsedStateToStream Method
      SaveLayoutToStream Method
      SaveLayoutToXml Method
     [Expand]SavePivotGridToFile Method
     [Expand]SavePivotGridToStream Method
      ScrollTo Method
     [Expand]ScrollToPixels Method
     [Expand]SetDataSourceAsync Method
      SetFieldHeaderDragIndicatorSize Method
     [Expand]SetFieldSortingAsync Method
     [Expand]SetOlapConnectionStringAsync Method
      SetPivotGrid Method
     [Expand]SetSelectionByFieldValues Method
      SetShowBorder Method
      ShowAllTotals Method
     [Expand]ShowConditionalFormattingManager Method
      ShowFieldList Method
      ShowFormatConditionDialog Method
      ShowPrefilter Method
     [Expand]ShowPrintPreview Method
     [Expand]ShowPrintPreviewDialog Method
     [Expand]ShowRibbonPrintPreview Method
     [Expand]ShowRibbonPrintPreviewDialog Method
     [Expand]ShowUnboundExpressionEditor Method
   [Expand]PivotGridCsvExportOptions Class
   [Expand]PivotGridCustomTotal Class
   [Expand]PivotGridCustomTotalCollection Class
   [Expand]PivotGridField Class
   [Expand]PivotGridFieldCollection Class
   [Expand]PivotGridFieldValueMenuInfo Class
   [Expand]PivotGridFilterPopupMenuInfo Class
   [Expand]PivotGridGroup Class
   [Expand]PivotGridGroupCollection Class
   [Expand]PivotGridHeaderMenuInfo Class
   [Expand]PivotGridHeadersAreaMenuInfo Class
   [Expand]PivotGridMenuInfo Class
    PivotGridMenuType Enumeration
   [Expand]PivotGridPopupMenu Class
   [Expand]PivotGridXlsExportOptions Class
   [Expand]PivotGridXlsxExportOptions Class
   [Expand]PivotGroupEventArgs Class
    PivotGroupEventHandler Delegate
    PivotKpiGraphic Enumeration
    PivotKpiType Enumeration
   [Expand]PivotLayoutAllowEventArgs Class
    PivotLayoutAllowEventHandler Delegate
   [Expand]PivotLayoutUpgradeEventArgs Class
    PivotLayoutUpgradeEventHandler Delegate
   [Expand]PivotOlapExceptionEventArgs Class
    PivotOlapExceptionEventHandler Delegate
   [Expand]PivotOlapKpiMeasures Class
   [Expand]PivotOlapKpiValue Class
   [Expand]PivotOlapMember Class
   [Expand]PivotPropertyChangedEventArgs Class
    PivotPropertyChangedEventHandler Delegate
   [Expand]PivotQueryExceptionEventArgs Class
    PivotQueryExceptionEventHandler Delegate
   [Expand]PivotSerializationOptions Class
   [Expand]PivotSummaryDataRow Class
   [Expand]PivotSummaryDataSource Class
   [Expand]PivotUnboundExpressionEditorEventArgs Class
    PivotUnboundExpressionEditorEventHandler Delegate
   [Expand]PopupMenuShowingEventArgs Class
    PopupMenuShowingEventHandler Delegate
    ScrollingMode Enumeration
    SelectMode Enumeration
    ShowPrefilterPanelMode Enumeration
   [Expand]SortByCondition Class
   [Expand]SortByConditionCollection Class
    StoreLayoutMode Enumeration
   [Expand]TopBottomRuleFormatCondition Class
    UnboundExpressionMode Enumeration
    UseLightweightTemplates Enumeration
    UserAction Enumeration
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Common
  [Expand]DevExpress.Xpf.Scheduling.Editors
  [Expand]DevExpress.Xpf.Scheduling.iCalendar
  [Expand]DevExpress.Xpf.Scheduling.Reporting
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.Scheduling.VisualData
  [Expand]DevExpress.Xpf.SpellChecker
  [Expand]DevExpress.Xpf.Spreadsheet
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Printing
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

PivotGridControl Methods

The PivotGrid control.

Expanded Public Methods

Show: Inherited
  Name Description
Public method AddFormatCondition Add a condition to the FormatConditionCollection collection.
Public method AddHandler Adds a routed event handler for a specified routed event, adding the handler to the handler collection on the current element. Specify as true to have the provided handler be invoked for routed event that had already been marked as handled by another element along the event route. (Inherited from System.Windows.UIElement)
Public method AddMRUFilter Adds a new criterion to the MRU Filter List.
Public method AddToEventRoute Adds handlers to the specified System.Windows.EventRoute for the current System.Windows.UIElement event handler collection. (Inherited from System.Windows.UIElement)
Public method ApplyAnimationClock Applies an animation to a specified dependency property on this element. Any existing animations are stopped and replaced with the new animation. (Inherited from System.Windows.UIElement)
Public method ApplyTemplate Builds the current template's visual tree if necessary, and returns a value that indicates whether the visual tree was rebuilt by this call. (Inherited from System.Windows.FrameworkElement)
Public method Arrange Positions child elements and determines a size for a System.Windows.UIElement. Parent elements call this method from their System.Windows.UIElement.ArrangeCore implementation (or a WPF framework-level equivalent) to form a recursive layout update. This method constitutes the second pass of a layout update. (Inherited from System.Windows.UIElement)
Public method BeginAnimation Starts an animation for a specified animated property on this element. (Inherited from System.Windows.UIElement)
Public method BeginInit Starts the PivotGrid's runtime initialization.
Public method BeginStoryboard Begins the sequence of actions contained in the provided storyboard, with options specified for what should happen if the property is already animated. (Inherited from System.Windows.FrameworkElement)
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 the columns and rows which correspond to the fields contained within the specified area, to the minimum width and height required to completely display their contents.
Public method BestFitColumn Resizes the specified column to the minimum width required to completely display its contents.
Public method BestFitRow Resizes the specified row to the minimum height required to completely display its contents.
Public method BringIntoView Attempts to bring the provided region size of this element into view, within any scrollable regions it is contained within. (Inherited from System.Windows.FrameworkElement)
Public method CaptureMouse Attempts to force capture of the mouse to this element. (Inherited from System.Windows.UIElement)
Public method CaptureStylus Attempts to force capture of the stylus to this element. (Inherited from System.Windows.UIElement)
Public method CaptureTouch (Inherited from System.Windows.UIElement)
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. Allows you to specify custom actions to be performed after this operation is completed.
Public method CheckAccess Determines whether the calling thread has access to this System.Windows.Threading.DispatcherObject. (Inherited from System.Windows.Threading.DispatcherObject)
Public method ClearFieldSortingAsync Overloaded. Clears field sorting asynchronously in OLAP mode.
Public method ClearFormatConditionsFromAllMeasures Clear format conditions from all measures.
Public method ClearFormatConditionsFromIntersection Clear format conditions from the specified intersection of row and column fields.
Public method ClearFormatConditionsFromMeasure Clear format conditions from the specified measure.
Public method ClearMRUFilter Clears the MRU Filter List.
Public method ClearValue Clears the local value of a property. The property to be cleared is specified by a System.Windows.DependencyProperty identifier. (Inherited from System.Windows.DependencyObject)
Public method CoerceValue Coerces the value of the specified dependency property. This is accomplished by invoking any System.Windows.CoerceValueCallback function specified in property metadata for the dependency property as it exists on the calling System.Windows.DependencyObject. (Inherited from System.Windows.DependencyObject)
Public method CollapseAll Collapses all columns and rows in PivotGridControl.
Public method CollapseAllAsync Overloaded. Collapses all columns and rows in PivotGridControl 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 the specified column or row.
Public method CollapseValueAsync Overloaded. Collapses the specified column or row asynchronously.
Public method CopySelectionToClipboard Copies the selected cells to the clipboard.
Public method CreateDrillDownDataSource Overloaded. Returns a list of records used to calculate summary values displayed within the PivotGridControl.
Public method CreateDrillDownDataSourceAsync Overloaded. Returns a list of records used to calculate a summary value for the specified cell asynchronously.
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 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 EndInit Ends the runtime initialization.
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 PivotGridControl after the BeginUpdate method call, and starts an asynchronous update. Allows you to specify custom actions, to be performed after this operation is completed.
Public method Equals Determines whether a provided System.Windows.DependencyObject is equivalent to the current System.Windows.DependencyObject. (Inherited from System.Windows.DependencyObject)
Public methodStatic member Equals Determines whether the specified System.Object instances are considered equal. (Inherited from System.Object)
Public method ExpandAll Expands all columns and rows in PivotGridControl.
Public method ExpandAllAsync Overloaded. Expands all columns and rows in the PivotGridControl 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 the specified column or row.
Public method ExpandValueAsync Overloaded. Expands the specified column or row asynchronously.
Public method ExportToCsv Overloaded. Exports the pivot grid to the specified stream in CSV format, using the specified CSV-specific options.
Public method ExportToDocx Overloaded. Exports the Pivot Grid Control's data to the specified DOCX file.
Public method ExportToHtml Overloaded. Exports the pivot grid to the specified file path in HTML format.
Public method ExportToImage Overloaded. Exports the pivot grid to the specified file path in image format using the specified image-specific options.
Public method ExportToMht Overloaded. Exports the pivot grid to the specified stream in MHT format.
Public method ExportToPdf Overloaded. Exports the pivot grid to the specified stream in PDF format.
Public method ExportToRtf Overloaded. Exports the pivot grid to the specified stream in RTF format.
Public method ExportToText Overloaded. Exports the pivot grid to the specified stream in text format.
Public method ExportToXls Overloaded. Exports the pivot grid to the specified stream in XLS format.
Public method ExportToXlsx Overloaded. Exports the pivot grid to the specified file path in XLSX format.
Public method ExportToXps Overloaded. Exports the pivot grid to the specified file path in XPS format using the specified XPS-specific options.
Public method FindCommonVisualAncestor Returns the common ancestor of two visual objects. (Inherited from System.Windows.Media.Visual)
Public method FindName Finds an element that has the provided identifier name. (Inherited from System.Windows.FrameworkElement)
Public method FindResource Searches for a resource with the specified key, and throws an exception if the requested resource is not found. (Inherited from System.Windows.FrameworkElement)
Public method Focus Attempts to set focus to this element. (Inherited from System.Windows.UIElement)
Public method GetAnimationBaseValue Returns the base property value for the specified property on this element, disregarding any possible animated value from a running or stopped animation. (Inherited from System.Windows.UIElement)
Public method GetBindingExpression Returns the System.Windows.Data.BindingExpression that represents the binding on the specified property. (Inherited from System.Windows.FrameworkElement)
Public method GetCellInfo Returns an object that contains information on the specified cell.
Public method GetCellValue Overloaded. Returns a cell value calculated for the specified column and row field values.
Public method GetColumnIndex Overloaded. Returns the index of the specified column.
Public methodStatic member GetData For internal use only.
Public method GetFieldByArea Returns a field at the specified visual position in the specified area.
Public method GetFieldCountByArea Returns the number of visible fields located within the specified area.
Public methodStatic member GetFieldHeaderDragIndicatorSize Gets the value of the FieldHeaderDragIndicatorSize attached property for the specified System.Windows.DependencyObject.
Public method GetFieldList Returns the list of fields available in the bound data source.
Public method GetFieldsByArea Returns a list of fields displayed in the specified area.
Public method GetFieldValue Overloaded. Returns the specified field value.
Public method GetFieldValueOlapMember Returns an OLAP member for the specified field value.
Public method GetFieldValueType Overloaded. Gets the type of a specific column/row field value.
Public methodStatic member GetFlowDirection Gets the value of the System.Windows.FrameworkElement.FlowDirection attached property for the specified System.Windows.DependencyObject. (Inherited from System.Windows.FrameworkElement)
Public method GetFocusedCellInfo Returns an object that contains information on the currently focused cell.
Public method GetHashCode Gets a hash code for this System.Windows.DependencyObject. (Inherited from System.Windows.DependencyObject)
Public method GetKpiBitmap Returns an image that corresponds to a specific KPI value.
Public method GetLocalValueEnumerator Creates a specialized enumerator for determining which dependency properties have locally set values on this System.Windows.DependencyObject. (Inherited from System.Windows.DependencyObject)
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 methodStatic member GetPivotGrid Gets the value of the PivotGrid attached property for the specified System.Windows.DependencyObject.
Public method GetRowIndex Overloaded. Returns the index of the specified row.
Public methodStatic member GetShowBorder Gets the value of the ShowBorder attached property for a specified System.Windows.DependencyObject.
Public method GetShowHeaders Gets whether the specified field header area is visible.
Public method GetType Gets the System.Type of the current instance. (Inherited from System.Object)
Public method GetValue Returns the current effective value of a dependency property on this instance of a System.Windows.DependencyObject. (Inherited from System.Windows.DependencyObject)
Public method HideAllTotals Hides all Totals and grand totals.
Public method HideFieldList Hides the Customization Form.
Public method HidePrefilter Hides the Prefilter.
Public method HideUnboundExpressionEditor Hides the Expression Editor used to create expressions for Unbound Fields.
Public method InputHitTest Returns the input element within the current element that is at the specified coordinates, relative to the current element's origin. (Inherited from System.Windows.UIElement)
Public method InvalidateArrange Invalidates the arrange state (layout) for the element. After the invalidation, the element will have its layout updated, which will occur asynchronously unless subsequently forced by System.Windows.UIElement.UpdateLayout. (Inherited from System.Windows.UIElement)
Public method InvalidateMeasure Invalidates the measurement state (layout) for the element. (Inherited from System.Windows.UIElement)
Public method InvalidateProperty Re-evaluates the effective value for the specified dependency property (Inherited from System.Windows.DependencyObject)
Public method InvalidateVisual Invalidates the rendering of the element, and forces a complete new layout pass. System.Windows.UIElement.OnRender is called after the layout cycle is completed. (Inherited from System.Windows.UIElement)
Public method IsAncestorOf Determines whether the visual object is an ancestor of the descendant visual object. (Inherited from System.Windows.Media.Visual)
Public method IsDescendantOf Determines whether the visual object is a descendant of the ancestor visual object. (Inherited from System.Windows.Media.Visual)
Public method IsFieldValueCollapsed Overloaded. Indicates whether the specified Field Value is collapsed.
Public method LayoutChanged Updates the PivotGridControl.
Public method MakeCellVisible Scrolls the pivot grid to make the specified cell visible on screen.
Public method Measure Updates the System.Windows.UIElement.DesiredSize of a System.Windows.UIElement. Parent elements call this method from their own System.Windows.UIElement.MeasureCore implementations to form a recursive layout update. Calling this method constitutes the first pass (the "Measure" pass) of a layout update. (Inherited from System.Windows.UIElement)
Public method MoveFocus Moves the keyboard focus away from this element and to another element in a provided traversal direction. (Inherited from System.Windows.FrameworkElement)
Public method OnApplyTemplate Called after the template is completely generated and attached to the visual tree.
Public method PointFromScreen Converts a System.Windows.Point in screen coordinates into a System.Windows.Point that represents the current coordinate system of the System.Windows.Media.Visual. (Inherited from System.Windows.Media.Visual)
Public method PointToScreen Converts a System.Windows.Point that represents the current coordinate system of the System.Windows.Media.Visual into a System.Windows.Point in screen coordinates. (Inherited from System.Windows.Media.Visual)
Public method PredictFocus Determines the next element that would receive focus relative to this element for a provided focus movement direction, but does not actually move the focus. (Inherited from System.Windows.FrameworkElement)
Public method Print Invokes the Print dialog and prints the pivot grid.
Public method PrintDirect Overloaded.
Public method RaiseEvent Raises a specific routed event. The System.Windows.RoutedEvent to be raised is identified within the System.Windows.RoutedEventArgs instance that is provided (as the System.Windows.RoutedEventArgs.RoutedEvent property of that event data). (Inherited from System.Windows.UIElement)
Public method ReadLocalValue Returns the local value of a dependency property, if it exists. (Inherited from System.Windows.DependencyObject)
Public methodStatic member ReferenceEquals Determines whether the specified System.Object instances are the same instance. (Inherited from System.Object)
Public method RefreshData Recalculates summaries.
Public method RegisterName Provides an accessor that simplifies access to the System.Windows.NameScope registration method. (Inherited from System.Windows.FrameworkElement)
Public method ReleaseAllTouchCaptures (Inherited from System.Windows.UIElement)
Public method ReleaseMouseCapture Releases the mouse capture, if this element held the capture. (Inherited from System.Windows.UIElement)
Public method ReleaseStylusCapture Releases the stylus device capture, if this element held the capture. (Inherited from System.Windows.UIElement)
Public method ReleaseTouchCapture (Inherited from System.Windows.UIElement)
Public method ReloadData Reloads data from the PivotGridControl data source and recalculates summaries.
Public method ReloadDataAsync Overloaded. Reloads data from the control data source and recalculates summaries asynchronously.
Public method RemoveHandler Removes the specified routed event handler from this element. (Inherited from System.Windows.UIElement)
Public method RemoveMRUFilter Removes the specified criterion from the MRU Filter List.
Public method ResetPrefilter Clears the filter criteria specified by the Prefilter.
Public method RestoreCollapsedStateFromFile Restores the collapsed state of field values from the specified file.
Public method RestoreCollapsedStateFromStream Restores the collapsed state of field values from the specified stream.
Public method RestoreCollapsedStateFromStreamAsync Overloaded. Restores the collapsed state of field values from the specified stream asynchronously.
Public method RestoreLayoutFromStream Restores the pivot grid layout from the specified stream.
Public method RestoreLayoutFromStreamAsync Restores the pivot grid layout from the specified stream asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
Public method RestoreLayoutFromXml Restores the pivot grid's layout from the specified XML file.
Public method RestoreLayoutFromXmlAsync Restores the pivot grid's layout from the specified XML file asynchronously. Allows you to specify custom actions to be performed after this operation is completed.
Public method RestorePivotGridFromFile Restores the PivotGridControl's data and layout from the specified file.
Public method RestorePivotGridFromStream Restores the PivotGridControl's data and layout from the specified stream.
Public method RetrieveFields Overloaded. Creates PivotGridField objects for all fields in a data source, and moves them to the specified area, making them visible or hidden.
Public method RetrieveFieldsAsync Overloaded. Creates PivotGridField objects for all fields in a data source 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 SaveLayoutToStream Saves the PivotGridControl's layout to the specified stream.
Public method SaveLayoutToXml Saves the PivotGridControl's layout to a file in XML format.
Public method SavePivotGridToFile Overloaded. Saves the PivotGridControl's data and layout to the specified file, and allows data to be compressed.
Public method SavePivotGridToStream Overloaded. Saves the PivotGridControl's data and layout to the specified stream, and allows data to be compressed.
Public method ScrollTo Scrolls the pivot grid to make the specified cell visible at the top left.
Public method ScrollToPixels Overloaded. Scrolls the pivot grid to make the specified coordinates visible at the top left.
Public method SetBinding Attaches a binding to this element, based on the provided binding object. (Inherited from System.Windows.FrameworkElement)
Public method SetCurrentValue (Inherited from System.Windows.DependencyObject)
Public method SetDataSourceAsync Overloaded. Sets a data source for PivotGridControl and loads data asynchronously.
Public methodStatic member SetFieldHeaderDragIndicatorSize Sets the value of the FieldHeaderDragIndicatorSize attached property for the specified System.Windows.DependencyObject.
Public method SetFieldSortingAsync Overloaded. Sets the specified sort order for the specified field asynchronously.
Public methodStatic member SetFlowDirection Sets the value of the System.Windows.FrameworkElement.FlowDirection attached property for the provided element. (Inherited from System.Windows.FrameworkElement)
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 methodStatic member SetPivotGrid Sets the value of the PivotGrid attached property for the specified System.Windows.DependencyObject.
Public method SetResourceReference Searches for a resource with the specified name and sets up a resource reference to it for the specified property. (Inherited from System.Windows.FrameworkElement)
Public method SetSelectionByFieldValues Overloaded. Selects cells that reside within the specified column or row, identified by the specified Data Field.
Public methodStatic member SetShowBorder Sets the value of the ShowBorder attached property to a specified System.Windows.DependencyObject.
Public method SetValue Sets the local value of a dependency property, specified by its dependency property identifier. (Inherited from System.Windows.DependencyObject)
Public method ShouldSerializeCommandBindings Returns whether serialization processes should serialize the contents of the System.Windows.UIElement.CommandBindings property on instances of this class. (Inherited from System.Windows.UIElement)
Public method ShouldSerializeInputBindings Returns whether serialization processes should serialize the contents of the System.Windows.UIElement.InputBindings property on instances of this class. (Inherited from System.Windows.UIElement)
Public method ShouldSerializeResources Returns whether serialization processes should serialize the contents of the System.Windows.FrameworkElement.Resources property. (Inherited from System.Windows.FrameworkElement)
Public method ShouldSerializeStyle Returns whether serialization processes should serialize the contents of the System.Windows.FrameworkElement.Style property. (Inherited from System.Windows.FrameworkElement)
Public method ShouldSerializeTriggers Returns whether serialization processes should serialize the contents of the System.Windows.FrameworkElement.Triggers property. (Inherited from System.Windows.FrameworkElement)
Public method ShowAllTotals Shows all Totals and grand totals.
Public method ShowConditionalFormattingManager Overloaded. Invokes the Conditional Formatting Rules Manager with the predefined measure.
Public method ShowFieldList Invokes the Customization Form.
Public method ShowFormatConditionDialog Invokes the specified format condition dialog.
Public method ShowPrefilter Invokes the Prefilter.
Public method ShowPrintPreview Overloaded. Creates the print document from the PivotGridControl and displays the Print Preview of the document, using the specified owner and document name.
Public method ShowPrintPreviewDialog Overloaded. Creates the print document from the PivotGridControl and displays the modal Print Preview of the document, using the specified owner.
Public method ShowRibbonPrintPreview Overloaded.
Public method ShowRibbonPrintPreviewDialog Overloaded.
Public method ShowUnboundExpressionEditor Overloaded. Invokes the Expression Editor used to create expressions for Unbound Fields.
Public method ToString Returns the string representation of a System.Windows.Controls.Control object. (Inherited from System.Windows.Controls.Control)
Public method TransformToAncestor Returns a transform that can be used to transform coordinates from the System.Windows.Media.Visual to the specified System.Windows.Media.Visual ancestor of the visual object. (Inherited from System.Windows.Media.Visual)
Public method TransformToDescendant Returns a transform that can be used to transform coordinates from the System.Windows.Media.Visual to the specified visual object descendant. (Inherited from System.Windows.Media.Visual)
Public method TransformToVisual Returns a transform that can be used to transform coordinates from the System.Windows.Media.Visual to the specified visual object. (Inherited from System.Windows.Media.Visual)
Public method TranslatePoint Translates a point relative to this element to coordinates that are relative to the specified element. (Inherited from System.Windows.UIElement)
Public method TryFindResource Searches for a resource with the specified key, and returns that resource if found. (Inherited from System.Windows.FrameworkElement)
Public method UnregisterName Simplifies access to the System.Windows.NameScope de-registration method. (Inherited from System.Windows.FrameworkElement)
Public method UpdateDefaultStyle (Inherited from System.Windows.FrameworkElement)
Public method UpdateLayout Ensures that all visual child elements of this element are properly updated for layout. (Inherited from System.Windows.UIElement)
Public method VerifyAccess Enforces that the calling thread has access to this System.Windows.Threading.DispatcherObject. (Inherited from System.Windows.Threading.DispatcherObject)
Top

Expanded See Also

Is this topic helpful?​​​​​​​