Matrix reports can be created by using the Reporting System command language. Matrix reports are not supported by the GUI Report Editor; therefore, they must be created in a text editor (see Using the Text Editor to edit or add a report).

The MATRIX command is used to specify a matrix report. Together, the COLUMN command and the ROW command specify the name, and format, of each printed row and column. Together, the CELL command and the VALUE command specify the value, and format of the value, that appears in the cell that is formed at the junction of each column and row.

The physical size of the cells that make up the matrix report is determined by the commands shown in this figure:

For details on the relevant commands and subcommands, see:

The WHERE command specifies extraction criteria, and the NEWPAGE command specifies page breaks.

An example of a typical Matrix report, for data in the Entity Called Book, is shown below.