using this data and stack the fields on top of one another in mailing label format, those customer records with an empty Address 2 field will print with a blank line. You can eliminate this blank line using multiple sections.

Using the Section Expert, create two new Details sections so you have a total of three. See How to add, delete, move, and merge sections, Page 89.

Place the Address 2 field in the middle section and the other data above and below it as you want it to appear in your report.

!Format the middle section to Suppress Blank Section. See How to hide parts of the report, Page 127.

Now, when the report prints, if the Address 2 section is blank, the program will not print it and you will not get unwanted blank lines in your report.

			After suppressing blank lines,
Before suppressing blank
lines, the Address2 field prints			the Address2 field does not
a blank line if it is empty.			print if it is empty.

How to add blank lines conditionally

If you want to print a blank line on your report under specific conditions, you can do that using multiple sections. For example, you may want to insert a blank line after every fifth record in your report.

Create two Details sections. See How to add, delete, move, and merge sections, Page 89.

228	Seagate Crystal Reports User’s Guide

Put the report detail data in the top section.

! Leave the second section empty.

"Format the second section to be suppressed unless the following condition is met:

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: If you want to insert a blank line under different conditions, you can modify your formula appropriately. See

Conditional formatting, Page 235.

Multiple Section Reports

229

230	Seagate Crystal Reports User’s Guide

10 Formatting

What you will find in this chapter...

Formatting concepts, Page 232

Absolute formatting, Page 233

Types of formatting properties, Page 233

Conditional formatting, Page 235

HANDS-ON (Absolute Formatting), Page 238

HANDS-ON (Conditional Formatting), Page 244

Formatting

231