To select the fields used in the report:
Click a field in the Available Fields
list.
Note: If the Displayed Fields
list is empty, it means that currently there are no fields selected to appear
in the report output. You must have at least one field in the Displayed
Fields list before proceeding to another page of the wizard.
Click the right arrow (>) to move the selected field to the Displayed
Fields list.
Note: Reports Builder retrieves all of the columns specified
in the reports queries, but only those shown in the Displayed Fields
list will appear in the report output.
Repeat Steps 1 and 2 for all of the fields that you want to appear in the report.
(Optional) To remove a field from the Displayed Fields list, click it then click the left arrow (<).
Unsupported are identified with when the data type
is selected in a query.
If you move a column object or Ref column from the Available Fields list to the Displayed Fields list, all of its attribute columns are moved to the Displayed Fields list and the column object or Ref column disappears. Column objects cannot be the source of a layout object and are therefore excluded from the Displayed Fields list. Attribute columns in the Displayed Fields list use underscore notation to indicate their parentage (for example, ADDRESS_ZIP).
Copyright © 1984, 2005, Oracle. All rights reserved.