check for null

[law]

I'd like not to display nulls in my iReport. I have the following at the moment but it doesn't work:

(if($F{BEGCYC6} != null) $F{BEGCYC6})

 

Is it possible to check for nulls several fields at once so that I wouldn't rewrite the same line of code for every output?

[C-Box]

Just use the "Blank when NULL" attribute at each field! ;)

 

hth

C-Box

[jmoll26]

You could also setup a group band. You can then setup your Print When expression to be

new Boolean(if($F{BEGCYC6} != null) $F{BEGCYC6}). That would prevent you from writing the same check for each field as well.

[law]

Thanks a lot. I saw the "Set to null" option few hours after I made a post.