Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

OLAP Drill Down

Click on the Cell to Get the Drill Down Result.

This demo shows how to retrieve records that are used to calculate summaries for individual cells when the ASPxPivotGrid is bound to an OLAP server. Click a summary cell to view records from the control's underlying data source associated with this cell. The retrieved data is displayed by the ASPxGridView within a popup window.

To obtain drill-down data, use the pivot grid's CreateDrillDownDataSource method. You need to specify the data field index, row and column indexes to completely identify the required summary cell.

Note: Since drill-down data is provided by the OLAP server, the drill-down datasource can have some extra columns even if you don't have any corresponding fields in the ASPxPivotGrid control. The OLAP server can also return identity values.

See Also:
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos