Working with Crosstabs
A crosstab is a statistical component that summarizes categorical data in one or more row and column groups in a concise format for analysis or reporting, optionally with hierarchical structure. It usually represents the joint distribution of two or more variables in compact row and column format. Crosstabs are widely used in business intelligence, engineering, survey, and scientific research. This topic introduces how you can insert and modify crosstabs in reports and use crosstab formulas to get the data your want.
Report also provides a unique compound crosstab that enables you to put multiple crosstabs together in a very flexible structure. This makes far more sophisticated crosstab analysis possible. However, you can only use compound crosstabs in query-based page reports.
The following topics discuss crosstabs in further detail:
See an example: The SampleComponents catalog, included with Designer, contains reports that have examples of how you could use each component type in a report. For the crosstab component example, open <install_root>\Demo\Reports\SampleComponents\Crosstab.cls
.