To display DB blank values as NA
In my report ,the db field consists of both zero and blank values.i want zero values to be displayed as 0 and blank values alone to be displayed as NA.
If i checked the option "Convert Database values to Null" ,all the values "both zero and blank" gets converted to zero or the default value.
i also tried using IsNull function..the blank values doesn't get any change.
Can anyone please help me to solve this issue?
Thanking you in Advance,