Sometimes we need to display a report in cross tabular format. Crosstab is nothing but a special type of table component in which both the rows and the columns are dynamic. They are used to summarize and visualize data in a compact form with multiple levels of grouping for both columns and rows.

Suppose you want to create a report that shows Revenues for computer sales of different years.

For that, first add the query in your report as shown below.

Figure 9

Now use the following steps to create a crosstab report.

Steps 1

Add crosstab from the menubar in the summary section. It will show the following dialog box. Select “Available Subdataset” or you can create a new Subdataset. Now click the next button.

Figure 10

Steps 2

It will show the following dialog box. Select row group 1 and row group 2 and click the next button in the following dialog box.

Figure 11

Steps 3

It will show the following dialog box. Select column group 1 and column group2 and click the next button in the following dialog box.

Figure 12

Steps 4

It will now show the following dialog box. Select detail field and function to show the result. Now click the next button.

Figure 14

Steps 5

It will show the following dialog box. You can make the “Add row group totals” and the “Add column group totals” check boxes checked to display the total of each row and each column respectively in your report.

Figure 15

Steps 6

Now click the “finish” button and run the report. It generates a report as shown below.

Figure 16

Crosstab must be placed in the summary section.