About cross tabs
A cross tab displays data in a row-and-column matrix that has a spreadsheet-like appearance. The cross tab is ideal for summarizing data in a compact and concise format, and displays summary, or aggregate, values such as sums, counts, or averages. The cross tab groups these values by one set of data listed down the left side of the matrix and another set of data listed across the top of the matrix.
Figure 7-1 shows a cross tab that displays sales totals by state and by product line.
Figure 7-1  
The cross tab uses data from the state, product line, and extended price fields. A cross tab typically uses data from at least three fields as follows:
*
One field populates the column headings in the cross tab. There is one column for each unique value in the field. In the example, as shown in Figure 7-1, four unique values from the productline field—Classic Cars, Motorcycles, Trucks and Buses, and Vintage Cars—appear in an area called the column area.
*
*
You can use BIRT Studio to insert a cross tab in a report design, select data for the cross tab, and specify the aggregate data to display. You can also define a bookmark for a cross tab, and then create a hyperlink from another report that links to the bookmarked cross tab element. For more information on creating bookmarks and hyperlinks, see Adding interactive viewing features.
In addition, you can use Actuate BIRT Data Analyzer, which requires a separate license, to edit data in the cross tab, format the data values, and modify cross tab data. You can access Actuate BIRT Data Analyzer from BIRT Studio and Interactive Viewer.

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2