9 Building a Summary Report

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

Figure 9-1 Summary report output

Description of Figure 9-1 follows
Description of "Figure 9-1 Summary report output"


A summary report contains at least one column whose value or values consist of a summary of other data. A column that totals sales, a column that averages a list of commissions, and a column that shows the maximum amounts found in a series of purchase orders are all examples of summary columns.

Data Relationships


This report uses a master/detail layout style.

Example Scenario

In this example, you will create a report that displays and summarizes sales data by sales representative. This report includes the following summaries:

As you build this example report, you will:

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