Displaying 0 instead of a null

[goodprg]

I have a formula which sometimes return null values. I want the report to display 0 instead of null. I know that I can create another function and use ISNULL function but I want to know is there a setting which I can set so that it display's 0 instead of a null value.

Thanks.

 

[synapsevampire]

There's a global setting, depending upon your version (you should post your version) you'll find it somewhere on File->Report Options->Convert null values to default.

This will then make it impossible to test for nulls though.

-k