25 Building a Matrix Report

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

Figure 25-1 Matrix report output

Description of Figure 25-1 follows
Description of "Figure 25-1 Matrix report output"


Example Scenario

In this example, you will create report that cross tabulates salaries by job function and department. The result would be a matrix with job functions listed across the top, departments down the side, and sums of salaries in the cells. Thus, you could quickly determine the sum of all of the salaries for clerks in department 20 and compare that value to the one for all clerks in some other department.

As you build this example report, you will:

To see a sample matrix report, open the examples folder named matrix, then open the Oracle Reports example named matrix1qb.rdf for a single-query matrix report, or matrix3qb.rdf for a multi-query matrix report. For details on how to access these reports, see "Accessing the Example Reports" in the Preface.