To create a heading that includes database values (column objects):
Choose ToolsReport
Wizard to re-enter the Report Wizard for the current report.
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.
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.
In the Paper Layout view, click 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.
For any values that require a format mask, create a hidden field object in the margin area:
In the Property Inspector, under the Field node, set the Source property to the source column for the value, set the Visible property to No, and set the Format Mask property as desired.
Under the General Layout node, set the Horizontal Elasticity property to Variable.
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.
"Building a Header with Database Values Report" chapter in the Oracle Reports Building Reports manual.
Copyright © 1984, 2005, Oracle. All rights reserved.