Skip to Content
Former Member
Jun 07, 2010 at 11:46 AM

Empty value how to convert to 0 or string or boolean



I have the following problem:

i have a field that contains numbers from 2 to 50. When in use it in a report for particular record there is no value for this field, Cristal prints empty field and it is not 0 or empty string. The field type is Number (Database type X_NUMERIC).

When i make a formula to check the value in this field, Cristal again returns empty field even when i use boolean check.

How to convert this filed in that i can refer to?