The PivotGrid displays data fetched from the data source in the form of Pivot tables. PivotGrid can be bound to a data source for populating it with an ordered dataset. The control provides automatic data binding with PivotPanel objects, grouped row and column headers, and custom behaviors for resizing columns, copying data to the clipboard, and showing details for a given cell.

 

Extending the features of PivotGrid control, the PivotGrid control allows users to export the grid content to Excel sheet or use styles and owner-draw cells to customize the grid's overall appearance. For more information about PivotChart, see QuickStart:Add Data to OLAP topic.