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 >>