Crystal Reports Question

[Rev. Michael L. Burns]

In a database I am working on for my church I need to print address labels. I am using the version of Crystal Reports that shipped with VB6 and it works fine with one exception. Some of my address have both address1 and address2. Most don't. If I set up Crystal reports to use both address lines and there is data for only one then my labels print with a blank line. Is there a way to have it automatically suppress a line that has no data?

Rev. Michael L. Burns

[VorTechS]

(I should really read things properly!)

In the full product you can right-click on the database field, choose format and there is a check box 'Suppress if blank'.

If you layer each line of your address in it's own details section you can then also apply the same formatting to the section, and thus your blank lines will be 'rolled-up'.

Perhaps you have similar options in the VB version?

[Rev. Michael L. Burns]

VorTechS,

Thanks for your assiatance.

Pastor Mike