formula returning NULL

[clydejones]

I wrote a formula to show addresses. When one or more fields that are used to make up the address formula contain null values for some records, the fromula returns null (empty). I would still like to show the fields of the address formula that do not contain null values. Any help would be appreciated.

Thanks,
Clyde

 

[OCPCLC]

Are you on Crystal 7 or higher? Have you tried under File, Options, Reporting tab -- clicking Convert Null field value to default?

 

[kenhamady]

That works as long as you don't need to use the IsNull function anywhere in the report.

The alternative is more work but would be something like:

(if IsNull({city}) then "" else {city})+
", " +
(if IsNull({state}) then "" else {state})+
" " +
(if IsNull({zip}) then "" else {zip}) Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal