Create a Cross-Tab Report
A cross-tab report displays complex multi-dimensional data, such as summary statistics, surveys, and market research information. This report uses a Pivot Grid control that calculates automatic summaries and grand totals across grouped rows and columns.
Add a Pivot Grid and Bind It to Data
Open the Toolbar's Pivot Grid Tools contextual tab and click Add Data Source to bind the pivot grid to data.
After the data source is created, the Pivot Grid's Data Source and Data Member properties are assigned automatically.
Ensure that a report's Data Source property is not set if you place the Pivot Grid in the Detail band. Otherwise, the Pivot Grid data is printed as many times as there are rows in the report data source.
Define the Pivot Grid's Content
Customize the Pivot Grid's layout. To do this, switch the Pivot Grid Tools toolbar tab and click Run Designer.
In the Pivot Grid Designer's Fields page, click the Retrieve Fields button to obtain fields from the control's data source.
Switch to the Layout page in the navigation bar on the left and drag-and-drop the required fields onto the appropriate areas to define the Pivot Grid's layout.
Click Apply to apply the changes and close the Designer.
To see how the pivot grid looks when it is populated with data, switch to the report's Preview.
Return to the Report Designer and invoke the Pivot Grid Designer. The pivot grid fields are now populated with actual data and you can customize the grid.
Adjust the Pivot Grid's Layout
Set the report's Vertical Content Splitting property to Smart to split the Pivot Grid along the column borders if it does not fit the report's page in Print Preview.
Specify the Pivot Grid's Print Options
Use the Pivot Grid Tools toolbar tab's Print Options section to specify print options and define which Pivot Grid elements are printed.
Disable the Data Headers option to prevent data fields' headers from being printed.
Enable the Row Area On Every Page option to repeat row headers on each document page when the Pivot Grid's layout is divided horizontally across several pages.
Switch to Print Preview to see the resulting report.