PivotGridControl Members

The PivotGrid control.

Constructors

Name	Description
PivotGridControl()	Initializes a new instance of the PivotGridControl class with the default settings.

Fields

Name	Description
ActiveFilterInfoProperty static	Identifies the PivotGridControl.ActiveFilterInfo dependency property.
ActualHeightProperty static	Identifies the ActualHeight dependency property. Inherited from FrameworkElement.
ActualWidthProperty static	Identifies the ActualWidth dependency property. Inherited from FrameworkElement.
AllowConditionalFormattingManagerProperty static	Identifies the PivotGridControl.AllowConditionalFormattingManager dependency property.
AllowConditionalFormattingMenuProperty static	Identifies the PivotGridControl.AllowConditionalFormattingMenu dependency property.
AllowCrossGroupVariationProperty static	Identifies the PivotGridControl.AllowCrossGroupVariation dependency property.
AllowCustomizationFormProperty static	Identifies the PivotGridControl.AllowCustomizationForm dependency property.
AllowDragInCustomizationFormProperty static	Identifies the PivotGridControl.AllowDragInCustomizationForm dependency property.
AllowDragProperty static	Identifies the PivotGridControl.AllowDrag dependency property.
AllowDropProperty static	Identifies the AllowDrop dependency property. Inherited from UIElement.
AllowExpandOnDoubleClickProperty static	Identifies the PivotGridControl.AllowExpandOnDoubleClick dependency property.
AllowExpandProperty static	Identifies the PivotGridControl.AllowExpand dependency property.
AllowFilterEditorProperty static	Identifies the AllowFilterEditor dependency property.
AllowFilterInFieldListProperty static	Identifies the PivotGridControl.AllowFilterInFieldList dependency property.
AllowFilterProperty static	Identifies the PivotGridControl.AllowFilter dependency property.
AllowHideFieldsProperty static	Identifies the PivotGridControl.AllowHideFields dependency property.
AllowInfiniteGridSize static

Specifies whether the height and width of the pivot grid are allowed to be infinite.

By default, this option is disabled. In this instance, if the pivot grid’s height or width measures infinite, an exception is thrown.

To avoid the exception, enable the AllowInfiniteGridSize option. In this instance, the pivot grid immediately generates columns and rows for all records in the data source. Note that this may cause performance issues, if the number of records is too big.

Properties

Name	Description
ActiveFilterInfo	For internal use. This is a dependency property.
ActualHeight	Gets the rendered height of this element. Inherited from FrameworkElement.
ActualWidth	Gets the rendered width of this element. Inherited from FrameworkElement.
AllowConditionalFormattingManager	Gets or sets whether the Conditional Formatting Rules Manager is enabled at runtime. This is a dependency property.
AllowConditionalFormattingMenu	Gets or sets whether to enable the conditional formatting menu for the pivot grid.
AllowCrossGroupVariation	Gets or sets whether summary variations and running totals are calculated independently within individual groups, or throughout the Pivot Grid. This is a dependency property.
AllowCustomizationForm	Gets or sets whether end-users are allowed to invoke the Field List.
AllowDrag	Gets or sets whether an end-user is allowed to drag the field headers. This is a dependency property.
AllowDragInCustomizationForm	Gets or sets whether end-users are allowed to drag field headers between areas in the Field List.
AllowDrop	Gets or sets a value indicating whether this element can be used as the target of a drag-and-drop operation. This is a dependency property. Inherited from UIElement.
AllowExpand	Gets or sets whether expand buttons are displayed. This is a dependency property.
AllowExpandOnDoubleClick	Gets or sets whether field values are expanded/collapsed on a double click. This is a dependency property.
AllowFilter	Gets or sets whether filter buttons are displayed within field headers. This is a dependency property.
AllowFilterEditor	Gets or sets whether users can invoke the Filter Editor.
AllowFilterInFieldList	Gets or sets whether filtering can be applied to fields via the Field List. This is a dependency property.
AllowHideFields	Gets or sets a value that specifies when fields can be hidden by end-users.
AllowMRUFilterList	Gets or sets whether users are allowed to invoke the MRU Filter List. This is a dependency property.
AllowResizing	Gets or sets whether end-users are allowed to resize the PivotGridControl’s elements. This is a dependency property.
AllowSort	Gets or sets whether end-users can change the sort order of fields. This is a dependency property.
AllowSortBySummary	Gets or sets whether end-users can sort the row/column field values by other column/row summary values. This is a dependency property.
AllowSortInFieldList

Gets or sets whether the sort order of field values can be toggled via the Field List.

This is a dependency property.

| | AreAnyTouchesCaptured | Gets a value that indicates whether at least one touch is captured to this element. Inherited from UIElement. | | AreAnyTouchesCapturedWithin | Gets a value that indicates whether at least one touch is captured to this element or to any child elements in its visual tree. Inherited from UIElement. | | AreAnyTouchesDirectlyOver | Gets a value that indicates whether at least one touch is pressed over this element. Inherited from UIElement. | | AreAnyTouchesOver | Gets a value that indicates whether at least one touch is pressed over this element or any child elements in its visual tree. Inherited from UIElement. | | AutoExpandGroups | Gets or sets whether field values are expanded or collapsed by default. This is a dependency property. | | Background | Gets or sets a brush that describes the background of a control. Inherited from Control. | | BestFitArea | Gets or sets which interface elements are taken into account when calculating optimal width for columns. | | BestFitMaxRowCount | Gets or sets the number of rows taken into account when calculating the optimal width required for columns (or rows) to completely display their contents. | | BestFitMode | Gets or sets how the optimal width required for a column (or row) to completely display its contents is calculated. | | BindingGroup | Gets or sets the BindingGroup that is used for the element. Inherited from FrameworkElement. | | BitmapEffect | Gets or sets a bitmap effect that applies directly to the rendered content for this element. This is a dependency property. Inherited from UIElement. | | BitmapEffectInput | Gets or sets an input source for the bitmap effect that applies directly to the rendered content for this element. This is a dependency property. Inherited from UIElement. | | BorderBrush | Gets or sets a brush that describes the border background of a control. Inherited from Control. | | BorderThickness | Gets or sets the border thickness of a control. Inherited from Control. | | CacheMode | Gets or sets a cached representation of the UIElement. Inherited from UIElement. | | CanEnableFilter | | | CellBackground | Gets or sets the brush used to paint the background of data cells. This is a dependency property. | | CellForeground | Gets or sets the brush used to paint the foreground of data cells. This is a dependency property. | | CellMenuCustomizations | Allows you to customize the context menu, invoked when right-clicking cells, by adding new menu items or removing existing items. | | CellSelectedBackground | Gets or sets the brush used to paint the background of the selected data cell. This is a dependency property. | | CellSelectedForeground | Gets or sets the brush used to paint the foreground of the selected data cell. This is a dependency property. | | CellStyle | Gets or sets the style applied to data cells displayed within a Pivot Grid. | | CellTotalBackground | Gets or sets the brush used to paint the background of total and grand total cells. This is a dependency property. | | CellTotalForeground | Gets or sets the brush used to paint the foreground of total and grand total cells. This is a dependency property. | | CellTotalSelectedBackground | Gets or sets the brush used to paint the background of the selected total or grand total cell. This is a dependency property. | | CellTotalSelectedForeground | Gets or sets the brush used to paint the foreground of the selected total or grand total cell. This is a dependency property. | | ChartAutoTranspose | Gets or sets whether a bound chart control should be transposed if the number of series exceeds the number of argument values. This is a dependency property. | | ChartDataProvideMode | Gets or sets what data the pivot grid should pass to a bound chart control. This is a dependency property. | | ChartDataProvidePriority | Gets or sets whether the pivot grid should pass columns or rows to a bound chart control when it is impossible to find the lowest-level data. This is a dependency property. | | ChartDataSource | Gets a data source for a chart control. | | ChartFieldValuesProvideMode |

Gets or sets how field values are passed to the chart control. This is a dependency property.

| | ChartMaxPointCountInSeries |

Gets or sets the maximum allowed number of points in a series. This is a dependency property.

| | ChartMaxSeriesCount |

Gets or sets the maximum allowed number of series in the chart data source. This is a dependency property.

| | ChartProvideCellValuesAsType | Gets or sets the type to which cell values are converted before they are exported to the Chart Control. This is a dependency property. | | ChartProvideColumnCustomTotals | Gets or sets whether column custom totals should be passed to a chart control. This is a dependency property. | | ChartProvideColumnFieldValuesAsType | Gets or sets the type to which the column field values are converted before they are exported to the chart control. This is a dependency property. | | ChartProvideColumnGrandTotals | Gets or sets whether column grand totals are passed to a chart control. This is a dependency property. | | ChartProvideColumnTotals |

Gets or sets whether column totals are passed to a chart control. This is a dependency property.

| | ChartProvideDataByColumns | Gets or sets whether series in a chart control are created based on PivotGrid columns or rows. This is a dependency property. | | ChartProvideEmptyCells | Gets or sets whether empty cells should be processed by the Chart control. This is a dependency property. | | ChartProvideRowCustomTotals | Gets or sets whether row custom totals should be displayed in a chart control. This is a dependency property. | | ChartProvideRowFieldValuesAsType |

Gets or sets the type to which the row field values are converted before they are exported to the chart control. This is a dependency property.

| | ChartProvideRowGrandTotals |

Gets or sets whether row grand totals are passed to a chart control. This is a dependency property.

| | ChartProvideRowTotals |

Gets or sets whether row totals are passed to a chart control. This is a dependency property.

Gets or sets the delay between changing the cell focus or selection, and updating the bound Chart control. This is a dependency property.

| | ClearCache | | | Clip | Gets or sets the geometry used to define the outline of the contents of an element. This is a dependency property. Inherited from UIElement. | | ClipboardCopyCollapsedValuesMode | Gets or sets how to copy collapsed field values to the clipboard. This is a dependency property. | | ClipboardCopyMultiSelectionMode | Gets or sets how to copy cells to the clipboard when multiple cells are selected. This is a dependency property. | | ClipToBounds | Gets or sets a value indicating whether to clip the content of this element (or content coming from the child elements of this element) to fit into the size of the containing element. This is a dependency property. Inherited from UIElement. | | ColumnCount | Gets the number of columns in the PivotGridControl. | | ColumnFieldValuesAlignment | Gets or sets the vertical alignment of column field values. This is a dependency property. | | ColumnTotalsLocation | Gets or sets the column totals‘ location. This is a dependency property. | | CommandBindings | Gets a collection of CommandBinding objects associated with this element. A CommandBinding enables command handling for this element, and declares the linkage between a command, its events, and the handlers attached by this element. Inherited from UIElement. | | ConditionalFormattingManagerServiceTemplate | Gets or sets the template that defines the presentation of the conditional formatting manager. This is a dependency property. | | ConditionalFormattingResultForDesignTime | | | ContextMenu | Gets or sets the context menu element that should appear whenever the context menu is requested through user interface (UI) from within this element. Inherited from FrameworkElement. | | CopyToClipboardWithFieldValues | Gets or sets whether field values are copied to the clipboard when CTRL+C is pressed or the PivotGridControl.CopySelectionToClipboard method is called. | | CurrentProcessId | | | Cursor | Gets or sets the cursor that displays when the mouse pointer is over this element. Inherited from FrameworkElement. | | CustomUniqueValuesCommand | | | DataContext | Gets or sets the data context for an element when it participates in data binding. Inherited from FrameworkElement. | | DataFieldArea | Gets or sets the area in which the data field headers are displayed. | | DataFieldAreaIndex | Gets or sets the position of the data field headers. | | DataFieldCaption | Specifies the text displayed within the data header. | | DataFieldHeight | Gets or sets the height of a data field value. This is a dependency property. | | DataFieldUnboundExpressionMode |

Gets or sets whether unbound expressions for data fields are calculated based on the data source records, or summary values. This is a dependency property.

