[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]ASP.NET WebForms Controls
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Web
  [Expand]DevExpress.Web.ASPxGauges
  [Expand]DevExpress.Web.ASPxGauges.Base
  [Expand]DevExpress.Web.ASPxGauges.Scripts
  [Expand]DevExpress.Web.ASPxHtmlEditor
  [Expand]DevExpress.Web.ASPxHtmlEditor.Localization
  [Expand]DevExpress.Web.ASPxHtmlEditor.Scripts
  [Collapse]DevExpress.Web.ASPxPivotGrid
   [Expand]ASPxPivotCustomizationControl Class
   [Collapse]ASPxPivotGrid Class
     ASPxPivotGrid Members
     ASPxPivotGrid Constructor
    [Expand]ASPxPivotGrid Properties
    [Expand]ASPxPivotGrid Events
    [Collapse]ASPxPivotGrid Methods
      BeginUpdate Method
      CalcCallbackResult Method
      CollapseAll Method
      CollapseAllColumns Method
      CollapseAllRows Method
      CollapseValue Method
     [Expand]CreateDrillDownDataSource Method
     [Expand]CreateOLAPDrillDownDataSource Method
     [Expand]CreateServerModeDrillDownDataSource Method
     [Expand]CreateSummaryDataSource Method
      Dispose Method
      EndUpdate Method
      EnsureRefreshData Method
      ExpandAll Method
      ExpandAllColumns Method
      ExpandAllRows Method
     [Expand]ExpandValue Method
      GetAbsoluteColumnIndex Method
      GetAbsoluteRowIndex Method
     [Expand]GetCellInfo Method
     [Expand]GetCellValue Method
     [Expand]GetColumnIndex Method
      GetFieldByArea Method
      GetFieldCountByArea Method
      GetFieldList Method
      GetFieldsByArea Method
      GetFieldValue Method
      GetFieldValueByIndex Method
     [Expand]GetFieldValueInfo Method
      GetFieldValueOLAPMember Method
     [Expand]GetFieldValueType Method
      GetKPIImage Method
      GetOLAPKPIList Method
      GetOLAPKPIMeasures Method
      GetOLAPKPIServerGraphic Method
      GetOLAPKPIValue Method
     [Expand]GetRowIndex Method
      IsFieldValueCollapsed Method
      IsLoading Method
      IsObjectCollapsed Method
      LayoutChanged Method
      LoadCollapsedStateFromStream Method
      LoadCollapsedStateFromString Method
     [Expand]LoadLayoutFromStream Method
     [Expand]LoadLayoutFromString Method
      ReloadData Method
     [Expand]RetrieveFields Method
      SaveCollapsedStateToStream Method
      SaveCollapsedStateToString Method
     [Expand]SaveLayoutToStream Method
     [Expand]SaveLayoutToString Method
      XtraFindFieldsItem Method
   [Expand]ASPxPivotGridExporter Class
   [Expand]ASPxPivotGridPager Class
   [Expand]ASPxPivotGridPopupMenu Class
   [Expand]CustomCustomizationFormSortEventArgs Class
   [Expand]CustomFieldDataEventArgs Class
    CustomFieldDataEventHandler Delegate
   [Expand]CustomizePivotCellEventArgs Class
    CustomizePivotCellEventHandler Delegate
   [Expand]CustomServerModeSortEventArgs Class
   [Expand]FieldValueCell Class
    MenuItemEnum Enumeration
    PagerAlign Enumeration
   [Expand]PivotAddPopupMenuItemEventArgs Class
    PivotAddPopupMenuItemEventHandler Delegate
   [Expand]PivotAreaChangingEventArgs Class
    PivotAreaChangingEventHandler Delegate
   [Expand]PivotAreaStyle Class
   [Expand]PivotCellBaseEventArgs Class
   [Expand]PivotCellDisplayTextEventArgs Class
    PivotCellDisplayTextEventHandler Delegate
   [Expand]PivotCellStyle Class
   [Expand]PivotCellValueEventArgs Class
   [Expand]PivotChartDataSourceRow Class
    PivotCollapsedStateStoreMode Enumeration
    PivotCustomCallbackEventHandler Delegate
   [Expand]PivotCustomCellStyleEventArgs Class
    PivotCustomCellStyleEventHandler Delegate
   [Expand]PivotCustomChartDataSourceDataEventArgs Class
    PivotCustomChartDataSourceDataEventHandler Delegate
   [Expand]PivotCustomChartDataSourceRowsEventArgs Class
    PivotCustomChartDataSourceRowsEventHandler Delegate
   [Expand]PivotCustomFieldValueCellsEventArgs Class
   [Expand]PivotCustomFilterPopupItemsEventArgs Class
   [Expand]PivotCustomGroupIntervalEventArgs Class
   [Expand]PivotCustomizationFormImages Class
   [Expand]PivotDataAreaPopupCreatedEventArgs Class
    PivotDataHeadersDisplayMode Enumeration
   [Expand]PivotFieldDisplayTextEventArgs Class
    PivotFieldDisplayTextEventHandler Delegate
   [Expand]PivotFieldEventArgs Class
    PivotFieldEventHandler Delegate
   [Expand]PivotFieldFilterChangingEventArgs Class
    PivotFieldFilterChangingEventHandler Delegate
   [Expand]PivotFieldPropertyChangedEventArgs Class
    PivotFieldPropertyChangedEventHandler Delegate
   [Expand]PivotFieldStateChangedCancelEventArgs Class
    PivotFieldStateChangedCancelEventHandler Delegate
   [Expand]PivotFieldStateChangedEventArgs Class
    PivotFieldStateChangedEventHandler Delegate
   [Expand]PivotFieldValueEventArgs Class
    PivotFieldValueEventHandler Delegate
   [Expand]PivotFieldValueStyle Class
   [Expand]PivotFilterButtonPanelStyle Class
   [Expand]PivotFilterButtonStyle Class
   [Expand]PivotFilterItemStyle Class
   [Expand]PivotFilterStyle Class
   [Expand]PivotGridCallbackStateEventArgs Class
    PivotGridCallbackStateEventHandler Delegate
   [Expand]PivotGridCellTemplateContainer Class
   [Expand]PivotGridCellTemplateItem Class
   [Expand]PivotGridClientSideEvents Class
   [Expand]PivotGridCustomCallbackEventArgs Class
   [Expand]PivotGridCustomFieldSortEventArgs Class
    PivotGridCustomFieldSortEventHandler Delegate
    PivotGridCustomGroupIntervalEventHandler Delegate
   [Expand]PivotGridCustomSummaryEventArgs Class
    PivotGridCustomSummaryEventHandler Delegate
   [Expand]PivotGridCustomTotal Class
   [Expand]PivotGridCustomTotalCollection Class
   [Expand]PivotGridEmptyAreaTemplateContainer Class
   [Expand]PivotGridField Class
   [Expand]PivotGridFieldCollection Class
   [Expand]PivotGridFieldValueTemplateContainer Class
   [Expand]PivotGridFieldValueTemplateItem Class
   [Expand]PivotGridHeaderTemplateContainer Class
   [Expand]PivotGridImageProperties Class
   [Expand]PivotGridImages Class
   [Expand]PivotGridPagerStyles Class
    PivotGridPopupMenuType Enumeration
    PivotGridResetOptions Enumeration
   [Expand]PivotGridStyles Class
   [Expand]PivotGridWebFieldOptions Class
   [Expand]PivotGridWebGroup Class
   [Expand]PivotGridWebGroupCollection Class
   [Expand]PivotGridWebOptionsBehavior Class
   [Expand]PivotGridWebOptionsChartDataSource Class
   [Expand]PivotGridWebOptionsCustomization Class
   [Expand]PivotGridWebOptionsData Class
   [Expand]PivotGridWebOptionsDataField Class
   [Expand]PivotGridWebOptionsFilter Class
   [Expand]PivotGridWebOptionsLayout Class
   [Expand]PivotGridWebOptionsLoadingPanel Class
   [Expand]PivotGridWebOptionsPager Class
   [Expand]PivotGridWebOptionsView Class
   [Expand]PivotGroupEventArgs Class
    PivotGroupEventHandler Delegate
   [Expand]PivotHeaderStyle Class
   [Expand]PivotHtmlCellPreparedEventArgs Class
    PivotHtmlCellPreparedEventHandler Delegate
   [Expand]PivotHtmlFieldValuePreparedEventArgs Class
    PivotHtmlFieldValuePreparedEventHandler Delegate
   [Expand]PivotOlapExceptionEventArgs Class
    PivotOlapExceptionEventHandler Delegate
   [Expand]PivotPopupMenuCreatedEventArgs Class
   [Expand]PivotQueryExceptionEventArgs Class
    PivotQueryExceptionEventHandler Delegate
    PivotScrollingMode Enumeration
   [Expand]PivotXlsExportOptions Class
   [Expand]PivotXlsxExportOptions Class
   [Expand]WebCustomExportCellEventArgs Class
   [Expand]WebCustomExportFieldValueEventArgs Class
   [Expand]WebCustomExportHeaderEventArgs Class
   [Expand]WebPivotGridOptionsPrint Class
  [Expand]DevExpress.Web.ASPxPivotGrid.Data
  [Expand]DevExpress.Web.ASPxPivotGrid.HtmlControls
  [Expand]DevExpress.Web.ASPxPivotGrid.Scripts
  [Expand]DevExpress.Web.ASPxRichEdit
  [Expand]DevExpress.Web.ASPxRichEdit.Localization
  [Expand]DevExpress.Web.ASPxRichEdit.Scripts
  [Expand]DevExpress.Web.ASPxScheduler
  [Expand]DevExpress.Web.ASPxScheduler.Commands
  [Expand]DevExpress.Web.ASPxScheduler.Commands.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Controls
  [Expand]DevExpress.Web.ASPxScheduler.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Drawing
  [Expand]DevExpress.Web.ASPxScheduler.Localization
  [Expand]DevExpress.Web.ASPxScheduler.Reporting
  [Expand]DevExpress.Web.ASPxScheduler.Scripts
  [Expand]DevExpress.Web.ASPxSpellChecker
  [Expand]DevExpress.Web.ASPxSpellChecker.Localization
  [Expand]DevExpress.Web.ASPxSpellChecker.Scripts
  [Expand]DevExpress.Web.ASPxSpreadsheet
  [Expand]DevExpress.Web.ASPxSpreadsheet.Localization
  [Expand]DevExpress.Web.ASPxSpreadsheet.Scripts
  [Expand]DevExpress.Web.ASPxTreeList
  [Expand]DevExpress.Web.ASPxTreeList.Internal
  [Expand]DevExpress.Web.ASPxTreeList.Localization
  [Expand]DevExpress.Web.ASPxTreeList.Scripts
  [Expand]DevExpress.Web.Captcha
  [Expand]DevExpress.Web.Data
  [Expand]DevExpress.Web.Internal
  [Expand]DevExpress.Web.Localization
  [Expand]DevExpress.Web.Mvc
  [Expand]DevExpress.Web.Mvc.BinderSettings
  [Expand]DevExpress.Web.Mvc.Controllers
  [Expand]DevExpress.Web.MVC.Scripts
  [Expand]DevExpress.Web.Mvc.UI
  [Expand]DevExpress.Web.Office
  [Expand]DevExpress.Web.Office.Internal
  [Expand]DevExpress.Web.Rendering
  [Expand]DevExpress.Web.Scripts
  [Expand]DevExpress.XtraCharts.Web
  [Expand]DevExpress.XtraCharts.Web.Designer
  [Expand]DevExpress.XtraCharts.Web.Scripts
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

