|Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)
Part Number B32122-01
To set properties and format the fields of your report:
In the Object Navigator, click the Paper Layout node and click the Expand All button in the toolbar.
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.
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.
In the Object Navigator, click the F_CREDITLIMIT node, then Ctrl-click F_AMOUNT to select both nodes.
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
In the Paper Design view, click the Amount label (column heading), and choose Format > Justify > Right.