| | DataFieldWidth | Gets or sets the width of a data field value. This is a dependency property. | | DataHeadersDisplayMode | Specifies how the data fields are displayed if the Data Header area is too small to display all data fields, even truncated with ellipses. This is a dependency property. | | DataProcessingEngine | Gets or sets an engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid. This is a dependency property. | | DataSource | Gets or sets the PivotGridControl data source. | | DefaultDataProcessingEngine static | Gets or sets a default engine used to perform data processing in the pivot grid. | | DefaultStyleKey protected | Gets or sets the key to use to reference the style for this control, when theme styles are used or defined. Inherited from FrameworkElement. | | DeferredUpdates | Gets or sets whether dragging fields within the Field List (when it’s painted using the Excel2007 style) immediately updates the layout of fields in the PivotGrid control. This option controls the state of the ‘Defer Layout Update’ check box in the Field List, when the PivotGridControl.FieldListStyle option is set to Excel2007. | | DependencyObjectType | Gets the DependencyObjectType that wraps the CLR type of this instance. Inherited from DependencyObject. | | DesiredSize | Gets the size that this element computed during the measure pass of the layout process. Inherited from UIElement. | | DisableBatchUpdate | Specifies whether to update the PivotGridControl in a single batch during the data source synchronization. This is a compatibility and dependency property. | | Dispatcher | Gets the Dispatcher this DispatcherObject is associated with. Inherited from DispatcherObject. | | DrawFocusedCellRect | Gets or sets whether a focus rectangle is painted around the currently focused cell. | | DrillDownCustomColumns | Gets or sets a list of columns to be returned when you create a drill-down data source. | | DrillDownMaxRowCount | Gets or sets the maximum number of rows returned when calling the PivotGridControl.CreateDrillDownDataSource method. | | Effect | Gets or sets the bitmap effect to apply to the UIElement. This is a dependency property. Inherited from UIElement. | | ErrorPanelStyle | Gets or sets a style of the error panel. This is a dependency property. | | ErrorPanelText | Gets or sets a text from the error panel. This is a dependency property. | | ExcelFieldListState | Gets or sets the state of an Excel-style Field List. This is a dependency property. | | ExcelFieldListTemplate | Gets or sets the template used to display the Field List in the Excel style. | | ExpressionEditorContainer | This member supports the internal infrastructure and is not intended to be used directly from your code. | | FieldCellKpiTemplate | Gets or sets a template used to display data cells that contain KPI graphics. This is a dependency property. | | FieldCellKpiTemplateSelector | Gets or sets an object that chooses a template for cells that contain KPI graphics. This is a dependency property. | | FieldCellTemplate | Gets or sets a template used to display data cells. This is a dependency property. | | FieldCellTemplateSelector | Gets or sets an object that chooses a cell template based on custom logic. This is a dependency property. | | FieldFilterPopupMode | Specifies the type of the filter drop-down invoked by clicking a filter button in the field header. This is a dependency property. | | FieldGeneratorStyle | Gets or sets a style that contains settings common to all fields generated using different templates. This is a dependency property. | | FieldGeneratorTemplate | Gets or sets a template that describes pivot grid fields. This is a dependency property. | | FieldGeneratorTemplateSelector | Gets or sets the data template selector which chooses a template based on the field’s type. This is a dependency property. | | FieldHeaderContentStyle | Gets or sets a style applied to the field headers. This is a dependency property. | | FieldHeaderDragIndicatorTemplate | Gets or sets a template used to display the drag indicator. | | FieldHeaderListTemplate | Gets or sets a template used to display field headers in the Field List when they are arranged in a list. This is a dependency property. | | FieldHeaderListTemplateSelector | Gets or sets an object that chooses a template, used to display field headers in the Field List when they are arranged in a list. This is a dependency property. | | FieldHeaderTemplate | Gets or sets a template used to display field headers. This is a dependency property. | | FieldHeaderTemplateSelector | Gets or sets an object that chooses a field header template based on custom logic. This is a dependency property. | | FieldHeaderTreeViewTemplate | Gets or sets a template used to display field headers in the Field List when they are arranged in a tree. This is a dependency property. | | FieldHeaderTreeViewTemplateSelector | Gets or sets an object that chooses a template, used to display field headers in the Field List when they are arranged in a tree. This is a dependency property. | | FieldHeight | Gets or sets the row height for the current pivot grid. | | FieldListAllowedLayouts |

Gets or sets which layouts can be applied to the Field List when it is painted in Excel2007 style. This is a dependency property.

Gets or sets whether to show visible fields in the Field List. This is a dependency property.

| | FieldListLayout | Gets or sets the field list’s layout when it is painted in Excel2007 style. This is a dependency property. | | FieldListSplitterX | Gets or sets the position of the vertical splitter displayed in the Field List. This is a dependency property. | | FieldListSplitterY | Gets or sets the position of the horizontal splitter displayed in the Field List. This is a dependency property. | | FieldListState | Gets or sets the state of a simple Field List. This is a dependency property. | | FieldListStyle | Gets or sets a style that defines the visual appearance of the Field List. This is a dependency property. | | FieldListTemplate | Gets or sets the template used to display the Field List. | | Fields | Provides access to a pivot grid’s field collection. | | FieldsSource | Gets or sets the source from which the Pivot Grid generates fields. This is a dependency property. | | FieldValueMenuCustomizations | Allows you to customize the context menu, invoked when right-clicking the field values, by adding new menu items or removing existing items. | | FieldValueStyle | Gets the style settings used to paint field values. | | FieldValueTemplate | Gets or sets a template used to display field values. This is a dependency property. | | FieldValueTemplateSelector | Gets or sets an object that chooses a field value template based on custom logic. This is a dependency property. | | FieldWidth | Gets or sets the column width for the current pivot grid. | | FilterByVisibleFieldsOnly | Gets or sets whether to take into account filter conditions of visible filter fields only. | | FilterControl | | | FilterCriteria | Gets or sets a filter applied to the PivotGridControl. This is a dependency property. | | FilterEditorDialogServiceTemplate | Gets or sets the template that defines the presentation of the Filter Editor dialog. This is a dependency property. | | FilterEditorTemplate | Gets or sets a template that defines the presentation of the Filter Element within the Filter Editor dialog. This is a dependency property. | | FilteringContext | Gets an object which the FilterEditorControl uses to interact with a PivotGridControl. | | FilteringPanelStyle | Gets or sets the style applied to the Filter Panel. This is a dependency property. | | FilterPanelText | Gets the filter expression displayed within the legacy Filter Panel (Prefilter Panel). This is a dependency property. | | FilterString | Gets or sets the filter expression used to filter PIvotGridControl’s data. This is an attached property. | | FixedRowHeaders | Gets or sets whether to anchor row headers to the control edge when scrolling the pivot grid horizontally. This is a dependency property. | | FlowDirection | Gets or sets the direction that text and other user interface (UI) elements flow within any parent element that controls their layout. Inherited from FrameworkElement. | | Focusable | Gets or sets a value that indicates whether the element can receive focus. This is a dependency property. Inherited from UIElement. | | FocusedCell | Gets or sets the coordinates of the focused cell. | | FocusedCellBorderTemplate | Gets or sets a template used to display border of the focused cell. | | FocusVisualStyle | Gets or sets a property that enables customization of appearance, effects, or other style characteristics that will apply to this element when it captures keyboard focus. Inherited from FrameworkElement. | | FontFamily | Gets or sets the font family of the control. Inherited from Control. | | FontSize | Gets or sets the font size. Inherited from Control. | | FontStretch | Gets or sets the degree to which a font is condensed or expanded on the screen. Inherited from Control. | | FontStyle | Gets or sets the font style. Inherited from Control. | | FontWeight | Gets or sets the weight or thickness of the specified font. Inherited from Control. | | ForceCursor | Gets or sets a value that indicates whether this FrameworkElement should force the user interface (UI) to render the cursor as declared by the Cursor property. Inherited from FrameworkElement. | | Foreground | Gets or sets a brush that describes the foreground color. Inherited from Control. | | FormatConditionDialogServiceTemplate | Gets or sets the template that defines the presentation of the format condition dialog. This is a dependency property. | | FormatConditionGeneratorTemplate | Gets or sets a template that describes conditional formats. This is a dependency property. | | FormatConditionGeneratorTemplateSelector | Gets or sets the data template selector which chooses a template based on the conditional format type. This is a dependency property. | | FormatConditions | Gets the collection of style format rules for a pivot grid control. | | FormatConditionsSource | Gets or set a list of conditional formats applied to the PivotGrid. | | GridMenu | Gets the context menu currently being displayed within the PivotGridControl. | | GroupDataCaseSensitive | Gets or sets whether data is grouped case-sensitively. | | GroupFieldsInFieldList | Gets or sets whether hidden fields are grouped within the Field List. This is a dependency property. | | GroupFilterMode | Gets or sets the filtering mode of grouped fields. | | GroupGeneratorStyle | Gets or sets a style that contains settings common to all field groups generated using different templates. This is a dependency property. | | GroupGeneratorTemplate | Gets or sets a template that describes Pivot Grid field groups. This is a dependency property. | | GroupGeneratorTemplateSelector | Gets or sets the data template selector which chooses a template based on the group’s type. This is a dependency property. | | Groups | Gets the collection of field groups. | | GroupsSource | Gets or sets the source from which the Pivot Grid generates field groups. This is a dependency property. | | HasAnimatedProperties | Gets a value indicating whether this element has any animated properties. Inherited from UIElement. | | HasEffectiveKeyboardFocus protected | Gets a value that indicates whether the UIElement has focus. Inherited from UIElement. | | HeaderAreaMenuCustomizations | Allows you to customize the context menu, invoked when right-clicking the header area, by adding new menu items or removing existing items. | | HeaderMenuCustomizations | Allows you to customize the context menu, invoked when right-clicking the field headers, by adding new menu items or removing existing items. | | Height | Gets or sets the suggested height of the element. Inherited from FrameworkElement. | | HiddenFields | Gets the collection of hidden fields. | | HorizontalAlignment | Gets or sets the horizontal alignment characteristics applied to this element when it is composed within a parent element, such as a panel or items control. Inherited from FrameworkElement. | | HorizontalContentAlignment | Gets or sets the horizontal alignment of the control’s content. Inherited from Control. | | InheritanceBehavior protected | Gets or sets the scope limits for property value inheritance, resource key lookup, and RelativeSource FindAncestor lookup. Inherited from FrameworkElement. | | InputBindings | Gets the collection of input bindings associated with this element. Inherited from UIElement. | | InputScope | Gets or sets the context for input used by this FrameworkElement. Inherited from FrameworkElement. | | IsArrangeValid | Gets a value indicating whether the computed size and position of child elements in this element’s layout are valid. Inherited from UIElement. | | IsAsyncInProgress | Gets whether an asynchronous operation is in progress. | | IsCellMenuEnabled | Gets or sets whether a context menu is invoked when an end-user right-clicks a cell. This is a dependency property. | | IsEnabled | Gets or sets a value indicating whether this element is enabled in the user interface (UI). This is a dependency property. Inherited from UIElement. | | IsEnabledCore protected | Gets a value that becomes the return value of IsEnabled in derived classes. Inherited from UIElement. | | IsErrorPanelVisible | Gets or sets a value indicating whether the error panel is visible. This is a dependency property. | | IsFieldListMenuEnabled | Gets or sets whether the Field List Layout menu is available for end-users. | | IsFieldListVisible | Gets or sets whether the Field List is visible. This is a dependency property. | | IsFieldValueMenuEnabled | Gets or sets whether the field value context menu is shown when an end-user right-clicks a field value. This is a dependency property. | | IsFilterEditorVisible | Gets or sets whether or not the Filter Editor is invoked. This is a dependency property. | | IsFilterEnabled | Gets or sets whether the current filter is enabled. This is a dependency property. | | IsFilterPopupMenuEnabled | Gets or sets whether right-clicking a filter drop-down window invokes a context menu that allows you to invert the current check states of items. This is a dependency property. | | IsFilterPopupWaitIndicatorVisible | For internal use. | | IsFocused | Gets a value that determines whether this element has logical focus. This is a dependency property. Inherited from UIElement. | | IsHeaderAreaMenuEnabled | Gets or sets whether the header area context menu is shown when an end-user right-clicks a header area. This is a dependency property. | | IsHeaderMenuEnabled | Gets or sets whether the field header context menu is shown when an end-user right-clicks a field’s header. This is a dependency property. | | IsHitTestVisible | Gets or sets a value that declares whether this element can possibly be returned as a hit test result from some portion of its rendered content. This is a dependency property. Inherited from UIElement. | | IsInitialized | Gets a value that indicates whether this element has been initialized, either during processing by a XAML processor, or by explicitly having its EndInit() method called. Inherited from FrameworkElement. | | IsInputMethodEnabled | Gets a value indicating whether an input method system, such as an Input Method Editor (IME), is enabled for processing the input to this element. Inherited from UIElement. | | IsKeyboardFocused | Gets a value indicating whether this element has keyboard focus. This is a dependency property. Inherited from UIElement. | | IsKeyboardFocusWithin | Gets a value indicating whether keyboard focus is anywhere within the element or its visual tree child elements. This is a dependency property. Inherited from UIElement. | | IsLoaded | Gets a value that indicates whether this element has been loaded for presentation. Inherited from FrameworkElement. | | IsLoading | Gets whether the PivotGridControl is being initialized. | | IsMainWaitIndicatorVisible | For internal use. | | IsManipulationEnabled | Gets or sets a value that indicates whether manipulation events are enabled on this UIElement. Inherited from UIElement. | | IsMeasureValid | Gets a value indicating whether the current size returned by layout measure is valid. Inherited from UIElement. | | IsMouseCaptured | Gets a value indicating whether the mouse is captured to this element. This is a dependency property. Inherited from UIElement. | | IsMouseCaptureWithin | Gets a value that determines whether mouse capture is held by this element or by child elements in its visual tree. This is a dependency property. Inherited from UIElement. | | IsMouseDirectlyOver | Gets a value that indicates whether the position of the mouse pointer corresponds to hit test results, which take element compositing into account. This is a dependency property. Inherited from UIElement. | | IsMouseOver | Gets a value indicating whether the mouse pointer is located over this element (including child elements in the visual tree). This is a dependency property. Inherited from UIElement. | | IsSealed | Gets a value that indicates whether this instance is currently sealed (read-only). Inherited from DependencyObject. | | IsStylusCaptured | Gets a value indicating whether the stylus is captured by this element. This is a dependency property. Inherited from UIElement. | | IsStylusCaptureWithin | Gets a value that determines whether stylus capture is held by this element, or an element within the element bounds and its visual tree. This is a dependency property. Inherited from UIElement. | | IsStylusDirectlyOver | Gets a value that indicates whether the stylus position corresponds to hit test results, which take element compositing into account. This is a dependency property. Inherited from UIElement. | | IsStylusOver | Gets a value indicating whether the stylus cursor is located over this element (including visual child elements). This is a dependency property. Inherited from UIElement. | | IsTabStop | Gets or sets a value that indicates whether a control is included in tab navigation. Inherited from Control. | | IsUpdateLocked | Gets whether the PivotGridControl has been locked for updating. | | IsVisible | Gets a value indicating whether this element is visible in the user interface (UI). This is a dependency property. Inherited from UIElement. | | Language | Gets or sets localization/globalization language information that applies to an element. Inherited from FrameworkElement. | | LayoutTransform | Gets or sets a graphics transformation that should apply to this element when layout is performed. Inherited from FrameworkElement. | | LeftTopCoord | Gets the column and row indexes of the data cell displayed in the top left corner. | | LeftTopPixelCoord | Gets the coordinates of the data area displayed in the top left corner. | | LoadingPanelDelay | Gets or sets the delay before displaying the loading panel in asynchronous mode. This is a dependency property. | | Margin | Gets or sets the outer margin of an element. Inherited from FrameworkElement. | | MaxHeight | Gets or sets the maximum height constraint of the element. Inherited from FrameworkElement. | | MaxWidth | Gets or sets the maximum width constraint of the element. Inherited from FrameworkElement. | | MergeColumnFieldValues | Gets or sets whether to merge the neighboring column headers if they contain the same field value. This is a dependency property. | | MergeRowFieldValues | Gets or sets whether to merge the neighboring row headers if they contain the same field value. This is a dependency property. | | MinHeight | Gets or sets the minimum height constraint of the element. Inherited from FrameworkElement. | | MinWidth | Gets or sets the minimum width constraint of the element. Inherited from FrameworkElement. | | MRUFilterList | Gets a collection of the most recently used filters. | | MRUFilterListCount | Gets or sets the maximum number of the most recently used (MRU) filter conditions the PivotGridControl stores. This is a dependency property. | | MRUFilters | Gets the collection of the most recently used filters. | | MultiSelection | Gets the selected cells. | | Name | Gets or sets the identifying name of the element. The name provides a reference so that code-behind, such as event handler code, can refer to a markup element after it is constructed during processing by a XAML processor. Inherited from FrameworkElement. | | OlapAllowDuplicatedMeasures | | | OlapConnectionString | Gets or sets a connection string to a cube in an MS Analysis Services database. | | OlapDataProvider | Gets or sets which data provider should be used to bind to an OLAP cube. This is a dependency property. | | OlapDefaultMemberFields | Gets or sets for which filter fields the pivot grid processes only data related to their default members. This is a dependency property. | | OlapFilterByUniqueName | Gets or sets whether PivotGridControl should take into account OLAP member values or unique names when filtering data in the OLAP mode. This is a dependency property. | | OlapModificationCheckInterval | Gets or sets the time interval to check for data modification. | | OlapServerDefinedDrillDownColumns | Gets or sets whether the list of columns is defined by the server in the OLAP mode. | | OlapShowColumnsWithNoData | Gets or sets whether to show items with no data on columns. | | OlapShowRowsWithNoData | Gets or sets whether to show items with no data on rows.’ | | OlapSortUsingDiscoverXmlMetadata | Gets or sets whether the PivotGrid uses the OrderBy attribute obtained from the OLAP server to sort data. | | Opacity | Gets or sets the opacity factor applied to the entire UIElement when it is rendered in the user interface (UI). This is a dependency property. Inherited from UIElement. | | OpacityMask | Gets or sets an opacity mask, as a Brush implementation that is applied to any alpha-channel masking for the rendered content of this element. This is a dependency property. Inherited from UIElement. | | OptimizeSummaryTypeCalculation | Gets or sets whether to use decimal type conversion while calculating data in certain aggregation types. | | OverridesDefaultStyle | Gets or sets a value that indicates whether this element incorporates style properties from theme styles. Inherited from FrameworkElement. | | Padding | Gets or sets the padding inside a control. Inherited from Control. | | Parent | Gets the logical parent element of this element. Inherited from FrameworkElement. | | PersistId | Gets a value that uniquely identifies this element. Inherited from UIElement. | | PredefinedColorScaleFormats | Contains predefined color scale formats that are used to color cells proportional to their values. This is a dependency property. | | PredefinedDataBarFormats | Contains predefined data bar formats that are used to fill cells with bars whose lengths are proportional to the cell values. This is a dependency property. | | PredefinedFormats | Contains predefined formats that are used by conditional formatting rules. This is a dependency property. | | PredefinedIconSetFormats | Contains predefined icon set formats that are used to display a specific icon in a cell according to the range to which this cell value belongs. This is a dependency property. | | PrintCellBackground | Gets or sets the brush used to paint the background of data cells when the pivot grid is printed. This is a dependency property. | | PrintCellForeground | Gets or sets the brush used to paint the foreground of data cells when the pivot grid is printed. This is a dependency property. | | PrintCellTotalBackground | Gets or sets the brush used to paint the background of total and grand total cells when the pivot grid is printed. This is a dependency property. | | PrintCellTotalForeground | Gets or sets the brush used to paint the foreground of total and grand total cells when the pivot grid is printed. This is a dependency property. | | PrintColumnHeaders | Gets or sets whether to print headers of the column fields. This is a dependency property. | | PrintDataHeaders | Gets or sets whether to print headers of the data fields. This is a dependency property. | | PrintFieldCellKpiTemplate | Gets or sets a template used to print data cells that contain KPI graphics. This is a dependency property. | | PrintFieldCellKpiTemplateSelector | Gets or sets a template selector that chooses a print template for data cells that contain KPI graphics. This is a dependency property. | | PrintFieldCellTemplate | Gets or sets a template used to print data cells. This is a dependency property. | | PrintFieldCellTemplateSelector | Gets or sets a template selector that chooses a print template for data cells based on custom logic. This is a dependency property. | | PrintFieldHeaderTemplate | Gets or sets a template used to print field headers. This is a dependency property. | | PrintFieldHeaderTemplateSelector | Gets or sets a template selector that chooses a print template for field headers based on custom logic. This is a dependency property. | | PrintFieldValueTemplate | Gets or sets a template used to print field values. This is a dependency property. | | PrintFieldValueTemplateSelector | Gets or sets a template selector that chooses a print template for field values based on custom logic. This is a dependency property. | | PrintFilterHeaders | Gets or sets whether to print headers of the filter fields. This is a dependency property. | | PrintHeadersOnEveryPage | Gets or sets whether to print field headers on every page. This is a dependency property. | | PrintHorzLines |

