Working with Cross Table Items in Report Designer

Working with Cross Table Items in Report Designer

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.

Columns


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

Rows


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

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

    • Related Articles

    • Understanding Cross Tables in Report Designer

      The articles in this section of the Knowledge Base involve working with Cross Tables for display in reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report from ...

    • Using the Min Rows in Column Property in Report Designer

      The articles in this section of the Knowledge Base involve working with Columns for display in multi-column reports. To learn more about Columns and how to access the Report Designer, see Creating Multi-Column Reports in Report Designer. This article ...

    • Adding Alternating Rows to Lists in Report Designer

      The articles in this section of the Knowledge Base involve working with Lists for display in your reports. To learn more about Lists and how to access the Report Designer, see Creating Lists in Report Designer. This article provides information on ...

    • Using the Column Header Band in Report Designer

      The articles in this section of the Knowledge Base involve working with Columns for display in multi-column reports. To learn more about Columns and how to access the Report Designer, see Creating Multi-Column Reports in Report Designer. This article ...

    • Creating Multi-Column Reports in Report Designer

      The articles in this section of the Knowledge Base involve working with Columns for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report from ...

    • Recent Articles

    • Toolbox Release Notes | Build 25.1.0114.641

      The following release notes apply to Toolbox build 25.1.0114.641. UI Fixes Several issues were reported and discovered within the OEM 2025 user interface. The following issues have been resolved: Fig. 1: Excess commands on the tool strip being ...

    • Toolbox Release Notes | Build 25.1.102.641

      The following release notes apply to Toolbox build 25.1.102.641 Toolbox OEM 2025 Work smarter, and faster with Toolbox 2025 (OEM). With an OEM Subscription, you’ll gain access to the latest toolsets and innovative features of Toolbox 2025. ...

    • What’s New in Toolbox 2025 (OEM)

      Work smarter, faster with Toolbox 2025 (OEM). With an OEM Subscription, you’ll gain access to the latest toolsets and innovative features of Toolbox 2025. Improvements Toolbox UI Overhaul OEM 2025 introduces several updates to the appearance and ...

    • Toolbox Release Notes | Build 24.1.1206.641

      The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...

    • Microvellum Foundation Library Release Notes | Build 24.1127

      The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...