20 Building an Intermixed Fields Report

In this chapter, you will learn about reports that display group fields in different positions. By following the steps in this chapter, you can generate the report output shown in Figure 20-1.

Figure 20-1 Group with master record in the middle of report output

Description of Figure 20-1 follows
Description of "Figure 20-1 Group with master record in the middle of report output"


Normally, a group (break) field appears to the left of (in group left report) or above (in group above report) its related fields. In this example, the group field appears between its related fields.

Data Relationships


Example Scenario

In this example, you will create a report that displays salary data by employee and department. Your users have indicated to you that they prefer the group value (that is, department name) to appear in the middle of the layout with employee names to the left and employee salaries to the right.

As you build this example report, you will:

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