Gets or sets whether the horizontal grid lines are printed. This is a dependency property.

| | PrintInsertPageBreaks | Gets or sets whether to insert page breaks at the end of every page. This is a dependency property. | | PrintLayoutMode | Gets or sets the layout mode of the print document. This is a dependency property. | | PrintRowHeaders | Gets or sets whether to print headers of the row fields. This is a dependency property. | | PrintUnusedFilterFields | Gets or sets whether to print headers of the unused filter fields. This is a dependency property. | | PrintValueBackground | Gets or sets the brush used to paint the background of field value cells when the pivot grid is printed. This is a dependency property. | | PrintValueForeground | Gets or sets the brush used to paint the foreground of field value cells when the pivot grid is printed. This is a dependency property. | | PrintValueTotalBackground | Gets or sets the brush used to paint the background of total and grand total headers when the pivot grid is printed. This is a dependency property. | | PrintValueTotalForeground | Gets or sets the brush used to paint the foreground of total and grand total headers when the pivot grid is printed. This is a dependency property. | | PrintVertLines |

Gets or sets whether the vertical grid lines are printed. This is a dependency property.

| | RenderSize | Gets (or sets) the final render size of this element. Inherited from UIElement. | | RenderTransform | Gets or sets transform information that affects the rendering position of this element. This is a dependency property. Inherited from UIElement. | | RenderTransformOrigin | Gets or sets the center point of any possible render transform declared by RenderTransform, relative to the bounds of the element. This is a dependency property. Inherited from UIElement. | | ResizingIndicatorTemplate | Gets or sets a template used to display the resizing indicator. | | Resources | Gets or sets the locally-defined resource dictionary. Inherited from FrameworkElement. | | RowCount | Gets the number of rows in the PivotGridControl. | | RowFieldValuesAlignment | Gets or sets the vertical alignment of row field values. This is a dependency property. | | RowTotalsHeightFactor | Gets or sets the factor used to define how much higher the total rows are, compared to the field value rows. This is a dependency property. | | RowTotalsLocation | Gets or sets the location of row totals. This is a dependency property. | | RowTreeHeight | Gets or sets the height of a row when row field values are arranged in a tree. This is a dependency property. | | RowTreeMinHeight | Gets or sets the minimum allowed height of a row when row field values are arranged in a tree. This is a dependency property. | | RowTreeMinWidth |

Gets or sets the minimum allowed width of the innermost row field values when they are arranged into a tree. This is a dependency property.

| | RowTreeOffset | Gets or sets the tree offset. This is a dependency property. | | RowTreeWidth | Gets or sets the width of the innermost row field values when they are arranged into a tree. This is a dependency property. | | RunConditionalFormattingEditorInDesignTime | | | ScrollingMode | Gets or sets the scrolling mode. This is a dependency property. | | ScrollViewerTemplate | For internal use. | | SelectedCellInfo | Gets information about the selected data cell. | | Selection | Gets or sets the coordinates of the selected cells. | | SelectMode | Gets or sets the selection mode. | | ShowColumnGrandTotalHeader | Gets or sets whether the Grand Total column header is visible when there are two or more data fields. This is a dependency property. | | ShowColumnGrandTotals | Gets or sets whether to display Row Grand Totals. | | ShowColumnHeaders | Gets or sets whether column headers are displayed. | | ShowColumnsBorder | For internal use. | | ShowColumnTotals | Gets or sets whether to display Column Totals. | | ShowCustomTotalsForSingleValues | Gets or sets whether custom totals are displayed for the field values which contain a single nesting field value. | | ShowDataHeaders | Gets or sets whether data headers are displayed. | | ShowDateTimeGroupIntervalItems | Gets or sets what combination of DateTime group intervals the popup menu displays. | | ShowFilterHeaders | Gets or sets whether to display the Filter Header Area. | | ShowFilterPanel | Gets whether the Filter Panel is displayed within the PivotGridControl. This is a dependency property. | | ShowFilterPanelMode | Gets or sets when the Filter Panel is displayed within the PivotGridControl. This is a dependency property. | | ShowGrandTotalsForSingleValues | Gets or sets whether grand totals are displayed when the control lists a single value of an outer column field or row field along its left or top edge. | | ShowLoadingPanel | Gets or sets whether the Loading Panel is displayed within the PivotGridControl when a time-consuming operation is performed. This is a dependency property. | | ShowOnlyAvailableFilterItems | Gets or sets whether filter items that cannot be displayed because of filtering applied to other fields should be hidden. This is a dependency property. | | ShowRowGrandTotalHeader | Gets or sets whether the Grand Total row header is visible when there are two or more data fields. This is a dependency property. | | ShowRowGrandTotals | Gets or sets whether to display row grand totals. | | ShowRowHeaders | Gets or sets whether row headers are displayed. | | ShowRowTotals | Gets or sets whether to display Row Totals. | | ShowTotalsForSingleValues | Gets or sets whether automatic totals are displayed for the field values which contain a single nesting field value. | | SnapsToDevicePixels | Gets or sets a value that determines whether rendering for this element should use device-specific pixel settings during rendering. This is a dependency property. Inherited from UIElement. | | SortBySummaryDefaultOrder | Gets or sets the sort order applied to a field when sorting by summaries is enabled for it. | | Style | Gets or sets the style used by this element when it is rendered. Inherited from FrameworkElement. | | StylusPlugIns protected | Gets a collection of all stylus plug-in (customization) objects associated with this element. Inherited from UIElement. | | SummaryDataSourceFieldNaming | Gets or sets the rule for naming columns that correspond to data fields, when creating a data source via the CreateSummaryDataSource methods. | | TabIndex | Gets or sets a value that determines the order in which elements receive focus when the user navigates through controls by using the TAB key. Inherited from Control. | | Tag | Gets or sets an arbitrary object value that can be used to store custom information about this element. Inherited from FrameworkElement. | | Template | Gets or sets a control template. Inherited from Control. | | TemplatedParent | Gets a reference to the template parent of this element. This property is not relevant if the element was not created through a template. Inherited from FrameworkElement. | | ToolTip | Gets or sets the tool-tip object that is displayed for this element in the user interface (UI). Inherited from FrameworkElement. | | TouchesCaptured | Gets all touch devices that are captured to this element. Inherited from UIElement. | | TouchesCapturedWithin | Gets all touch devices that are captured to this element or any child elements in its visual tree. Inherited from UIElement. | | TouchesDirectlyOver | Gets all touch devices that are over this element. Inherited from UIElement. | | TouchesOver | Gets all touch devices that are over this element or any child elements in its visual tree. Inherited from UIElement. | | Triggers | Gets the collection of triggers established directly on this element, or in child elements. Inherited from FrameworkElement. | | Uid | Gets or sets the unique identifier (for localization) for this element. This is a dependency property. Inherited from UIElement. | | UseAsyncMode | Gets or sets whether data-aware operations caused by end-user actions are performed asynchronously. This is a dependency property. | | UseDataBindingAPI | | | UseLayoutRounding | Gets or sets a value that indicates whether layout rounding should be applied to this element’s size and position during layout. Inherited from FrameworkElement. | | UseLegacyFilterEditor | Gets or sets whether to use the legacy filter editor. This is an attached property. | | UseLegacyFilterPanel | Gets or sets whether to use the legacy filter panel. | | UseLightweightTemplates | Gets or sets whether to enable the PivotGrid’s optimized mode. This is a dependency property. | | UserAction | Gets an end-user action on the PivotGridControl. | | ValueBackground | Gets or sets the brush used to paint the background of field value cells. This is a dependency property. | | ValueForeground | Gets or sets the brush used to paint the foreground of field value cells. This is a dependency property. | | ValueSelectedBackground | Gets or sets the brush used to paint the background of the selected field value cell. This is a dependency property. | | ValueSelectedForeground | Gets or sets the brush used to paint the foreground of the selected field value cell. This is a dependency property. | | ValueTotalBackground | Gets or sets the brush used to paint the background of total and grand total headers. This is a dependency property. | | ValueTotalForeground | Gets or sets the brush used to paint the foreground of total and grand total headers. This is a dependency property. | | ValueTotalSelectedBackground | Gets or sets the brush used to paint the background of the selected total or grand total header. This is a dependency property. | | ValueTotalSelectedForeground | Gets or sets the brush used to paint the foreground of the selected total or grand total header. This is a dependency property. | | VerticalAlignment | Gets or sets the vertical alignment characteristics applied to this element when it is composed within a parent element such as a panel or items control. Inherited from FrameworkElement. | | VerticalContentAlignment | Gets or sets the vertical alignment of the control’s content. Inherited from Control. | | Visibility | Gets or sets the user interface (UI) visibility of this element. This is a dependency property. Inherited from UIElement. | | VisualBitmapEffect protected | Gets or sets the BitmapEffect value for the Visual. Inherited from Visual. | | VisualBitmapEffectInput protected | Gets or sets the BitmapEffectInput value for the Visual. Inherited from Visual. | | VisualBitmapScalingMode protected | Gets or sets the BitmapScalingMode for the Visual. Inherited from Visual. | | VisualCacheMode protected | Gets or sets a cached representation of the Visual. Inherited from Visual. | | VisualChildrenCount protected | Gets the number of visual child elements within this element. Inherited from FrameworkElement. | | VisualClearTypeHint protected | Gets or sets the ClearTypeHint that determines how ClearType is rendered in the Visual. Inherited from Visual. | | VisualClip protected | Gets or sets the clip region of the Visual as a Geometry value. Inherited from Visual. | | VisualEdgeMode protected | Gets or sets the edge mode of the Visual as an EdgeMode value. Inherited from Visual. | | VisualEffect protected | Gets or sets the bitmap effect to apply to the Visual. Inherited from Visual. | | VisualOffset protected | Gets or sets the offset value of the visual object. Inherited from Visual. | | VisualOpacity protected | Gets or sets the opacity of the Visual. Inherited from Visual. | | VisualOpacityMask protected | Gets or sets the Brush value that represents the opacity mask of the Visual. Inherited from Visual. | | VisualParent protected | Gets the visual tree parent of the visual object. Inherited from Visual. | | VisualScrollableAreaClip protected | Gets or sets a clipped scrollable area for the Visual. Inherited from Visual. | | VisualTextHintingMode protected | Gets or sets the TextHintingMode of the Visual. Inherited from Visual. | | VisualTextRenderingMode protected | Gets or sets the TextRenderingMode of the Visual. Inherited from Visual. | | VisualTransform protected | Gets or sets the Transform value for the Visual. Inherited from Visual. | | VisualXSnappingGuidelines protected | Gets or sets the x-coordinate (vertical) guideline collection. Inherited from Visual. | | VisualYSnappingGuidelines protected | Gets or sets the y-coordinate (horizontal) guideline collection. Inherited from Visual. | | Width | Gets or sets the width of the element. Inherited from FrameworkElement. |

