To add blank lines between groups of rows:
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.
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).
In the Paper Layout view,
click the
and
buttons in the toolbar to
set Flex mode on and Confine mode off.
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.
Choose ToolsProperty
Inspector to display the Property Inspector for the repeating frame.
Under the General Layout node, set the Vertical Elasticity property to Variable.
Click
in the tool palette.
Draw a rectangle in the space under the record.
Double-click the rectangle object.
In the Property Inspector, under the Advanced Layout node, double-click the Format Trigger property value to display the PL/SQL Editor.
In the PL/SQL Editor, define the PL/SQL for the format trigger. Example.
Hide the rectangle object:
On the Fill Color palette, click No Fill.
On the Line Color palette, click No Line.
Changing the space between all rows
Copyright © 1984, 2005, Oracle. All rights reserved.