Skip Headers
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)

Part Number B32122-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

10 Building a Single-Query Group Report

In this chapter, you will learn about single-query group reports. By following the steps in this chapter, you can generate the report output shown in Figure 10-1.

Figure 10-1 Group report output

Description of Figure 10-1 follows
Description of "Figure 10-1 Group report output"


Group left and group above reports divide the rows of a report into "sets," based on common values in one or more of the columns, such as the department number in the preceding example. Notice that each department number prints only once. If the report above was not a group report, the department number would print once for each employee in the department rather than just once for the whole department.


This type of report may also be referred to as a break report or a master/detail report.

Example Scenario

In this example, you will create a group left report that lists employees with their jobs and salaries by department. As you build this example report, you will:

Then, you will add another column to the break group:

Then, you will add a second break group:

To see a sample across report with control breaks, open the examples folder called break, then open the Oracle Reports example report named grp_lft2.rdf. For details on how to open it, see "Accessing the Example Reports" in the Preface.