Methods

Name	Description
AddFormatCondition(FormatConditionBase)	Add a condition to the FormatConditionCollection collection.
AddHandler(RoutedEvent, Delegate, Boolean)	Adds a routed event handler for a specified routed event, adding the handler to the handler collection on the current element. Specify `handledEventsToo` 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 UIElement.
AddHandler(RoutedEvent, Delegate)	Adds a routed event handler for a specified routed event, adding the handler to the handler collection on the current element. Inherited from UIElement.
AddLogicalChild(Object) protected	Adds the provided object to the logical tree of this element. Inherited from FrameworkElement.
AddMRUFilter(CriteriaOperator)	Adds a new criterion to the MRU Filter List.
AddToEventRoute(EventRoute, RoutedEventArgs)	Adds handlers to the specified EventRoute for the current UIElement event handler collection. Inherited from UIElement.
AddVisualChild(Visual) protected	Defines the parent-child relationship between two visuals. Inherited from Visual.
ApplyAnimationClock(DependencyProperty, AnimationClock, HandoffBehavior)	Applies an animation to a specified dependency property on this element, with the ability to specify what happens if the property already has a running animation. Inherited from UIElement.
ApplyAnimationClock(DependencyProperty, AnimationClock)	Applies an animation to a specified dependency property on this element. Any existing animations are stopped and replaced with the new animation. Inherited from UIElement.
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 FrameworkElement.
Arrange(Rect)	Positions child elements and determines a size for a UIElement. Parent elements call this method from their ArrangeCore(Rect) 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 UIElement.
ArrangeCore(Rect) protected	Implements ArrangeCore(Rect) (defined as virtual in UIElement) and seals the implementation. Inherited from FrameworkElement.
ArrangeOverride(Size) protected	Called to arrange and size the content of a Control object. Inherited from Control.
BatchUpdate()	Updates the PivotGridControl‘s content in a single operation.
BeginAnimation(DependencyProperty, AnimationTimeline, HandoffBehavior)	Starts a specific animation for a specified animated property on this element, with the option of specifying what happens if the property already has a running animation. Inherited from UIElement.
BeginAnimation(DependencyProperty, AnimationTimeline)	Starts an animation for a specified animated property on this element. Inherited from UIElement.
BeginInit()	Starts the PivotGrid’s runtime initialization.
BeginStoryboard(Storyboard, HandoffBehavior, Boolean)	Begins the sequence of actions contained in the provided storyboard, with specified state for control of the animation after it is started. Inherited from FrameworkElement.
BeginStoryboard(Storyboard, HandoffBehavior)	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 FrameworkElement.
BeginStoryboard(Storyboard)	Begins the sequence of actions that are contained in the provided storyboard. Inherited from FrameworkElement.
BeginUpdate()	Locks the PivotGridControl object by preventing visual updates of the object and its elements until the EndUpdate method is called.
BestFit()	Resizes the columns and rows which correspond to the data and row fields, to the minimum width and height required to completely display their contents.
BestFit(FieldArea, Boolean, Boolean)	Resizes the columns and rows which correspond to the fields contained within the specified area, to the minimum width or height required to completely display their contents.
BestFit(FieldArea)	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.
BestFit(PivotGridField, Boolean, Boolean)	Resizes the columns and rows which correspond to the specified field, to the minimum width or height required to completely display their contents.
BestFit(PivotGridField)	Resizes the columns and rows which correspond to the specified fields, to the minimum width and height required to completely display their contents.
BestFit(Boolean, Boolean)	Resizes the columns and rows which correspond to the data fields and row fields, to the minimum width or height required to completely display their contents.
BestFitColumn(Int32)	Resizes the specified column to the minimum width required to completely display its contents.
BestFitRow(Int32)	Resizes the specified row to the minimum height required to completely display its contents.
BringIntoView()	Attempts to bring this element into view, within any scrollable regions it is contained within. Inherited from FrameworkElement.
BringIntoView(Rect)	Attempts to bring the provided region size of this element into view, within any scrollable regions it is contained within. Inherited from FrameworkElement.
CaptureMouse()	Attempts to force capture of the mouse to this element. Inherited from UIElement.
CaptureStylus()	Attempts to force capture of the stylus to this element. Inherited from UIElement.
CaptureTouch(TouchDevice)	Attempts to force capture of a touch to this element. Inherited from UIElement.
ChangeFieldExpandedAsync(PivotGridField, Boolean)	Expands or collapses all values of the specified field asynchronously.
ChangeFieldSortOrderAsync(PivotGridField)	Toggles the sort order of the specified field asynchronously.
CheckAccess()	Determines whether the calling thread has access to this DispatcherObject. Inherited from DispatcherObject.
ClearFieldSortingAsync(PivotGridField)	Clears field sorting asynchronously in OLAP mode.
ClearFormatConditionsFromAllMeasures()	Clear format conditions from all measures.
ClearFormatConditionsFromIntersection(PivotGridField, PivotGridField)	Clear format conditions from the specified intersection of row and column fields.
ClearFormatConditionsFromMeasure(PivotGridField)	Clear format conditions from the specified measure.
ClearMRUFilter()	Clears the MRU Filter List.
ClearValue(DependencyProperty)	Clears the local value of a property. The property to be cleared is specified by a DependencyProperty identifier. Inherited from DependencyObject.
ClearValue(DependencyPropertyKey)	Clears the local value of a read-only property. The property to be cleared is specified by a DependencyPropertyKey. Inherited from DependencyObject.
CoerceValue(DependencyProperty)	Coerces the value of the specified dependency property. This is accomplished by invoking any CoerceValueCallback function specified in property metadata for the dependency property as it exists on the calling DependencyObject. Inherited from DependencyObject.
CollapseAll()	Collapses all columns and rows in PivotGridControl.
CollapseAllAsync()	Collapses all columns and rows in PivotGridControl asynchronously.
CollapseAllColumns()	Collapses all columns.
CollapseAllColumnsAsync()	Collapses all columns asynchronously.
CollapseAllRows()	Collapses all rows.
CollapseAllRowsAsync()	Collapses all rows asynchronously.
CollapseValue(Boolean, Object[])	Collapses the specified column or row.
CollapseValueAsync(Boolean, Object[])	Collapses the specified column or row asynchronously.
CopySelectionToClipboard()	Copies the selected cells to the clipboard.
CreateDrillDownDataSource()	Returns a list of records used to calculate summary values displayed within the PivotGridControl.
CreateDrillDownDataSource(Int32, Int32, List<String>)	Returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns to be returned.
CreateDrillDownDataSource(Int32, Int32, Int32, List<String>)	Returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns to be returned.
CreateDrillDownDataSource(Int32, Int32, Int32)	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.
CreateDrillDownDataSource(Int32, Int32)	Returns a list of records used to calculate a summary value for the specified cell.
CreateDrillDownDataSourceAsync()	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32, List<String>)	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32, Int32, List<String>)	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32, Int32)	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateDrillDownDataSourceAsync(Int32, Int32)	Returns a list of records used to calculate a summary value for the specified cell asynchronously.
CreateOlapDrillDownDataSource(Int32, Int32, List<String>)	Obsolete. 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.
CreateOlapDrillDownDataSource(Int32, Int32, Int32, List<String>)	Obsolete. 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.
CreateServerModeDrillDownDataSource(Int32, Int32, List<String>)	Obsolete. 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.
CreateServerModeDrillDownDataSource(Int32, Int32, Int32, List<String>)	Obsolete. 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.
CreateSummaryDataSource()	Returns a summary data source.
EndInit()	Ends the runtime initialization.
EndUpdate()	Unlocks the PivotGridControl object after a call to the BeginUpdate method and causes an immediate visual update.
EndUpdateAsync()	Unlocks the PivotGridControl after the PivotGridControl.BeginUpdate method call, and starts an asynchronous update.
Equals(Object, Object) static	Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)	Determines whether a provided DependencyObject is equivalent to the current DependencyObject. Inherited from DependencyObject.
ExpandAll()	Expands all columns and rows in PivotGridControl.
ExpandAllAsync()	Expands all columns and rows in the PivotGridControl asynchronously.
ExpandAllColumns()	Expands all columns.
ExpandAllColumnsAsync()	Expands all columns asynchronously.
ExpandAllRows()	Expands all rows.
ExpandAllRowsAsync()	Expands all rows asynchronously.
ExpandValue(Boolean, Object[])	Expands the specified column or row.
ExpandValueAsync(Boolean, Object[])	Expands the specified column or row asynchronously.
ExportToCsv(Stream, CsvExportOptions)	Exports the pivot grid to the specified stream in CSV format, using the specified CSV-specific options.
ExportToCsv(Stream)	Exports the pivot grid to the specified stream in CSV format.
ExportToCsv(String, CsvExportOptions)	Exports the pivot grid to the specified file path in CSV format, using the specified CSV-specific options.
ExportToCsv(String)	Exports the pivot grid to the specified file path in CSV format.
ExportToDocx(Stream, DocxExportOptions)	Exports the control’s data to the specified stream in DOCX format using the specified options.
ExportToDocx(Stream)	Exports the control’s data to the specified stream in DOCX format using the specified options.
ExportToDocx(String, DocxExportOptions)	Exports the control’s data to the specified file in DOCX format using the specified options.
ExportToDocx(String)	Exports the Pivot Grid Control’s data to the specified DOCX file.
ExportToHtml(Stream, HtmlExportOptions)	Exports the pivot grid to the specified stream in HTML format, using the specified HTML-specific options.
ExportToHtml(Stream)	Exports the pivot grid to the specified stream in HTML format.
ExportToHtml(String, HtmlExportOptions)	Exports the pivot grid to the specified file path in HTML format using the specified HTML-specific options.
ExportToHtml(String)	Exports the pivot grid to the specified file path in HTML format.
ExportToImage(Stream, ImageExportOptions)	Exports the pivot grid to the specified stream in image format, using the specified image-specific options.
ExportToImage(Stream)	Exports the pivot grid to the specified stream in image format.
ExportToImage(String, ImageExportOptions)	Exports the pivot grid to the specified file path in image format using the specified image-specific options.
ExportToImage(String)	Exports the pivot grid to the specified file path in image format.
ExportToMht(Stream, MhtExportOptions)	Exports the pivot grid to the specified stream in MHT format using the specified MHT-specific options.
ExportToMht(Stream)	Exports the pivot grid to the specified stream in MHT format.
ExportToMht(String, MhtExportOptions)	Exports the pivot grid to the specified file path in MHT format, using the specified MHT-specific options.
ExportToMht(String)	Exports the pivot grid to the specified file path in MHT format.
ExportToPdf(Stream, PdfExportOptions)	Exports the pivot grid to the specified stream in PDF format, using the specified PDF-specific options.
ExportToPdf(Stream)	Exports the pivot grid to the specified stream in PDF format.
ExportToPdf(String, PdfExportOptions)	Exports the pivot grid to the specified file path in PDF format, using the specified PDF-specific options.
ExportToPdf(String)	Exports the pivot grid to the specified file path in PDF format.
ExportToRtf(Stream, RtfExportOptions)	Exports the pivot grid to the specified stream in RTF format, using the specified RTF-specific options.
ExportToRtf(Stream)	Exports the pivot grid to the specified stream in RTF format.
ExportToRtf(String, RtfExportOptions)	Exports the pivot grid to the specified file path in RTF format, using the specified RTF-specific options.
ExportToRtf(String)	Exports the pivot grid to the specified file path in RTF format.
ExportToText(Stream, TextExportOptions)	Exports the pivot grid to the specified stream in text format, using the specified text-specific options.
ExportToText(Stream)	Exports the pivot grid to the specified stream in text format.
ExportToText(String, TextExportOptions)	Exports the pivot grid to the specified file path in text format, using the specified text-specific options.
ExportToText(String)	Exports the pivot grid to the specified file path in text format.
ExportToXls(Stream, XlsExportOptions)	Exports the pivot grid to the specified stream in XLS format, using the specified XLS-specific options.
ExportToXls(Stream)	Exports the pivot grid to the specified stream in XLS format.
ExportToXls(String, XlsExportOptions)	Exports the pivot grid to the specified file path in XLS format using the specified XLS-specific options.
ExportToXls(String)	Exports the pivot grid to the specified file path in XLS format.
ExportToXlsx(Stream, XlsxExportOptions)	Exports the pivot grid to the specified stream in XLSX format, using the specified XLSX-specific options.
ExportToXlsx(Stream)	Exports the pivot grid to the specified stream in XLSX format.
ExportToXlsx(String, XlsxExportOptions)	Exports the pivot grid to the specified file path in XLSX format, using the specified XLSX-specific options.
ExportToXlsx(String)	Exports the pivot grid to the specified file path in XLSX format.
ExportToXps(Stream, XpsExportOptions)	Exports the pivot grid to the specified stream in XPS format, using the specified XPS-specific options.
ExportToXps(Stream)	Exports the pivot grid to the specified stream in XPS format.
ExportToXps(String, XpsExportOptions)	Exports the pivot grid to the specified file path in XPS format using the specified XPS-specific options.
ExportToXps(String)	Exports the pivot grid to the specified file path in XPS format.
FindCommonVisualAncestor(DependencyObject)	Returns the common ancestor of two visual objects. Inherited from Visual.
FindName(String)	Finds an element that has the provided identifier name. Inherited from FrameworkElement.
FindResource(Object)	Searches for a resource with the specified key, and throws an exception if the requested resource is not found. Inherited from FrameworkElement.
Focus()	Attempts to set focus to this element. Inherited from UIElement.
GetAnimationBaseValue(DependencyProperty)	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 UIElement.
GetBindingExpression(DependencyProperty)	Returns the BindingExpression that represents the binding on the specified property. Inherited from FrameworkElement.
GetCellInfo(Int32, Int32)	Returns an object that contains information on the specified cell.
GetCellValue(Int32, Int32)	Returns a cell value by the column and row indexes.
GetCellValue(Object[], Object[], PivotGridField)	Returns a cell value calculated for the specified column and row field values, against the specified data field.
GetCellValue(Object[], Object[])	Returns a cell value calculated for the specified column and row field values.
GetColumnIndex(IPivotGridField, Object[])	Returns the index of the specified column.
GetColumnIndex(Object[])	Returns the index of the specified column.
GetData(DependencyObject) static	For internal use only.
GetFieldByArea(FieldArea, Int32)	Returns a field at the specified visual position in the specified area.
GetFieldCountByArea(FieldArea)	Returns the number of visible fields located within the specified area.
GetFieldHeaderDragIndicatorSize(DependencyObject) static	Gets the value of the PivotGridControl.FieldHeaderDragIndicatorSize attached property for the specified DependencyObject.
GetFieldList()	Returns the list of fields available in the bound data source.
GetFieldsByArea(FieldArea)	Returns a list of fields displayed in the specified area.
GetFieldValue(PivotGridField, Int32)	Returns the specified field value.
GetFieldValue(Boolean, Int32, Int32)	Returns the specified field value.
GetFieldValueOlapMember(PivotGridField, Int32)	Returns an OLAP member for the specified field value.
GetFieldValueType(PivotGridField, Int32)	Gets the type of a specific column/row field value.
GetFieldValueType(Boolean, Int32)	Gets the type of a field value in the column or row area.
GetFlowDirection(DependencyObject) static	Gets the value of the FlowDirection attached property for the specified DependencyObject. Inherited from FrameworkElement.
GetFocusedCellInfo()	Returns an object that contains information on the currently focused cell.
GetHashCode()	Gets a hash code for this DependencyObject. Inherited from DependencyObject.
GetKpiBitmap(PivotKpiGraphic, Int32)	Returns an image that corresponds to a specific KPI value.
GetLayoutClip(Size) protected	Returns a geometry for a clipping mask. The mask applies if the layout system attempts to arrange an element that is larger than the available display space. Inherited from FrameworkElement.
GetLocalValueEnumerator()	Creates a specialized enumerator for determining which dependency properties have locally set values on this DependencyObject. Inherited from DependencyObject.
GetOlapKpiList()	Gets the list of key performance indicators (KPI) in a cube.
GetOlapKpiMeasures(String)	Returns the Measures dimension’s members used to calculate the value, goal, status and weight of the specified Key Performance Indicator (KPI).
GetOlapKpiServerGraphic(String, PivotKpiType)	Returns a graphic set defined on the server for the specified KPI’s trend and status.
GetOlapKpiValue(String)	Returns the specified KPI’s value.
GetPivotGrid(DependencyObject) static	Gets the value of the PivotGridControl.PivotGrid attached property for the specified DependencyObject.
GetRowIndex(PivotGridField, Object[])	Returns the index of the specified row.
GetRowIndex(Object[])	Returns the index of the specified row.
GetShowBorder(DependencyObject) static	Gets the value of the PivotGridControl.ShowBorder attached property for a specified DependencyObject.
GetShowHeaders(FieldArea)	Gets whether the specified field header area is visible.
GetTemplateChild(String) protected	Returns the named element in the visual tree of an instantiated ControlTemplate. Inherited from FrameworkElement.
GetType()	Gets the Type of the current instance. Inherited from Object.
GetUIParentCore() protected	Returns an alternative logical parent for this element if there is no visual parent. Inherited from FrameworkElement.
GetValue(DependencyProperty)	Returns the current effective value of a dependency property on this instance of a DependencyObject. Inherited from DependencyObject.
GetVisualChild(Int32) protected	Overrides GetVisualChild(Int32), and returns a child at the specified index from a collection of child elements. Inherited from FrameworkElement.
HideAllTotals()	Hides all totals and grand totals.
HideExpressionEditor()
HideFieldList()	Hides the Field List.
HideFilterEditor()	Hides the Filter Editor.
HideUnboundExpressionEditor()	Hides the Expression Editor used to create expressions for unbound fields.
HitTestCore(GeometryHitTestParameters) protected	Implements HitTestCore(GeometryHitTestParameters) to supply base element hit testing behavior (returning GeometryHitTestResult). Inherited from UIElement.
HitTestCore(PointHitTestParameters) protected	Implements HitTestCore(PointHitTestParameters) to supply base element hit testing behavior (returning HitTestResult). Inherited from UIElement.
InputHitTest(Point)	Returns the input element within the current element that is at the specified coordinates, relative to the current element’s origin. Inherited from UIElement.
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 UpdateLayout(). Inherited from UIElement.
InvalidateMeasure()	Invalidates the measurement state (layout) for the element. Inherited from UIElement.
InvalidateProperty(DependencyProperty)	Re-evaluates the effective value for the specified dependency property. Inherited from DependencyObject.
InvalidateVisual()	Invalidates the rendering of the element, and forces a complete new layout pass. OnRender(DrawingContext) is called after the layout cycle is completed. Inherited from UIElement.
IsAncestorOf(DependencyObject)	Determines whether the visual object is an ancestor of the descendant visual object. Inherited from Visual.
IsDescendantOf(DependencyObject)	Determines whether the visual object is a descendant of the ancestor visual object. Inherited from Visual.
IsFieldValueCollapsed(PivotGridField, Int32)	Indicates whether the specified field value (row or column) is collapsed.
IsFieldValueCollapsed(Boolean, Object[])	Indicates whether the specified field value is collapsed.
LayoutChanged()	Updates the PivotGridControl.
MakeCellVisible(Point)	Scrolls the pivot grid to make the specified cell visible on screen.
Measure(Size)	Updates the DesiredSize of a UIElement. Parent elements call this method from their own MeasureCore(Size) implementations to form a recursive layout update. Calling this method constitutes the first pass (the “Measure” pass) of a layout update. Inherited from UIElement.
MeasureCore(Size) protected	Implements basic measure-pass layout system behavior for FrameworkElement. Inherited from FrameworkElement.
MemberwiseClone() protected	Creates a shallow copy of the current Object. Inherited from Object.
MoveFocus(TraversalRequest)	Moves the keyboard focus away from this element and to another element in a provided traversal direction. Inherited from FrameworkElement.
OnAccessKey(AccessKeyEventArgs) protected	Provides class handling for when an access key that is meaningful for this element is invoked. Inherited from UIElement.
OnApplyTemplate()	Called after the template is completely generated and attached to the visual tree.
OnChildDesiredSizeChanged(UIElement) protected	Supports layout behavior when a child element is resized. Inherited from UIElement.
OnContextMenuClosing(ContextMenuEventArgs) protected	Invoked whenever an unhandled ContextMenuClosing routed event reaches this class in its route. Implement this method to add class handling for this event. Inherited from FrameworkElement.
OnContextMenuOpening(ContextMenuEventArgs) protected	Invoked whenever an unhandled ContextMenuOpening routed event reaches this class in its route. Implement this method to add class handling for this event. Inherited from FrameworkElement.
OnDpiChanged(DpiScale, DpiScale) protected	Called when the DPI at which this View is rendered changes. Inherited from Visual.
OnDragEnter(DragEventArgs) protected	Invoked when an unhandled DragEnter attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnDragLeave(DragEventArgs) protected	Invoked when an unhandled DragLeave attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnDragOver(DragEventArgs) protected	Invoked when an unhandled DragOver attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnDrop(DragEventArgs) protected	Invoked when an unhandled DragEnter attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnGiveFeedback(GiveFeedbackEventArgs) protected	Invoked when an unhandled GiveFeedback attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnGotKeyboardFocus(KeyboardFocusChangedEventArgs) protected	Invoked when an unhandled GotKeyboardFocus attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnGotMouseCapture(MouseEventArgs) protected	Invoked when an unhandled GotMouseCapture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnGotStylusCapture(StylusEventArgs) protected	Invoked when an unhandled GotStylusCapture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnGotTouchCapture(TouchEventArgs) protected	Provides class handling for the GotTouchCapture routed event that occurs when a touch is captured to this element. Inherited from UIElement.
OnIsKeyboardFocusedChanged(DependencyPropertyChangedEventArgs) protected	Invoked when an unhandled IsKeyboardFocusedChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsKeyboardFocusWithinChanged(DependencyPropertyChangedEventArgs) protected	Invoked just before the IsKeyboardFocusWithinChanged event is raised by this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsMouseCapturedChanged(DependencyPropertyChangedEventArgs) protected	Invoked when an unhandled IsMouseCapturedChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsMouseCaptureWithinChanged(DependencyPropertyChangedEventArgs) protected	Invoked when an unhandled IsMouseCaptureWithinChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsMouseDirectlyOverChanged(DependencyPropertyChangedEventArgs) protected	Invoked when an unhandled IsMouseDirectlyOverChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsStylusCapturedChanged(DependencyPropertyChangedEventArgs) protected	Invoked when an unhandled IsStylusCapturedChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsStylusCaptureWithinChanged(DependencyPropertyChangedEventArgs) protected	Invoked when an unhandled IsStylusCaptureWithinChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsStylusDirectlyOverChanged(DependencyPropertyChangedEventArgs) protected	Invoked when an unhandled IsStylusDirectlyOverChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnKeyDown(KeyEventArgs) protected	Invoked when an unhandled KeyDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnKeyUp(KeyEventArgs) protected	Invoked when an unhandled KeyUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnLostKeyboardFocus(KeyboardFocusChangedEventArgs) protected	Invoked when an unhandled LostKeyboardFocus attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnLostMouseCapture(MouseEventArgs) protected	Invoked when an unhandled LostMouseCapture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnLostStylusCapture(StylusEventArgs) protected	Invoked when an unhandled LostStylusCapture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnLostTouchCapture(TouchEventArgs) protected	Provides class handling for the LostTouchCapture routed event that occurs when this element loses a touch capture. Inherited from UIElement.
OnManipulationBoundaryFeedback(ManipulationBoundaryFeedbackEventArgs) protected	Called when the ManipulationBoundaryFeedback event occurs. Inherited from UIElement.
OnManipulationCompleted(ManipulationCompletedEventArgs) protected	Called when the ManipulationCompleted event occurs. Inherited from UIElement.
OnManipulationDelta(ManipulationDeltaEventArgs) protected	Called when the ManipulationDelta event occurs. Inherited from UIElement.
OnManipulationInertiaStarting(ManipulationInertiaStartingEventArgs) protected	Called when the ManipulationInertiaStarting event occurs. Inherited from UIElement.
OnManipulationStarted(ManipulationStartedEventArgs) protected	Called when the ManipulationStarted event occurs. Inherited from UIElement.
OnManipulationStarting(ManipulationStartingEventArgs) protected	Provides class handling for the ManipulationStarting routed event that occurs when the manipulation processor is first created. Inherited from UIElement.
OnMouseDoubleClick(MouseButtonEventArgs) protected	Raises the MouseDoubleClick routed event. Inherited from Control.
OnMouseDown(MouseButtonEventArgs) protected	Invoked when an unhandled MouseDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseEnter(MouseEventArgs) protected	Invoked when an unhandled MouseEnter attached event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseLeave(MouseEventArgs) protected	Invoked when an unhandled MouseLeave attached event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseLeftButtonUp(MouseButtonEventArgs) protected	Invoked when an unhandled MouseLeftButtonUp routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseMove(MouseEventArgs) protected	Invoked when an unhandled MouseMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseRightButtonDown(MouseButtonEventArgs) protected	Invoked when an unhandled MouseRightButtonDown routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseRightButtonUp(MouseButtonEventArgs) protected	Invoked when an unhandled MouseRightButtonUp routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseUp(MouseButtonEventArgs) protected	Invoked when an unhandled MouseUp routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseWheel(MouseWheelEventArgs) protected	Invoked when an unhandled MouseWheel attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewDragEnter(DragEventArgs) protected	Invoked when an unhandled PreviewDragEnter attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewDragLeave(DragEventArgs) protected	Invoked when an unhandled PreviewDragLeave attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewDragOver(DragEventArgs) protected	Invoked when an unhandled PreviewDragOver attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewDrop(DragEventArgs) protected	Invoked when an unhandled PreviewDrop attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewGiveFeedback(GiveFeedbackEventArgs) protected	Invoked when an unhandled PreviewGiveFeedback attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewGotKeyboardFocus(KeyboardFocusChangedEventArgs) protected	Invoked when an unhandled PreviewGotKeyboardFocus attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewKeyDown(KeyEventArgs) protected	Invoked when an unhandled PreviewKeyDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewKeyUp(KeyEventArgs) protected	Invoked when an unhandled PreviewKeyUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewLostKeyboardFocus(KeyboardFocusChangedEventArgs) protected	Invoked when an unhandled PreviewKeyDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseDoubleClick(MouseButtonEventArgs) protected	Raises the PreviewMouseDoubleClick routed event. Inherited from Control.
OnPreviewMouseDown(MouseButtonEventArgs) protected	Invoked when an unhandled PreviewMouseDown attached routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseLeftButtonDown(MouseButtonEventArgs) protected	Invoked when an unhandled PreviewMouseLeftButtonDown routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseLeftButtonUp(MouseButtonEventArgs) protected	Invoked when an unhandled PreviewMouseLeftButtonUp routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseMove(MouseEventArgs) protected	Invoked when an unhandled PreviewMouseMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseRightButtonDown(MouseButtonEventArgs) protected	Invoked when an unhandled PreviewMouseRightButtonDown routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseRightButtonUp(MouseButtonEventArgs) protected	Invoked when an unhandled PreviewMouseRightButtonUp routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseUp(MouseButtonEventArgs) protected	Invoked when an unhandled PreviewMouseUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseWheel(MouseWheelEventArgs) protected	Invoked when an unhandled PreviewMouseWheel attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewQueryContinueDrag(QueryContinueDragEventArgs) protected	Invoked when an unhandled PreviewQueryContinueDrag attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusButtonDown(StylusButtonEventArgs) protected	Invoked when an unhandled PreviewStylusButtonDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusButtonUp(StylusButtonEventArgs) protected	Invoked when an unhandled PreviewStylusButtonUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusDown(StylusDownEventArgs) protected	Invoked when an unhandled PreviewStylusDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusInAirMove(StylusEventArgs) protected	Invoked when an unhandled PreviewStylusInAirMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusInRange(StylusEventArgs) protected	Invoked when an unhandled PreviewStylusInRange attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusMove(StylusEventArgs) protected	Invoked when an unhandled PreviewStylusMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusOutOfRange(StylusEventArgs) protected	Invoked when an unhandled PreviewStylusOutOfRange attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusSystemGesture(StylusSystemGestureEventArgs) protected	Invoked when an unhandled PreviewStylusSystemGesture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusUp(StylusEventArgs) protected	Invoked when an unhandled PreviewStylusUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewTextInput(TextCompositionEventArgs) protected	Invoked when an unhandled PreviewTextInput attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewTouchDown(TouchEventArgs) protected	Provides class handling for the PreviewTouchDown routed event that occurs when a touch presses this element. Inherited from UIElement.
OnPreviewTouchMove(TouchEventArgs) protected	Provides class handling for the PreviewTouchMove routed event that occurs when a touch moves while inside this element. Inherited from UIElement.
OnPreviewTouchUp(TouchEventArgs) protected	Provides class handling for the PreviewTouchUp routed event that occurs when a touch is released inside this element. Inherited from UIElement.
OnQueryContinueDrag(QueryContinueDragEventArgs) protected	Invoked when an unhandled QueryContinueDrag attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnQueryCursor(QueryCursorEventArgs) protected	Invoked when an unhandled QueryCursor attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnRender(DrawingContext) protected	When overridden in a derived class, participates in rendering operations that are directed by the layout system. The rendering instructions for this element are not used directly when this method is invoked, and are instead preserved for later asynchronous use by layout and drawing. Inherited from UIElement.
OnRenderSizeChanged(SizeChangedInfo) protected	Raises the SizeChanged event, using the specified information as part of the eventual event data. Inherited from FrameworkElement.
OnStyleChanged(Style, Style) protected	Invoked when the style in use on this element changes, which will invalidate the layout. Inherited from FrameworkElement.
OnStylusButtonDown(StylusButtonEventArgs) protected	Invoked when an unhandled StylusButtonDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusButtonUp(StylusButtonEventArgs) protected	Invoked when an unhandled StylusButtonUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusDown(StylusDownEventArgs) protected	Invoked when an unhandled StylusDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusEnter(StylusEventArgs) protected	Invoked when an unhandled StylusEnter attached event is raised by this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusInAirMove(StylusEventArgs) protected	Invoked when an unhandled StylusInAirMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusInRange(StylusEventArgs) protected	Invoked when an unhandled StylusInRange attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusLeave(StylusEventArgs) protected	Invoked when an unhandled StylusLeave attached event is raised by this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusMove(StylusEventArgs) protected	Invoked when an unhandled StylusMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusOutOfRange(StylusEventArgs) protected	Invoked when an unhandled StylusOutOfRange attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusSystemGesture(StylusSystemGestureEventArgs) protected	Invoked when an unhandled StylusSystemGesture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusUp(StylusEventArgs) protected	Invoked when an unhandled StylusUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnTemplateChanged(ControlTemplate, ControlTemplate) protected	Called whenever the control’s template changes. Inherited from Control.
OnTextInput(TextCompositionEventArgs) protected	Invoked when an unhandled TextInput attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnToolTipClosing(ToolTipEventArgs) protected	Invoked whenever an unhandled ToolTipClosing routed event reaches this class in its route. Implement this method to add class handling for this event. Inherited from FrameworkElement.
OnToolTipOpening(ToolTipEventArgs) protected	Invoked whenever the ToolTipOpening routed event reaches this class in its route. Implement this method to add class handling for this event. Inherited from FrameworkElement.
OnTouchDown(TouchEventArgs) protected	Provides class handling for the TouchDown routed event that occurs when a touch presses inside this element. Inherited from UIElement.
OnTouchEnter(TouchEventArgs) protected	Provides class handling for the TouchEnter routed event that occurs when a touch moves from outside to inside the bounds of this element. Inherited from UIElement.
OnTouchLeave(TouchEventArgs) protected	Provides class handling for the TouchLeave routed event that occurs when a touch moves from inside to outside the bounds of this UIElement. Inherited from UIElement.
OnTouchMove(TouchEventArgs) protected	Provides class handling for the TouchMove routed event that occurs when a touch moves while inside this element. Inherited from UIElement.
OnTouchUp(TouchEventArgs) protected	Provides class handling for the TouchUp routed event that occurs when a touch is released inside this element. Inherited from UIElement.
OnVisualChildrenChanged(DependencyObject, DependencyObject) protected	Called when the VisualCollection of the visual object is modified. Inherited from Visual.
OnVisualParentChanged(DependencyObject) protected	Invoked when the parent of this element in the visual tree is changed. Overrides OnVisualParentChanged(DependencyObject). Inherited from FrameworkElement.
ParentLayoutInvalidated(UIElement) protected	Supports incremental layout implementations in specialized subclasses of FrameworkElement. ParentLayoutInvalidated(UIElement) is invoked when a child element has invalidated a property that is marked in metadata as affecting the parent’s measure or arrange passes during layout. Inherited from FrameworkElement.
PointFromScreen(Point)	Converts a Point in screen coordinates into a Point that represents the current coordinate system of the Visual. Inherited from Visual.
PointToScreen(Point)	Converts a Point that represents the current coordinate system of the Visual into a Point in screen coordinates. Inherited from Visual.
PredictFocus(FocusNavigationDirection)	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 FrameworkElement.
Print()	Invokes the Print dialog and prints the pivot grid.
PrintDirect()	Prints the pivot grid using the default printer.
PrintDirect(PrintQueue)	Obsolete. Prints the pivot grid using the printer specified by the print queue.
PrintDirect(String)	Prints the pivot grid to the specified printer.
RaiseEvent(RoutedEventArgs)	Raises a specific routed event. The RoutedEvent to be raised is identified within the RoutedEventArgs instance that is provided (as the RoutedEvent property of that event data). Inherited from UIElement.
ReadLocalValue(DependencyProperty)	Returns the local value of a dependency property, if it exists. Inherited from DependencyObject.
ReferenceEquals(Object, Object) static	Determines whether the specified Object instances are the same instance. Inherited from Object.
RefreshData()	Recalculates summaries.
RegisterName(String, Object)	Provides an accessor that simplifies access to the NameScope registration method. Inherited from FrameworkElement.
ReleaseAllTouchCaptures()	Releases all captured touch devices from this element. Inherited from UIElement.
ReleaseMouseCapture()	Releases the mouse capture, if this element held the capture. Inherited from UIElement.
ReleaseStylusCapture()	Releases the stylus device capture, if this element held the capture. Inherited from UIElement.
ReleaseTouchCapture(TouchDevice)	Attempts to release the specified touch device from this element. Inherited from UIElement.
ReloadData()	Reloads data from the PivotGridControl data source and recalculates summaries.
ReloadDataAsync()	Reloads data from the control data source and recalculates summaries asynchronously.
RemoveHandler(RoutedEvent, Delegate)	Removes the specified routed event handler from this element. Inherited from UIElement.
RemoveLogicalChild(Object) protected	Removes the provided object from this element’s logical tree. FrameworkElement updates the affected logical tree parent pointers to keep in sync with this deletion. Inherited from FrameworkElement.
RemoveMRUFilter(CriteriaOperator)	Removes the specified criterion from the MRU Filter List.
RemoveVisualChild(Visual) protected	Removes the parent-child relationship between two visuals. Inherited from Visual.
ResetFilterCriteria()	Clears the filter criteria specified by the Filter Editor.
RestoreCollapsedStateFromFile(String)	Restores the collapsed state of field values from the specified file.
RestoreCollapsedStateFromStream(Stream)	Restores the collapsed state of field values from the specified stream.
RestoreCollapsedStateFromStreamAsync(Stream)	Restores the collapsed state of field values from the specified stream asynchronously.
RestoreLayoutFromJson(String)
RestoreLayoutFromJsonAsync(String)
RestoreLayoutFromStream(Stream)	Restores the pivot grid layout from the specified stream.
RestoreLayoutFromStreamAsync(Stream)	Restores the pivot grid layout from the specified stream asynchronously.
RestoreLayoutFromXml(String)	Restores the pivot grid’s layout from the specified XML file.
RestoreLayoutFromXmlAsync(String)	Restores the pivot grid’s layout from the specified XML file asynchronously.
RestorePivotGridFromFile(String)	Restores the PivotGridControl’s data and layout from the specified file.
RestorePivotGridFromStream(Stream)	Restores the PivotGridControl’s data and layout from the specified stream.
RetrieveFields()	Creates PivotGridField objects for all columns in the bound data source.
RetrieveFields(FieldArea, Boolean)	Creates PivotGridField objects for all fields in a data source, and moves them to the specified area, making them visible or hidden.
RetrieveFieldsAsync()	Creates PivotGridField objects for all columns in the bound data source asynchronously.
RetrieveFieldsAsync(FieldArea, Boolean)	Creates PivotGridField objects for all columns in a data source and specifies the area and visibility of the fields. This method executes these actions asynchronously.
SaveCollapsedStateToFile(String)	Saves the collapsed state of field values to the specified file.
SaveCollapsedStateToStream(Stream)	Saves the collapsed state of field values to the specified stream.
SaveLayoutToJson(String)
SaveLayoutToStream(Stream)	Saves the PivotGridControl’s layout to the specified stream.
SaveLayoutToXml(String)	Saves the PivotGridControl’s layout to a file in XML format.
SavePivotGridToFile(String, Boolean)	Saves the PivotGridControl’s data and layout to the specified file, and allows data to be compressed.
SavePivotGridToFile(String)	Saves the PivotGridControl’s data and layout to the specified file.
SavePivotGridToStream(Stream, Boolean)	Saves the PivotGridControl’s data and layout to the specified stream, and allows data to be compressed.
SavePivotGridToStream(Stream)	Saves the PivotGridControl’s data and layout to the specified stream.
ScrollTo(Point)	Scrolls the pivot grid to make the specified cell visible at the top left.
ScrollToPixels(Point)	Scrolls the pivot grid to make the specified coordinates visible at the top left.
ScrollToPixels(Point)	Scrolls the pivot grid to make the specified coordinates visible at the top left.
SetBinding(DependencyProperty, String)	Attaches a binding to this element, based on the provided source property name as a path qualification to the data source. Inherited from FrameworkElement.
SetBinding(DependencyProperty, BindingBase)	Attaches a binding to this element, based on the provided binding object. Inherited from FrameworkElement.
SetCurrentValue(DependencyProperty, Object)	Sets the value of a dependency property without changing its value source. Inherited from DependencyObject.
SetDataSourceAsync(Object)	Sets a data source for PivotGridControl and loads data asynchronously.
SetFieldHeaderDragIndicatorSize(DependencyObject, Double) static	Sets the value of the PivotGridControl.FieldHeaderDragIndicatorSize attached property for the specified DependencyObject.
SetFieldSortingAsync(PivotGridField, FieldSortOrder)	Sets the specified sort order for the specified field asynchronously.
SetFlowDirection(DependencyObject, FlowDirection) static	Sets the value of the FlowDirection attached property for the provided element. Inherited from FrameworkElement.
SetOlapConnectionStringAsync(String)	Sets a connection string to a cube in an MS Analysis Services database, and loads data from the cube asynchronously.
SetOlapFilterByUniqueName(Boolean)
SetOlapFilterByUniqueNameAsync(Boolean)
SetPivotGrid(DependencyObject, PivotGridControl) static	Sets the value of the PivotGridControl.PivotGrid attached property for the specified DependencyObject.
SetResourceReference(DependencyProperty, Object)	Searches for a resource with the specified name and sets up a resource reference to it for the specified property. Inherited from FrameworkElement.
SetSelectionByFieldValues(Boolean, Object[], PivotGridField)	Selects cells that reside within the specified column or row, identified by the specified data field.
SetSelectionByFieldValues(Boolean, Object[])	Selects cells that reside within the specified column or row.
SetShowBorder(DependencyObject, Boolean) static	Sets the value of the PivotGridControl.ShowBorder attached property to a specified DependencyObject.
SetValue(DependencyProperty, Object)	Sets the local value of a dependency property, specified by its dependency property identifier. Inherited from DependencyObject.
SetValue(DependencyPropertyKey, Object)	Sets the local value of a read-only dependency property, specified by the DependencyPropertyKey identifier of the dependency property. Inherited from DependencyObject.
ShouldSerializeCommandBindings()	Returns whether serialization processes should serialize the contents of the CommandBindings property on instances of this class. Inherited from UIElement.
ShouldSerializeInputBindings()	Returns whether serialization processes should serialize the contents of the InputBindings property on instances of this class. Inherited from UIElement.
ShouldSerializeProperty(DependencyProperty) protected	Returns a value that indicates whether serialization processes should serialize the value for the provided dependency property. Inherited from DependencyObject.
ShouldSerializeResources()	Returns whether serialization processes should serialize the contents of the Resources property. Inherited from FrameworkElement.
ShouldSerializeStyle()	Returns whether serialization processes should serialize the contents of the Style property. Inherited from FrameworkElement.
ShouldSerializeTriggers()	Returns whether serialization processes should serialize the contents of the Triggers property. Inherited from FrameworkElement.
ShowAllTotals()	Shows all totals and grand totals.
ShowConditionalFormattingManager(PivotGridField, PivotGridField, PivotGridField)	Invokes the Conditional Formatting Rules Manager with the predefined measure, row, and column.
ShowConditionalFormattingManager(PivotGridField)	Invokes the Conditional Formatting Rules Manager with the predefined measure.
ShowExpressionEditor(PivotGridField, Theme)	Invokes the Expression Editor where a user can edit the specified field’s binding expression.
ShowExpressionEditor(PivotGridField)	Invokes the Expression Editor where a user can edit the specified field’s binding expression.
ShowFieldList()	Invokes the Field List.
ShowFilterEditor()	Invokes the Filter Editor.
ShowFormatConditionDialog(PivotGridField, PivotGridField, PivotGridField, FormatConditionDialogType)	Invokes the specified format condition dialog.
ShowPrintPreview(FrameworkElement, String, String)	Creates the print document from the PivotGridControl and displays the Print Preview of the document, using the specified owner, document name and Print Preview ‘s title.
ShowPrintPreview(FrameworkElement, String)	Creates the print document from the PivotGridControl and displays the Print Preview of the document, using the specified owner and document name.
ShowPrintPreview(FrameworkElement)	Creates the print document from the PivotGridControl and displays the Print Preview of the document, using the specified owner.
ShowPrintPreviewDialog(Window, String, String)	Creates the print document from the PivotGridControl and displays the modal Print Preview of the document, using the specified owner, document name and Print Preview ‘s title.
ShowPrintPreviewDialog(Window, String)	Creates the print document from the PivotGridControl and displays the modal Print Preview of the document, using the specified owner and document name.
ShowPrintPreviewDialog(Window)	Creates the print document from the PivotGridControl and displays the modal Print Preview of the document, using the specified owner.
ShowRibbonPrintPreview()	Creates the printable document and displays the Print Preview with the Ribbon.
ShowRibbonPrintPreview(FrameworkElement, String, String)	Creates the printable document and displays the Print Preview with the Ribbon , using the specified owner, document name and window title.
ShowRibbonPrintPreview(FrameworkElement, String)	Creates the printable document and displays the Print Preview with the Ribbon , using the specified owner and document name.
ShowRibbonPrintPreview(FrameworkElement)	Creates the printable document and displays the Print Preview with the Ribbon , using the specified owner.
ShowRibbonPrintPreviewDialog()	Creates the printable document and displays the modal Print Preview dialog with the Ribbon.
ShowRibbonPrintPreviewDialog(FrameworkElement, String, String)	Creates the printable document and displays the modal Print Preview dialog with the Ribbon , using the specified owner, document name and window title.
ShowRibbonPrintPreviewDialog(FrameworkElement, String)	Creates the printable document and displays the modal Print Preview dialog with the Ribbon , using the specified owner and document name.
ShowRibbonPrintPreviewDialog(FrameworkElement)	Creates the printable document and displays the modal Print Preview dialog with the Ribbon , using the specified owner.
ShowUnboundExpressionEditor(PivotGridField, Theme)	Invokes the Expression Editor used to create expressions for unbound fields.
ShowUnboundExpressionEditor(PivotGridField)	Invokes the Expression Editor used to create expressions for unbound fields.
IQueryAmbient.IsAmbientPropertyAvailable(String)	For a description of this member, see the IsAmbientPropertyAvailable(String) method. Inherited from FrameworkElement.
ToString()	Returns the string representation of a Control object. Inherited from Control.
TransformToAncestor(Visual3D)	Returns a transform that can be used to transform coordinates from the Visual to the specified Visual3D ancestor of the visual object. Inherited from Visual.
TransformToAncestor(Visual)	Returns a transform that can be used to transform coordinates from the Visual to the specified Visual ancestor of the visual object. Inherited from Visual.
TransformToDescendant(Visual)	Returns a transform that can be used to transform coordinates from the Visual to the specified visual object descendant. Inherited from Visual.
TransformToVisual(Visual)	Returns a transform that can be used to transform coordinates from the Visual to the specified visual object. Inherited from Visual.
TranslatePoint(Point, UIElement)	Translates a point relative to this element to coordinates that are relative to the specified element. Inherited from UIElement.
TryFindResource(Object)	Searches for a resource with the specified key, and returns that resource if found. Inherited from FrameworkElement.
UnregisterName(String)	Simplifies access to the NameScope de-registration method. Inherited from FrameworkElement.
UpdateDefaultStyle()	Reapplies the default style to the current FrameworkElement. Inherited from FrameworkElement.
UpdateLayout()	Ensures that all visual child elements of this element are properly updated for layout. Inherited from UIElement.
VerifyAccess()	Enforces that the calling thread has access to this DispatcherObject. Inherited from DispatcherObject.

