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

19.5 Set Properties and Format Fields

To set properties and format the fields of your report:

  1. In the Object Navigator, click the Paper Layout node and click the Expand All button in the toolbar.

  2. Double-click the repeating frame icon next to the R_G_ENAME node to display the Property Inspector, and set the following properties:

    • Under Repeating Frame, set the Maximum Records per Page property to 1.

  3. In the Object Navigator, double-click the repeating frame icon next to the R_G_CUSTID1 node to display the Property Inspector, and set the following properties:

    • Under Repeating Frame, set the Vert. Space Between Frames property to 0.25 to specify 0.25 inches (0.5 centimeters) of vertical space between instances of the repeating frame; that is, between each customer record.

    • Under General Layout, set the Page Protect property to Yes to specify that the first instance of the repeating frame (that is, the first customer record) must all fit on the same logical page.

  4. In the Object Navigator, click the F_CREDITLIMIT node, then Ctrl-click F_AMOUNT to select both nodes.

  5. Click the Paper Design button in the toolbar to make the Paper Design view the active window, with the F_CREDITLIMIT and F_AMOUNT fields selected, and make the format changes (you can also click the corresponding buttons in the toolbar):

    • choose Format > Number > Currency

    • choose Format > Number > Add Decimal Place

    • choose Format > Number > Add Decimal Place (again, for two decimal places)

    • choose Format > Justify > Right

  6. In the Paper Design view, click the Amount label (column heading), and choose Format > Justify > Right.