This topic describes the steps to create a cross-tab report using a Pivot Grid control that calculates automatic summaries and grand totals across a large number of grouped rows and columns. This feature should not be confused with the Master Detail Report or Table Report.

1. Create a new report.
2. Drop the Pivot Grid control from the Toolbox onto the report's Detail band. Please note that you cannot place a Pivot Grid within another report control.
3. To bind the pivot grid to a data source, click its Smart Tag, and in the invoked actions list, expand the Data Source drop-down selector and select the NewDataSet. Its Data Member property defines from which table or view of your dataset the grid obtains its data. And, the Data Adapter property is auto-defined, as well.
4. Click the grid's Smart Tag, and in the invoked actions list, click the Run Designer...
5. In the invoked Pivot Grid Designer's Fields, click the Retrieve Fields   button to obtain fields from the control's data source.
6. Switch to the Layout page in the navigation bar on the left.
7. Drag and drop the required fields to the Row Fields, Column Fields and Data Items
8. Click Apply and the close the editor.
9. In the last step, you can set your report's Vertical Content Splitting option to Smart. This will split the grid's columns precisely by their borders in the Print Preview.
10. Switch to the Print Preview Tab, and view the result.