A script-enabled browser is required for this page to function properly.

Creating a heading that includes database values

To create a heading that includes database values (column objects):

  1. Choose Toolsright arrowReport Wizard to re-enter the Report Wizard for the current report.

  2. On the Totals page, create any totals that you want to include in the heading. Note: any totals that you intend to place in the margin area of your report must be report-level totals. Group totals (for example, the total for a department) placed in the margin will cause a frequency error when you run your report.

  3. On the Fields page, verify that the fields and totals you want to include in the heading are either available or displayed in the report.

  4. In the Paper Layout view, click the Margin button in the toolbar. Note:   The margin area is defined by a thick black line that separates it from the body. If you create objects in the body portion of a report while displaying the margin area, you can only edit those objects when the margin is displayed.

  5. For any values that require a format mask, create a hidden field object in the margin area:

    Note: if you do not need to specify a format mask, you can simply reference the value directly in Step 6, and you do not need to create this hidden field.

  6. Create a boilerplate text object in the margin area, and reference the field or report-level totals you want to include in the heading.

See also

"Building a Header with Database Values Report" chapter in the Oracle Reports Building Reports manual.