what is the synatx to check for nulls and division

[dprogrammer]

Hi, I need to add three fields in a variable to sum their values. If all three fields have values, sum shows correctly, but if any one of them is null, sum is also null. I need to know what is the syntax for checking nulls. I tried this

Field.doublevalue()== null? 0 : field.doublevalue

but it didnt' work.

 

Also, I tried using / in a division variable , but it is also giving me errors. My syntax was:

variable1.doublevalue() / variable2.doublevalue()

 

Thanks in advance.

[svenn]

I assume that you actually used

 

$F{Field}.doubleValue() == null ? : 0 : $F{Field}.doubleValue()

 

and

 

$V{Variable1}.doubleValue() / $V{Variable2}.doubleValue()

 

Were Field and Variable are the names of your values.

 

If so what errors are you getting

[codyjasperForge]

One option could be to handle null values in your report query, so you don't have to deal with them in your variables.

 

If you are using a SQL query, then try using a DECODE, CASE, or NVL function. There are others also. This seems to me as the best solution because anytime you test for 'null' values, the result is 'null'.

 

For example, $F{field}.equals(null) -> always yields null (if it is true)

 

Same goes for $F{field} == null ? "value1" : "value2"

 

Only if $F{field} has a value will these actually give desired values. (At least from all of my experience w/iReport I have found this to be true.)

 

P.S. Google: "Oracle 10 SQL Reference" (.pdf)

It has a lot of useful info.

 

Hope it helps.