Matrix column field values appear across the top of the matrix.
To specify the columns for a matrix report:
Click a field in the Available Fields list.
Click the right arrow (>) to move the field to the Matrix
Column Fields list. A line defining the field’s break level appears
above it.
Note: The Level 1 matrix column field appears as the outermost column
across the top of the matrix. The Level 2 field appears below the Level
1 field, the Level 3 field appears below the Level 2 field, and so on.
Click the plus and minus signs 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 desired matrix column fields.
(Optional) To remove a field from the Matrix Column Fields list, click the field, then click the left arrow (<).
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 used as matrix column fields. Therefore you cannot select them from the Available Fields list.
Attribute columns in the Matrix Column Fields list use underscore notation to indicate their parentage (for example, ADDRESS_ZIP).
Copyright © 1984, 2005, Oracle. All rights reserved.