Events

Name	Description
AsyncOperationCompleted	Occurs after an asynchronous operation has been completed.
AsyncOperationStarting	Occurs before an asynchronous operation is started.
BeforeLoadLayout	Occurs before a layout is restored from a storage, allowing you to cancel this action.
BeginRefresh	Occurs before the control’s data recalculation starts.
BrushChanged	Occurs after a brush used to paint pivot grid cells or field values has been changed.
CellClick	Occurs when a cell is clicked.
CellDoubleClick	Occurs when a cell is double-clicked.
CellSelectionChanged	Occurs when the cell selection is modified.
ContextMenuClosing	Occurs just before any context menu on the element is closed. Inherited from FrameworkElement.
ContextMenuOpening	Occurs when any context menu on the element is opened. Inherited from FrameworkElement.
CustomCellAppearance	Allows you to specify brushes used to paint cells.
CustomCellDisplayText	Enables custom display text to be provided for summary cells.
CustomCellValue	Allows you to replace cell values with values calculated in the event handler.
CustomChartDataSourceData	Occurs when a PivotGridControl prepares data to be displayed in a ChartControl.
CustomChartDataSourceRows	Allows you to customize pivot grid data before passing it to a chart control.
CustomFieldListSort	Allows you to change field and folder order in the Field List.
CustomFieldSort	Provides the ability to sort data using custom rules.
CustomFieldValueCells	Allows you to customize field value cells.
CustomFilterPanelDisplayText	Allows you to display custom text instead of a filter expression in the legacy Filter Panel (Prefilter Panel).
CustomFilterPopupItems	Allows you to customize the Legacy filter drop-down list items.
CustomGroupInterval	Allows you to custom group values of a column and a row field.
CustomServerModeSort	In OLAP and server mode, provides the capability to sort data using custom rules.
CustomSummary	Allows you to calculate summary values manually.
CustomUnboundFieldData	Enables providing data to unbound fields.
CustomUniqueValues
CustomValueAppearance	Allows you to specify brushes used to paint field value cells.
DataContextChanged	Occurs when the data context for this element changes. Inherited from FrameworkElement.
DataSourceChanged	Occurs after the PivotGridControl’s data source has been changed.
DragEnter	Occurs when the input system reports an underlying drag event with this element as the drag target. Inherited from UIElement.
DragLeave	Occurs when the input system reports an underlying drag event with this element as the drag origin. Inherited from UIElement.
DragOver	Occurs when the input system reports an underlying drag event with this element as the potential drop target. Inherited from UIElement.
Drop	Occurs when the input system reports an underlying drop event with this element as the drop target. Inherited from UIElement.
EndRefresh	Occurs after the control’s data recalculation has been completed.
ExpressionEditorCreated	Fires after an Expression Editor has been created for ExpressionDataBinding.
FieldAreaChanged	Occurs after a field location or visibility has been changed.
FieldAreaChanging	Occurs before a field’s position is changed, allowing cancellation of this action.
FieldAreaIndexChanged	Occurs after a field has been moved.
FieldExpandedInGroupChanged	Fires after the expansion status of fields combined into a field group has been changed.
FieldFilterChanged	Occurs after a field’s filter condition has been changed.
FieldFilterChanging	Allows you to customize or cancel the applied filter.
FieldPropertyChanged	Occurs after a field’s property has been changed.
FieldSizeChanged	Occurs after the width or height of a field has been changed.
FieldUnboundExpressionChanged	Fires after the PivotGridField.UnboundExpression property’s value has been changed.
FieldValueCollapsed	Occurs after a field value has been collapsed.
FieldValueCollapsing	Occurs when a field value is about to be collapsed, allowing cancellation of the action.
FieldValueDisplayText	Enables you to provide custom text displayed within individual field values or filter dropdown items.
FieldValueExpanded	Occurs after a field value has been expanded.
FieldValueExpanding	Occurs when a field value is about to be expanded, allowing cancellation of the action.
FieldValueNotExpanded	Occurs in OLAP mode, when an end-user clicks an expand button or selects Expand All from the context menu, and the field value cannot be expanded.
FieldVisibleChanged	Occurs after a field has been shown or hidden.
FieldVisibleChanging	Occurs before a field becomes shown or hidden.
FilterCriteriaChanged	Occurs when the filter expression specified by the Filter Editor is changed.
FocusableChanged	Occurs when the value of the Focusable property changes. Inherited from UIElement.
FocusedCellChanged	Occurs after the focused cell has been changed.
GiveFeedback	Occurs when the input system reports an underlying drag-and-drop event that involves this element. Inherited from UIElement.
GotFocus	Occurs when this element gets logical focus. Inherited from UIElement.
GotKeyboardFocus	Occurs when the keyboard is focused on this element. Inherited from UIElement.
GotMouseCapture	Occurs when this element captures the mouse. Inherited from UIElement.
GotStylusCapture	Occurs when this element captures the stylus. Inherited from UIElement.
GotTouchCapture	Occurs when a touch is captured to this element. Inherited from UIElement.
GridLayout	Fires after the PivotGridControl’s layout has been changed.
GroupFilterChanged	Occurs after a group filter condition is changed.
HiddenFieldList	Occurs after the Field List has been hidden.
Initialized	Occurs when this FrameworkElement is initialized. This event coincides with cases where the value of the IsInitialized property changes from `false` (or undefined) to `true`. Inherited from FrameworkElement.
IsEnabledChanged	Occurs when the value of the IsEnabled property on this element changes. Inherited from UIElement.
IsHitTestVisibleChanged	Occurs when the value of the IsHitTestVisible dependency property changes on this element. Inherited from UIElement.
IsKeyboardFocusedChanged	Occurs when the value of the IsKeyboardFocused property changes on this element. Inherited from UIElement.
IsKeyboardFocusWithinChanged	Occurs when the value of the IsKeyboardFocusWithin property changes on this element. Inherited from UIElement.
IsMouseCapturedChanged	Occurs when the value of the IsMouseCaptured property changes on this element. Inherited from UIElement.
IsMouseCaptureWithinChanged	Occurs when the value of the IsMouseCaptureWithinProperty changes on this element. Inherited from UIElement.
IsMouseDirectlyOverChanged	Occurs when the value of the IsMouseDirectlyOver property changes on this element. Inherited from UIElement.
IsStylusCapturedChanged	Occurs when the value of the IsStylusCaptured property changes on this element. Inherited from UIElement.
IsStylusCaptureWithinChanged	Occurs when the value of the IsStylusCaptureWithin property changes on this element. Inherited from UIElement.
IsStylusDirectlyOverChanged	Occurs when the value of the IsStylusDirectlyOver property changes on this element. Inherited from UIElement.
IsVisibleChanged	Occurs when the value of the IsVisible property changes on this element. Inherited from UIElement.
KeyDown	Occurs when a key is pressed while focus is on this element. Inherited from UIElement.
KeyUp	Occurs when a key is released while focus is on this element. Inherited from UIElement.
LayoutUpdated	Occurs when the layout of the various visual elements associated with the current Dispatcher changes. Inherited from UIElement.
LayoutUpgrade	Occurs when a layout is restored from a data store (stream, XML file or system registry) and its version is different than the control’s current layout version.
Loaded	Occurs when the element is laid out, rendered, and ready for interaction. Inherited from FrameworkElement.
LostFocus	Occurs when this element loses logical focus. Inherited from UIElement.
LostKeyboardFocus	Occurs when the keyboard is no longer focused on this element. Inherited from UIElement.
LostMouseCapture	Occurs when this element loses mouse capture. Inherited from UIElement.
LostStylusCapture	Occurs when this element loses stylus capture. Inherited from UIElement.
LostTouchCapture	Occurs when this element loses a touch capture. Inherited from UIElement.
ManipulationBoundaryFeedback	Occurs when the manipulation encounters a boundary. Inherited from UIElement.
ManipulationCompleted	Occurs when a manipulation and inertia on the UIElement object is complete. Inherited from UIElement.
ManipulationDelta	Occurs when the input device changes position during a manipulation. Inherited from UIElement.
ManipulationInertiaStarting	Occurs when the input device loses contact with the UIElement object during a manipulation and inertia begins. Inherited from UIElement.
ManipulationStarted	Occurs when an input device begins a manipulation on the UIElement object. Inherited from UIElement.
ManipulationStarting	Occurs when the manipulation processor is first created. Inherited from UIElement.
MouseDoubleClick	Occurs when a mouse button is clicked two or more times. Inherited from Control.
MouseDown	Occurs when any mouse button is pressed while the pointer is over this element. Inherited from UIElement.
MouseEnter	Occurs when the mouse pointer enters the bounds of this element. Inherited from UIElement.
MouseLeave	Occurs when the mouse pointer leaves the bounds of this element. Inherited from UIElement.
MouseLeftButtonDown	Occurs when the left mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement.
MouseLeftButtonUp	Occurs when the left mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
MouseMove	Occurs when the mouse pointer moves while over this element. Inherited from UIElement.
MouseRightButtonDown	Occurs when the right mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement.
MouseRightButtonUp	Occurs when the right mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
MouseUp	Occurs when any mouse button is released over this element. Inherited from UIElement.
MouseWheel	Occurs when the user rotates the mouse wheel while the mouse pointer is over this element. Inherited from UIElement.
OlapDataLoaded	Not used.
OlapException	Obsolete. Raised when a query processing error occurs on a bound OLAP server, or when the connection to this server is lost.
OlapQueryData	Allows you to get a query used to obtain data in PivotGrid.
OlapQueryTimeout	Occurs when the query time-out has expired.
PopupMenuShowing	Allows you to customize the context menus.
PreviewDragEnter	Occurs when the input system reports an underlying drag event with this element as the drag target. Inherited from UIElement.
PreviewDragLeave	Occurs when the input system reports an underlying drag event with this element as the drag origin. Inherited from UIElement.
PreviewDragOver	Occurs when the input system reports an underlying drag event with this element as the potential drop target. Inherited from UIElement.
PreviewDrop	Occurs when the input system reports an underlying drop event with this element as the drop target. Inherited from UIElement.
PreviewGiveFeedback	Occurs when a drag-and-drop operation is started. Inherited from UIElement.
PreviewGotKeyboardFocus	Occurs when the keyboard is focused on this element. Inherited from UIElement.
PreviewKeyDown	Occurs when a key is pressed while focus is on this element. Inherited from UIElement.
PreviewKeyUp	Occurs when a key is released while focus is on this element. Inherited from UIElement.
PreviewLostKeyboardFocus	Occurs when the keyboard is no longer focused on this element. Inherited from UIElement.
PreviewMouseDoubleClick	Occurs when a user clicks the mouse button two or more times. Inherited from Control.
PreviewMouseDown	Occurs when any mouse button is pressed while the pointer is over this element. Inherited from UIElement.
PreviewMouseLeftButtonDown	Occurs when the left mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseLeftButtonUp	Occurs when the left mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseMove	Occurs when the mouse pointer moves while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseRightButtonDown	Occurs when the right mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseRightButtonUp	Occurs when the right mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseUp	Occurs when any mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseWheel	Occurs when the user rotates the mouse wheel while the mouse pointer is over this element. Inherited from UIElement.
PreviewQueryContinueDrag	Occurs when there is a change in the keyboard or mouse button state during a drag-and-drop operation. Inherited from UIElement.
PreviewStylusButtonDown	Occurs when the stylus button is pressed while the pointer is over this element. Inherited from UIElement.
PreviewStylusButtonUp	Occurs when the stylus button is released while the pointer is over this element. Inherited from UIElement.
PreviewStylusDown	Occurs when the stylus touches the digitizer while it is over this element. Inherited from UIElement.
PreviewStylusInAirMove	Occurs when the stylus moves over an element without actually touching the digitizer. Inherited from UIElement.
PreviewStylusInRange	Occurs when the stylus is close enough to the digitizer to be detected, while over this element. Inherited from UIElement.
PreviewStylusMove	Occurs when the stylus moves while over the element. The stylus must move while being detected by the digitizer to raise this event, otherwise, PreviewStylusInAirMove is raised instead. Inherited from UIElement.
PreviewStylusOutOfRange	Occurs when the stylus is too far from the digitizer to be detected. Inherited from UIElement.
PreviewStylusSystemGesture	Occurs when a user performs one of several stylus gestures. Inherited from UIElement.
PreviewStylusUp	Occurs when the user raises the stylus off the digitizer while the stylus is over this element. Inherited from UIElement.
PreviewTextInput	Occurs when this element gets text in a device-independent manner. Inherited from UIElement.
PreviewTouchDown	Occurs when a finger touches the screen while the finger is over this element. Inherited from UIElement.
PreviewTouchMove	Occurs when a finger moves on the screen while the finger is over this element. Inherited from UIElement.
PreviewTouchUp	Occurs when a finger is raised off of the screen while the finger is over this element. Inherited from UIElement.
PropertyChanged	Occurs every time any of the PivotGridControl properties has changed its value.
QueryContinueDrag	Occurs when there is a change in the keyboard or mouse button state during a drag-and-drop operation. Inherited from UIElement.
QueryCursor	Occurs when the cursor is requested to display. This event is raised on an element each time that the mouse pointer moves to a new location, which means the cursor object might need to be changed based on its new position. Inherited from UIElement.
QueryException	Occurs when a query processing error occurs on a bound server providing data for the PivotGridControl.
RequestBringIntoView	Occurs when BringIntoView(Rect) is called on this element. Inherited from FrameworkElement.
ShownFieldList	Occurs after the Field List has been shown.
SizeChanged	Occurs when either the ActualHeight or the ActualWidth properties change value on this element. Inherited from FrameworkElement.
SourceUpdated	Occurs when the source value changes for any existing property binding on this element. Inherited from FrameworkElement.
StylusButtonDown	Occurs when the stylus button is pressed while the pointer is over this element. Inherited from UIElement.
StylusButtonUp	Occurs when the stylus button is released while the pointer is over this element. Inherited from UIElement.
StylusDown	Occurs when the stylus touches the digitizer while the stylus is over this element. Inherited from UIElement.
StylusEnter	Occurs when the stylus enters the bounds of this element. Inherited from UIElement.
StylusInAirMove	Occurs when the stylus moves over an element without actually touching the digitizer. Inherited from UIElement.
StylusInRange	Occurs when the stylus is close enough to the digitizer to be detected, while over this element. Inherited from UIElement.
StylusLeave	Occurs when the stylus leaves the bounds of the element. Inherited from UIElement.
StylusMove	Occurs when the stylus moves over this element. The stylus must move while on the digitizer to raise this event. Otherwise, StylusInAirMove is raised instead. Inherited from UIElement.
StylusOutOfRange	Occurs when the stylus is too far from the digitizer to be detected, while over this element. Inherited from UIElement.
StylusSystemGesture	Occurs when a user performs one of several stylus gestures. Inherited from UIElement.
StylusUp	Occurs when the user raises the stylus off the digitizer while it is over this element. Inherited from UIElement.
TargetUpdated	Occurs when the target value changes for any property binding on this element. Inherited from FrameworkElement.
TextInput	Occurs when this element gets text in a device-independent manner. Inherited from UIElement.
ToolTipClosing	Occurs just before any tooltip on the element is closed. Inherited from FrameworkElement.
ToolTipOpening	Occurs when any tooltip on the element is opened. Inherited from FrameworkElement.
TouchDown	Occurs when a finger touches the screen while the finger is over this element. Inherited from UIElement.
TouchEnter	Occurs when a touch moves from outside to inside the bounds of this element. Inherited from UIElement.
TouchLeave	Occurs when a touch moves from inside to outside the bounds of this element. Inherited from UIElement.
TouchMove	Occurs when a finger moves on the screen while the finger is over this element. Inherited from UIElement.
TouchUp	Occurs when a finger is raised off of the screen while the finger is over this element. Inherited from UIElement.
UnboundExpressionEditorCreated	Fires after an Expression Editor has been created for an unbound field.
Unloaded	Occurs when the element is removed from within an element tree of loaded elements. Inherited from FrameworkElement.

Attached Properties

Name	Description
Data static	For internal use.
FieldHeaderDragIndicatorSize static	This member supports the internal infrastructure and is not intended to be used directly from your code.
PivotGrid static	Gets or sets the owner PivotGridControl of an element. This is an attached property.
ShowBorder static	Gets or sets whether the pivot grid’s border is displayed. This is a dependency property.