A group field is used to break the data in your report into masters and details (also called parents and children). A group field appears in a master group and, for each record of the master group, a corresponding detail record is retrieved.
You may have more than one level of groups and more than one group in a level. For example, selecting both the manager's name and the employee's department as Level 1 groups results in a report that has the manager's name and the department number used as the identifier for the group.
To specify the group field(s):
Click a field in the Available Fields list that you want to make a group field.
Click the right arrow (>) to move the
selected field to the Group Fields
list. A line defining the field’s break level appears above it.
The first field selected will be placed in level 1. The plus and minus signs
allow you to expand and collapse the levels. If all existing levels are
collapsed, adding a field will add a level. You can change the order within
a level by clicking and dragging the field up or down.
Repeat Steps 1 and 2 for all of the matrix group fields you want in the report.
(Optional) Click a field in the Group Fields list and drag it to the desired break level.
(Optional) To move a field out of the Group Fields list, click it then click the left arrow (<).
If you want two columns to be in the same break level, click a column in the Group Fields list, then move a column from the Available Fields list to automatically place it in the same break level as the selected column. If you want to create a new break level, click a column in the Available Fields list, click a break level in the Group Fields list, and move the column from the Available Fields list. The column is automatically placed in a new break level beneath the selected break level.
Not all Oracle database datatypes are supported at this time.
will identify the datatype as unknown in the wizard if your query selects
an unsupported Oracle database datatype.
Column objects and Ref columns cannot be break columns. Therefore, you cannot select them in the Available Fields list.
Attribute columns in the Group Fields list use underscore notation to indicate their parentage (for example, ADDRESS_ZIP).
Copyright © 1984, 2005, Oracle. All rights reserved.