Help needed in printing blank rows with the lines.

[garry1]

Hi,

I need to insert balnk lines in the report based on a count returned by a feild in the report, so that users will try to enter the data later in the feild. Can someone please give me some hints in proceding with this problem. Any help is very much appreciated on this.

Thanks.

Garry.

 

[nagornyi]

1. Create another query in the data model that would ganarate some dummy records, for example

select rownum from all_tables

2. In the layout, place frame where you need the lines. Make the vertical elasticity of the frame to be Variable.
3. Place a repeating frame into above frame. Source the repeating frame with the group of the query you created.
4. In the format trigger of the repeating frame make

return :rownum <= :your_line_count_field

The line count field should be visible globally in the report, so it may, for example, be a report-level formula.