Introduction
Introduction
Highlighted Features
Highlighted Features
Sample Reports
Sample Reports
Summary
Summary
Data Shaping Features
Data Shaping Features
Appearance & Layout
Appearance & Layout
OLAP
OLAP
OLAP Drilldown
Templates
Templates
To learn more about other
Developer Express ASP.NET Components
Visit: www.devexpress.com/WebForms/


Country
City
Quantity
Discount
Drop Column Fields Here
Category Name
Products
Grand Total
QuantityDiscount
Beverages953225
Condiments529811.37
Confections790619.02
Dairy Products914919.56
Grains/Cereals45628.880001
Meat/Poultry419911.15
Produce29906.180001
Seafood768119.88
Grand Total51317121.04
Description
C#
VB
ASPX
JS

This demo shows how to retrieve records that were used to calculate a particular summary 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 should specify the data field's index, row and column indices 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.

In this demo, click a summary cell to view the records from the control's underlying data source associated with this cell. The obtained data is displayed by the ASPxGridView within a popup window.