Show Null Values as Zeroes

[haneen97]

Hi,

Is there a function in Crystal Reports to make a number field display a 0 when it is null?

Thanks a lot.

Mo

 

[lyanch]

yes.. it is in report ->options.. convert null values to default.

 

[Madawc]

If you don't want to change your database, you can write and display a Formula Field, eg:

if isnull {yourfield} then 0
else {yourfield}

This sort of logic can do other things, e.g. "No value", though then it would insist on totext({yourfield}) rather than mixing numeric and character.

All of this is Crystal 8.5. In a lot of cases it is useful to distinguish between a zero value and a null or unknown value. Madawc Williams
East Anglia
Great Britain

 

[Madawc]

You'll find a lot of useful tips about nulls etc. on forum767 Madawc Williams
East Anglia
Great Britain

 

[haneen97]

That worked, thanks a lot.
Mo