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
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

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

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"

Concepts

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

Layout

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.