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

9.3 Format Fields

In the Paper Design view, notice the Total field. The values are neither aligned nor displayed as monetary amounts. You can quickly rectify this in the Paper Design view.

To assign a format mask to monetary values:

  1. In the Paper Design view, select the first number value underneath the Dollars label. Notice that all of the values are immediately selected, indicating that you can change their properties simultaneously.

    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.

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

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

  4. Resize the field by clicking and dragging the rightmost handle of the field approximately 0.5 inches (1.5 centimeters) to the left.

  5. Click the Align Right button. All of the values are immediately right aligned.

  6. Select the Dollars label itself.

  7. Click the Align Right button.

  8. Select the number value to the right of the Total: label.

  9. Click the Currency button. A currency symbol immediately appears next to all of the values.

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

  11. Click the Align Right button. All of the values are immediately right aligned.

    Figure 9-4 Summary report output with monetary values formatted

    Description of Figure 9-4 follows
    Description of "Figure 9-4 Summary report output with monetary values formatted"

  12. Go to the end of the report. The last value on the last page should be a summary labelled Total:, which sums the values of TOTAL across the entire report.

  13. Select the unformatted number to the right of the Total: label.

  14. Click and drag this field until its right edge is aligned with the right edge of the values in the Total column.

  15. Click the Currency button in the toolbar. A currency symbol immediately appears next to the Total value.

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

  17. Click the Align Right button. All of the values are immediately right aligned.

  18. Save the report as summaryb_your_initials.rdf.

    Figure 9-5 Summary report with report total formatted

    Description of Figure 9-5 follows
    Description of "Figure 9-5 Summary report with report total formatted"