To specify the cell fields for a matrix report:
Click a field in the Available Fields list.
Click the appropriate button for the function you want to apply to the
field. An entry with the field and function name appears in the Matrix
Cell Fields list.
Note: If you do not want to apply a function to the field, you can
click the right arrow (>) to move the field into the Matrix
Cell Fields list without applying a function. This is useful when your
query already performs a function on the field’s source column, for example, SUM(SAL)
and you do not need to apply another function to it.
Repeat Steps 1 and 2 for all of the desired matrix cell fields.
(Optional) To remove a field from the Matrix Cell 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 cell fields. Therefore you cannot select them from the Available Fields list.
Attribute columns in the Matrix Cell Fields list use underscore notation to indicate their parentage (for example, ADDRESS_ZIP).
Copyright © 1984, 2005, Oracle. All rights reserved.