ASPxPivotGrid Methods

Represents the ASPxPivotGrid control.

Expanded Public Methods

Show: Inherited
  Name Description
Public method ApplyStyle Copies any nonblank elements of the specified style to the Web control, overwriting any existing style elements of the control. This method is primarily used by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Public method ApplyStyleSheetSkin Applies the style properties defined in the page style sheet to the control. (Inherited from System.Web.UI.Control)
Public method ApplyStyleSheetThemeInternal For internal use only. (Inherited from ASPxWebControl)
Public method ApplyThemeInternal For internal use only. (Inherited from ASPxWebControl)
Public method BeginUpdate Prevents the ASPxPivotGrid from being rendered until the EndUpdate method is called.
Public method CalcCallbackResult Initiates a callback by the client and obtains the result processed within the server.
Public method CollapseAll Collapses all the columns and rows in the pivot grid.
Public method CollapseAllColumns Collapses all columns.
Public method CollapseAllRows Collapses all rows.
Public method CollapseValue Collapses the specified column or row.
Public method CopyBaseAttributes Copies the properties not encapsulated by the System.Web.UI.WebControls.WebControl.Style object from the specified Web server control to the Web server control that this method is called from. This method is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Public method CreateDrillDownDataSource Overloaded. Returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns to be returned. Used in OLAP and server mode.
Public method CreateOLAPDrillDownDataSource Overloaded. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns, and limit the number of records to be returned.
Public method CreateServerModeDrillDownDataSource Overloaded. In server mode, returns a list of records used to calculate a summary value for the specified cell.
Public method CreateSummaryDataSource Overloaded. Returns a summary data source for the specified row.
Public method DataBind Binds the data source to the invoked server control. (Inherited from ASPxWebControl)
Public method Dispose Enables a server control to perform final clean up before it is released from memory.
Public method EndUpdate Re-enables render operations after a call to the BeginUpdate method and forces an immediate re-rendering.
Public method EnsureRefreshData Refreshes the grid's data. This member supports the internal infrastructure and is not intended to be used directly from your code.
Public methodStatic member Equals Determines whether the specified System.Object instances are considered equal. (Inherited from System.Object)
Public method Equals Determines whether the specified System.Object is equal to the current System.Object. (Inherited from System.Object)
Public method ExpandAll Expands all the columns and rows in the pivot grid.
Public method ExpandAllColumns Expands all columns.
Public method ExpandAllRows Expands all rows.
Public method ExpandValue Overloaded. Expands the specified column or row.
Public method FindControl Searches the current naming container for a server control with the specified parameter. (Inherited from System.Web.UI.Control)
Public method Focus Sets input focus to the web control. (Inherited from ASPxWebControl)
Public method GetAbsoluteColumnIndex Returns the column's absolute index by its visible index within the current page.
Public method GetAbsoluteRowIndex Returns the row's absolute index by its visible index within the current page.
Public methodStatic member GetCallbackErrorMessage Obtains the error info while processing the redirection page. (Inherited from ASPxWebControl)
Public method GetCellInfo Overloaded. Returns an object that contains information on the specified cell.
Public method GetCellValue Overloaded. Returns the value displayed in the specified cell.
Public method GetClientSideEventHandler Returns the specified client event's handler. (Inherited from ASPxWebControl)
Public method GetColumnIndex Overloaded. Returns the index of the specified column.
Public method GetControlStyle For internal use only. (Inherited from ASPxWebControl)
Public method GetCssClassNamePrefix Overloaded. For internal use only. (Inherited from ASPxWebControl)
Public method GetDefaultBooleanProperty For internal use only. (Inherited from ASPxWebControl)
Public method GetFieldByArea Returns a pivot grid field located at the specified position within the specified area.
Public method GetFieldCountByArea Returns the number of fields located in the specified area.
Public method GetFieldList Returns the names of data source fields to which the pivot grid fields are bound.
Public method GetFieldsByArea Returns all visible pivot grid fields located at the specified area.
Public method GetFieldValue Returns the specified field value.
Public method GetFieldValueByIndex Returns the specified field's value by its index.
Public method GetFieldValueInfo Overloaded. Returns information about the specified field value.
Public method GetFieldValueOLAPMember Returns an OLAP member for the specified field value.
Public method GetFieldValueType Overloaded. Gets the type of a field value in the column or row area.
Public method GetHashCode Serves as a hash function for a particular type. System.Object.GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from System.Object)
Public method GetKPIImage Returns an image that corresponds to the specified KPI value.
Public method GetOLAPKPIList Gets names of available KPI in a cube.
Public method GetOLAPKPIMeasures Returns measures used to calculate the value, goal, status, trend and weight that represent the values of the specified Key Performance Indicator (KPI).
Public method GetOLAPKPIServerGraphic Returns a graphic set defined on the server for the specified KPI's trend and status.
Public method GetOLAPKPIValue Returns the specified KPI's value.
Public method GetPaddings For internal use only. (Inherited from ASPxWebControl)
Public methodStatic member GetResourceUrl Overloaded. Returns a URL reference to an embedded resource in an assembly. (Inherited from ASPxWebControl)
Public method GetRouteUrl (Inherited from System.Web.UI.Control)
Public method GetRowIndex Overloaded. Returns the absolute index of the specified row.
Public method GetType Gets the System.Type of the current instance. (Inherited from System.Object)
Public method GetUniqueIDRelativeTo (Inherited from System.Web.UI.Control)
Public method HasControls Determines if the server control contains any child controls. (Inherited from System.Web.UI.Control)
Public method HtmlEncode Overloaded. For internal use only. (Inherited from ASPxWebControl)
Public method IsAccessibilityCompliantRender Overloaded. Returns a value that indicates whether the control's accessible html code is rendered. (Inherited from ASPxWebControl)
Public method IsClientSideAPIEnabled Returns a value that indicates whether a specific programmatic interface (in particular, specific JavaScript objects and methods) are available to the control on the client side. (Inherited from ASPxWebControl)
Public method IsClientSideEventsAssigned For internal use only. (Inherited from ASPxWebControl)
Public method IsClientVisible For internal use only. (Inherited from ASPxWebControl)
Public method IsEnabled Returns a value that specifies whether a web control is enabled. (Inherited from ASPxWebControlBase)
Public method IsFieldValueCollapsed Indicates whether the specified field value is collapsed.
Public method IsLoading Indicates that the ASPxPivotGrid is being loaded.
Public method IsNativeRender For internal use only. (Inherited from ASPxWebControl)
Public method IsObjectCollapsed Returns whether the specified column field value or row field value is collapsed.
Public method IsViewStateStoring For internal use only. (Inherited from ASPxWebControlBase)
Public method IsVisible Returns a value that specifies whether the current web control is displayed. (Inherited from ASPxWebControlBase)
Public method LayoutChanged Updates a pivot grid.
Public method LoadCollapsedStateFromStream Restores the collapsed state of field values from the specified stream.
Public method LoadCollapsedStateFromString Restores the collapsed state of field values from the specified string.
Public method LoadLayoutFromStream Overloaded. Restores the pivot grid layout from the specified stream.
Public method LoadLayoutFromString Overloaded. Restores the pivot grid layout from the specified string, using the specified settings.
Public methodStatic member MakeResponseCompressed Overloaded. Specifies that the response code (the HTML code of the web page) should be compressed on the server before sending it to the client. (Inherited from ASPxWebControl)
Public method MergeStyle Copies any nonblank elements of the specified style to the Web control, but will not overwrite any existing style elements of the control. This method is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Public methodStatic member RedirectOnCallback Redirects a client to a new URL while processing a callback. (Inherited from ASPxWebControl)
Public methodStatic member ReferenceEquals Determines whether the specified System.Object instances are the same instance. (Inherited from System.Object)
Public methodStatic member RegisterBaseScript Overloaded. Registers base scripts required to embed an ASPxPivotGrid control onto the specified page. (Inherited from ASPxWebControl)
Public method RegisterClientIncludeScripts For internal use only. (Inherited from ASPxWebControl)
Public method RegisterClientScriptBlocks Registers the required client-side script blocks. (Inherited from ASPxWebControl)
Public method RegisterClientScripts Registers the required client-side scripts. (Inherited from ASPxWebControl)
Public method RegisterStyleSheets For internal use only. (Inherited from ASPxWebControl)
Public methodStatic member RegisterUtilsScript Obsolete. Registers utils scripts required to embed an ASPxPivotGrid control onto the specified page. (Inherited from ASPxWebControl)
Public method ReloadData Reloads the ASPxPivotGrid's data.
Public method RenderBeginTag Renders the HTML opening tag of the control to the specified writer. This method is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Public method RenderControl Outputs server control content to a provided System.Web.UI.HtmlTextWriter object and stores tracing information about the control if tracing is enabled. (Inherited from System.Web.UI.Control)
Public method RenderEndTag Renders the HTML closing tag of the control into the specified writer. This method is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Public methodStatic member RequireClientLibrariesRegistering Specifies whether client library registration is required. (Inherited from ASPxWebControl)
Public method ResetViewStateStoringFlag For internal use only. (Inherited from ASPxWebControlBase)
Public method ResolveClientUrl Gets a URL that can be used by the browser. (Inherited from ASPxWebControlBase)
Public method ResolveUrl Converts a URL into one that is usable on the requesting client. (Inherited from System.Web.UI.Control)
Public method RetrieveFields Overloaded. Creates PivotGridField objects for all the fields in the bound data source, and moves the fields to the specified area, making them visible or hidden.
Public method SaveCollapsedStateToStream Saves the collapsed state of field values to the specified stream.
Public method SaveCollapsedStateToString Saves the collapsed state of field values to the specified string.
Public method SaveLayoutToStream Overloaded. Saves the pivot grid layout to the specified stream, using the specified settings.
Public method SaveLayoutToString Overloaded. Saves the pivot grid layout to the specified string, using the specified settings.
Public methodStatic member SetCallbackErrorMessage Specifies the message text to be displayed for remote clients when a DevExpress control callback error has occurred. (Inherited from ASPxWebControl)
Public method SetClientSideEventHandler Defines a handler for the specified client event. (Inherited from ASPxWebControl)
Public method SetDefaultBooleanProperty For internal use only. (Inherited from ASPxWebControl)
Public methodStatic member SetIECompatibilityMode Overloaded. Switches all DevExpress controls on the specified page to use the specified IE version. (Inherited from ASPxWebControl)
Public methodStatic member SetIECompatibilityModeEdge Overloaded. Switches all DevExpress controls on the specified page to use the latest IE version. (Inherited from ASPxWebControl)
Public method SetRenderMethodDelegate Assigns an event handler delegate to render the server control and its content into its parent control. (Inherited from System.Web.UI.Control)
Public method SetTraceData (Inherited from System.Web.UI.Control)
Public method SetViewStateStoringFlag For internal use only. (Inherited from ASPxWebControlBase)
Public method ToString Returns a System.String that represents the current System.Object. (Inherited from System.Object)
Public method UseCachedObjects For internal use ony. (Inherited from ASPxWebControl)
Public method XtraFindFieldsItem For internal use only.
Top

Expanded See Also

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