Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports 11g Release 1 (11.1.1) B32122-01 |
|
Previous |
Next |
To have the department names appear in the center of this group report, it is simplest to have a column in the detail group for the department names. To achieve this result, you must create a formula column in the detail group that will display the department names.
To add a formula column:
Click the Data Model tool in the toolbar to display the Data Model view.
In the Data Model view, resize the G_ENAME group to be large enough to contain a third column.
Click the Formula Column tool in the tool palette.
Click in the G_ENAME group to create a formula column.
Double-click the new formula column object (CF_1) to display the Property Inspector, and set the following properties:
Under General Information, set the Name property to DEPARTMENT.
Under Column, set the Datatype property to Character, and set the Width property to 14.
Under Placeholder/Formula, double-click the PL/SQL Formula property field to display the PL/SQL Editor.
In the PL/SQL Editor, at the flashing cursor (after the word begin
), type the following:
return(:dname);
Click Compile.
Click Close.
Click the title bar of the Report Editor to make it the active window again.