A script-enabled browser is required for this page to function properly.

Adding blank lines between groups of rows

To add blank lines between groups of rows:

  1. Create a summary column. On the Totals page of the Data Wizard (or Report Wizard), select any field that appears in each row of output, and Count as the calculation. On the Fields page, remove the summary from the displayed fields column.

  2. Create a user parameter named SPACE. In the Property Inspector, under the Parameter node, set the Datatype property to Number and the Initial Value property to the number of records you want in each group (for example, 5).

  3. In the Paper Layout view, click the the Flex On button and the Confine On button buttons in the toolbar to set Flex mode on and Confine mode off.

  4. Click the repeating frame for the group, then drag the handle on the bottom of the frame to create a space slightly larger than the space you want to add between groups of rows in the report output.

  5. Choose Toolsright arrowProperty Inspector to display the Property Inspector for the repeating frame.

  6. Under the General Layout node, set the Vertical Elasticity property to Variable.

  7. Click the Rectangle tool in the tool palette.

  8. Draw a rectangle in the space under the record.

  9. Double-click the rectangle object.

  10. In the Property Inspector, under the Advanced Layout node, double-click the Format Trigger property value to display the PL/SQL Editor.

  11. In the PL/SQL Editor, define the PL/SQL for the format trigger. Example.

  12. Hide the rectangle object:

See also

Changing the space between all rows