Records with no values

[Taij]

I am using Siebel (Oracle DB) and Crystal Rpts 8.5
When a field has no value how can I get a 0 value assigned to it?

If not isnull ({S_ORDER_ITEM.X_SHOT_FEE}) then
Numbervar x5:= ({S_ORDER_ITEM.X_SHOT_FEE})else
Numbervar x5:= 0;

This is what I am using right now, but it does not work. (Does not show zero)

Also my "convert null field value to default" is gray, I cannot check or uncheck it.

Thanks

 

[MASTERMIKE]

Create a formula:
if isnull ({S_ORDER_ITEM.X_SHOT_FEE}) then 0 else {S_ORDER_ITEM.X_SHOT_FEE}
This will return a 0 if the field is null and return the field value if the field has a value.

 

[Taij]

Unfortunately it does not do that, it does not return a zero when null

 

[JohnEck]

Is the field a numeric or text field? If it is text then you need to put the 0 in quotes. If it is numeric then the field should return the zero. I use this all the time.