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

16.5 Add White Space and Format Fields

The only task that remains now is to make your report a little more readable by adding some white space between records and formatting values properly.

  1. In the Paper Design view, select the first department number value, which should be 10. All of the department numbers are immediately selected indicating that you can change their properties simultaneously.

  2. Click the Align Center button in the toolbar.

  3. Click the Select Parent Frame button in the toolbar.

  4. Choose Tools > Property Inspector to display the Property Inspector, and set the following property:

    • Under Repeating Frame, set the Vert. Space Between Frames property to 0.25.

  5. Click the title bar of the Paper Design view.

  6. Select the first number value underneath the Salary label.

  7. Shift-click the department summary value for the first department.

    Tip:

    If you are familiar with format mask syntax, you could now right-click the field values, choose Property Inspector, and choose or manually enter a value for the Format Mask property.

  8. Click the Currency button in the toolbar. A currency symbol immediately appears next to all of the values.

  9. Click the Add Decimal Place button twice. Two decimal places are added to the right of the decimal point.

  10. Resize the salary field (F_SALARY) by clicking and dragging its rightmost handle approximately 0.5 inches (1.5 centimeters) to the left. Notice that even though the summary field (F_SumSALARYPerDEPARTMENT_ID) is also selected, only F_SALARY is resized.

  11. Shift-click the Salary label itself.

  12. Click the Align Right button in the toolbar. All of the values are immediately right aligned.

    Tip:

    The steps above have formatted all of the salaries and the department summary of your report. The report summary (the summary of all salaries in the report), however, is not yet formatted. You can find the report summary on the last page of the report and format it using the same techniques as above.

    Figure 16-5 Group left report output with values formatted

    Description of Figure 16-5 follows
    Description of "Figure 16-5 Group left report output with values formatted"