outputting Zero Problem

[Bill Crawley]

Hi all,

I have my Report linked to an SP and all non-numeric columns print fine.
Some of the numeric columns on the DB come through to the report as either 0 or NULL. In both cases I want the data to print 0, but it's just left blank on the report. How do I force all Null or 0 values to print 0 on the report.

[Ned Pepper]

Three choices:
Changed the stored proc to return 0 when value is null using a case statement
Create a formula that examins the field

if IsNull({TABLE.Field}) then
0
Else
{Table.Field}

check your options to Convert Database Null values to Default