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

25.5 Format Monetary Values

To make your report easier to read, you can add formatting to 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. Shift-click one of the summary values at the bottom of a column of the matrix.

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

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

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

  6. Shift-click the SALESMAN label.

  7. Click the Align Right button in the toolbar.

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

  9. Click one of the department summaries at the end of a row in the matrix. All of the department summaries are immediately selected.

  10. Shift-click the report summary underneath the department summaries.

  11. Use the left arrow key to move these summaries to the left until they are approximately flush with the SALESMAN column in the matrix.

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

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

  14. Resize the fields. Click and drag the rightmost handle of one of the selected fields about 0.5 inches (1.5 centimeters) to the left.

  15. Click the Align Right button in the toolbar.

Figure 25-9 Matrix report in Paper Design view with monetary values formatted

Description of Figure 25-9 follows
Description of "Figure 25-9 Matrix report in Paper Design view with monetary values formatted"