Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step online tutorials.

6.12 Fixing Blank Sections

Example 6-1. Eliminating blank address lines.

A common problem with printing addresses is that each one can have a different number of lines. Every address has a line allocated for the street address, but some addresses need a second line for other miscellaneous information. This could be an “Attention:” comment or the suite number. If an address doesn’t use this second line, then it appears as a blank line and messes up the formatting of the address. An example of these labels is shown in Figure 6-13.



Figure 6-13. Address labels with blank lines.

To fix this problem, create three sections. The first section has the addressee’s name and street. The second section only has the second address line. The third section has the rest of the address fields. To make the second section only appear when there is data in the second address line, set the formatting options Suppress Blank Section. If the second address line doesn’t have any information, then the section isn’t printed and the blank line is eliminated. The labels in design mode are shown in Figure 6-14. The printed labels are shown in Figure 6-15.



Figure 16-14. Address labels in design mode.


Figure 6-15. Address labels that suppress blank sections.