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

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

Go to previous page
Go to next page
View PDF

26.5 Format Monetary Values

To make your matrix report more readable, you should format the monetary values.

To format monetary values:

  1. On the first page of the report, click one of the cell values. Notice that all of the values are immediately selected, indicating that you can change their properties simultaneously.

  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 in the toolbar twice. Two decimal places are added to the right of the decimal point.

  4. Resize the fields. Click and drag the rightmost handle of the cell value under the SALESMAN label about 0.5 inches (1.5 centimeters) to the left. After you complete this operation, the department summaries from the second page should move onto the first page.

  5. Shift-click the SALESMAN label.

  6. Click the Align Right button in the toolbar.

  7. Click in an open area of the Paper Design view to deselect all of the objects.

    Figure 26-17 Nested matrix report output with formatted monetary values

    Description of Figure 26-17 follows
    Description of "Figure 26-17 Nested matrix report output with formatted monetary values"

  8. Save your report as nested3_your_initials.rdf