Hi everyone

I have a number of fields with null values on my crystal report, what i want is to change this null values to show 0, please how do I go about this? Any response would be appreciated.

Please create a formula and display it:

if isnull({table.field} then
0 else
{table.field}

Thanks,
Krishnam

the reason you have null values because there isn't anything to report. if you want to report zeros then your source should have the zeros.

or

you can right mouse click on field then got to format field (is the field a number) then you can click customize field and change show zero values as (see choices)

also getting a reference book helps......