Files to look at:

How to Create the Underlying Data Source (Drill-Down) in an Asynchronous Operation

This example performs an asynchronous operation that creates a drill-down data source for the selected PivotGrid cell and gets the operation result - the underlying data source.

In this example, the PivotGrid control is bound to the LinqServerModeSource data source and operates in server mode.

The PivotGridControl.CellClick event handler calls the PivotGridControl.CreateDrillDownDataSourceAsync method to generate a drill-down data source for the selected cell. The method parameter specifies the number of records to return. The method also specifies the columns to add to the the data set.

The last item in the method's parameter list is the AsyncCompletedHandler delegate. The delegate is executed when the operation is complete. The delegate's result parameter is the AsyncOperationResult instance whose Value property contains the result of the operation.

The operation's result is casted to the PivotDrillDownDataSource and the GridControl displays the underlying records in the auxillary DrillDown form.

screenshot