How to export data and grid to Excel from Pivot Grid? Export option is not available via right-click of this grid.
Exporting from Pivot Grids is not available. Open a standard data grid from Data tab of Object Explorer and right-click on this grid. This menu will allow exporting to Pivot Table in Excel which will export both the grid and data.