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
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.
To create this type of report you need to build a data model with two groups.
A formula column in the detail group returns the value of the group column. The formula column is moved to the middle position of its group.
This report uses a group above layout. In the Paper Layout view, the break column is deleted from its defaulted position.
A format trigger is created to suppress redundant printing of the formula column group value in the detail group.
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:
Create a Data Model and a Layout using the Report Wizard.
Add a Formula Column to the detail group.
Add a Field in the Report Wizard.
Remove a Redundant Field in the Paper Design view.
Suppress Redundant Valuesin a Format Trigger.
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.