The articles in this section of the Knowledge Base involve working with the Cross Table component for display in reports. To learn more about Cross Tables, and how to access the Report Designer, see Understanding Cross Tables in Report Designer. This article details Cross Table Items.
​

​

Fig. 01 – Cross Table – Columns
​

​

Figure 01 features a one-column Cross Table.
​

​

Fig. 02 – Columns Section of the Cross-Tab Data Editor – One Column
​

​

As a result of having one column specified, the grouping is established by the values of this column.
​

​

Fig. 03 – Column Grouping
​

​

When more than one column is specified:
​

​

Fig. 04 – Columns Section of the Cross-Tab Data Editor – Two Columns (Product Name and Subassembly Name)
​

​

Grouping is rendered by the values of two columns from the Data Source. Values in the first column are output first. Values from the second column are output second:
​

​

Fig. 05 – Column Grouping – Two Columns
​

​

Columns can be rotated using the angle property.
​

​

Fig. 06 – Angle Property
​

​

Fig. 07 – Cross Table – Rows
​

​

Figure 07 features a one row Cross Table. This one specified value determines the grouping.
​

​

Fig. 08 – Rows Section of the Cross-Tab Data Editor – One Row
​

​

All of the values of the specified row are represented on one level.
​

​

Fig. 09 – Row Grouping
​

​

Specify two rows:
​

​

Fig. 10 – Rows Section of the Cross-Tab Data Editor – Two Rows (Products Name and Subassemblies Name)
​

​

A Cross Table is grouped in two levels vertically:
​

​

Fig. 11 – Row Grouping – Two Rows
​

​

In a Cross Table, you do not have to have both a column and a row. For example, when a column is not specified, then grouping is done by rows. Figure 12 features an example of one of these reports:
​

​

Fig. 12 – Two Row Cross Table Example
​

Summary cells set the rules for a cell’s formatting on the intersection of columns and rows.
​

​

Fig. 13 – Cross Table – Summary Cells
​

​

All values from the Data Source that are suitable for a particular condition are grouped in a Summary cell. The value of a Cross Table row and column is indicated by the intersection where the summary cell is placed.
​

​

Fig. 14 – Intersection of Rows and Columns – Summary Cells
​

​

The red rectangle indicates the summary cell where the Product and the Subassembly meet. This can be read as a “1 Door Base Curved Front” has 1 “Carcass Base Curved Front.” The rules of the grouping can be set with the Summary property of a summary cell.
​

​

Fig. 15 – Summary Property
​