27 Building a Matrix with Group Above Report

In this chapter, you will learn about nested matrix with group above reports. By following the steps in this chapter, you can generate the report output shown in Figure 27-1.

Figure 27-1 Matrix with group above report output

Description of Figure 27-1 follows
Description of "Figure 27-1 Matrix with group above report output"


Data Relationships

This example of a matrix with group above report uses one query and at least five groups. At least one group is placed above the cross product to serve as the Master group.


This report uses the Matrix with Group layout style.

Example Scenario

In this example, you will create report that cross tabulates salaries by department and by job for each year. The result is a group report where year is the master and the detail is a matrix with job functions listed across the top, departments down the side, and sums of salaries in the cells. Thus, you can quickly determine the sum of all of the salaries for clerks in department 20 for any particular year.

As you build this example report, you will:

To see a sample matrix with group above report, open the examples folder named matrixgroup, then open the Oracle Reports example named matrixgroup.rdf. For details on how to access it, see "Accessing the Example Reports" in the Preface.