Replace Null into 0(Zero) 1

[Elango1253]

Hi all,
I'm using CR10.In my Report some fields are empty because the same fields in the databse are NULL..Now,I want to Replace the Empty field in to 0(zero).Anyone who knows the solution for this issue plz let me know...I'll be thankfull for u...

Elango.p

 

[synapsevampire]

2 ways are possible,File->Report->Options Convert null to default value.

Or write a formula, as in:

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

Use that formula in lieu of the actual field.

-k

 

[Elango1253]

Thanks a lot synapsevampire..Keep on clear my doubts..