6.5.1 Creating a Crosstab Using the Data Binding Wizard
A Crosstab summarizes information in a tabular format. It displays the values from one or more fields as row headers, and from one or more fields as column headers. At the intersections of the row and columns, the Crosstab displays the aggregate values computed from a measure field for the records that match the row and column headers.
For example, consider the following result set:
Customer |
Product |
Quantity |
Customer1 |
Product1 |
1 |
Customer1 |
Product1 |
2 |
Customer1 |
Product2 |
30 |
Customer2 |
Product1 |
4 |
Customer2 |
Product2 |
50 |
Customer2 |
Product2 |
60 |
If you use the 'Customer' column as the row header, the 'Product' column as the column header, and the 'Quantity' column as the aggregated measure, the resulting Crosstab appears as follows:
|
Product1 |
Product2 |
Customer1 |
3 |
30 |
Customer2 |
4 |
110 |
It is possible to report the same information by using a regular table with grouping on both the 'Customer' and 'Product' columns and summarization on 'Quantity' column. However, the Crosstab presentation is often more readblae.
| << 6.5 Binding Data to a Crosstab Element | © 1996-2013 InetSoft Technology Corporation (v11.5) | Walkthrough: Creating a Crosstab using Data Binding Wizard >> |