null2zero function in crystal report? 1

[kingz2000]

Hi guys,

I'm using crystal reports XI and I am simply trying to add 5 columns together which could have a null value. I resume that is why I am getting null at the moment. If the 5 colums are a,b,c,d & e how can make a formula using the formulka workshop to ad up the columns counting nulls as '0'???

 

[MisterMo]

I think one way is to set the null values to default

file>Report Option and check convert database null values to default

Then format each of your fields to have zeros as default values

Mo

 

[kingz2000]

thanks! it works!