replace null value with a "-"/dash

[vk01]

Hi,

 

some of the fields are returned with "null" values, is there a way to replace these? I searched the documentation for "replace" function but did not find one.

 

Thank you.

[svenn]

One of the properties on a text field is "Blank when null". If you check it off your field will be blank and not contain "null".

 

It might be a better option than replacement logic. If you're set on a dash you could use a conditional expression in the field.

 

( <condition> ? exp1 : exp2 )

 

($F{yourValue} != null ? $F{yourValue}, "-")

[vk01]

Thanks - this worked perfectly.

 

But incase of a BigDecimal, how would we try to compare? It comes back with an error message?

 

Thank you.

[svenn]

I've never used a BigDecimal but having looked at the Java API it looks like you would use

 

compareTo(BigDecimal val)

[kdegraaf]

Hi, I'm also trying to replace null.

 

This is what I have as Text field expression:

($V{SUM_RECEIPT_AMOUNT_STAT_CURRENCY_1} != null ? $V{SUM_RECEIPT_AMOUNT_STAT_CURRENCY_1}, "-")

 

It gives an error:

Parse error at line 1,column 89. Encountered: ,

 

What do I do wrong?

[svenn]

kdegraaf, what class is your text field set to (ie String, Int, Double etc)?

[Pedja]

Put ":" instead of "," in your expression, and then check the field type. This will work for string, for some other type you have to put that type instead of "-", or leave the field as String and setting the expression as ($V{SUM_RECEIPT_AMOUNT_STAT_CURRENCY_1} != null ? $V{SUM_RECEIPT_AMOUNT_STAT_CURRENCY_1}.toString() : "-")

[kdegraaf]

Hi, it is a BigDecimal,

 

This code works for me:

 

Code:

($V{SUM_RECEIPT_AMOUNT_STAT_CURRENCY_1} != null ? $V{SUM_RECEIPT_AMOUNT_STAT_CURRENCY_1}: new BigDecimal("0.0"«»))

[soraimar]

($F{value1}!=null?$F{value1}:0)

jrxml variable declaration example

<variable name="varWithTernary" class="java.lang.Double" calculation="Sum">    <variableExpression><![CDATA[($F{value1}!=null?$F{value1}:0)-($F{value2}!=null?$F{value2}:0)]]></variableExpression></variable>

 

https://stackoverflow.com/questions/37674266/how-do-i-replace-a-null-value-with-0/37675092#37675092