This part of the manual explains how you can build various kinds of matrix reports.
A matrix report looks like a grid. As shown in the sample output below, it contains one row of labels, one column of labels, and information in a grid format that is related to both the row and column labels. (Matrix reports are also sometimes referred to as "crosstab" reports.)
In this example, you will build a matrix report that contains three additions to the basic matrix: summaries have been added, zeroes replace non-existent values in the cells, and the cells themselves are surrounded by grid lines. Of the summaries, one sums the salaries by department, one sums them by job, and one sums them for the whole report.
For more information on building this example, refer to Chapter 25, "Building a Matrix Report".
In this example, you will build the nested matrix report shown below. The cross product is capable of displaying every possible value for three dimensions: two down (YEAR and DEPTNO) and one across (JOB). This method does not include rows that have null values.
For more information on building this example, refer to Chapter 26, "Building a Nested Matrix Report".
In this example, you will build a report that shows department, job, and salary information for each employee by the year they were hired using a matrix break format.
For more information on building this example, refer to Chapter 27, "Building a Matrix with Group Above Report".