Adding blank lines conditionally

Use multiple sections to print a blank line on your report under specific conditions. For example, you may want to insert a blank line after every fifth record in the report.

To add blank lines conditionally

1. Use the Section Expert to create two Details sections. See Working with sections.
2. Place the report detail data in the top section.
3. Leave the second section empty.
4. In the Section expert, highlight the second section.
5. On the Common tab, select the Suppress (No Drill-Down) check box then click the conditional formatting button to its right.
6. Enter the following formula in the Format Formula Editor:

Remainder (RecordNumber,5) <> 0

«This formula divides each record number by 5. If the division produces a remainder, it suppresses the blank section. But if the division produces no remainder, a zero (which it will for every fifth record printed), the program prints the second section, thus inserting a blank line.»

Note:    To insert a blank line under different conditions, you can modify your formula appropriately. See Working with conditional formatting.