Skip Headers
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)

Part Number B32122-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

20.3 Add a Formula Column

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:

  1. Click the Data Model tool in the toolbar to display the Data Model view.

  2. In the Data Model view, resize the G_ENAME group to be large enough to contain a third column.

  3. Click the Formula Column tool in the tool palette.

  4. Click in the G_ENAME group to create a formula column.

  5. 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.

  6. In the PL/SQL Editor, at the flashing cursor (after the word begin), type the following:

    return(:dname);
    
  7. Click Compile.

  8. Click Close.

  9. Click the title bar of the Report Editor to make it the active window again.