Suppressing alpha fields

[crystalwriter]

How do you suppress an alpha field when it is empty, and display it when populated.

 

[dgillz]

If the field is empty, it won't display anything. Just place the field on the report.

If however you are trying to not display any records of the database when a certain alphanumberic field is empty, use a record selection formula:

Not isnull({YourAlphaField}) or length(trim({YourAlphaField}))>0

the second part of code above will cover you in case the field is not null but contains blank spaces.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[crystalwriter]

That's not exactly what I meant. I have address fields that have six fields on the detail line. Say, if number 4 does not have data I want the field and the row to supress. But I think my problem is I have all six fields in the detail section?

 

[dgillz]

see thread767-663252. they have given you the correct answer.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com