how to make variable "null" to zero when printing
Posted on December 5, 2012 at 4:52am
i have below query...i want to show zero instaed of null.
i tried with different datatypes for last two variables
Joined: Nov 1 2012 - 10:33pm
Last seen: 4 years 10 months ago
Posted on December 5, 2012 at 5:46am
for last two column write a condition that
$F{Field}==null?0:$F{Field}
Joined: Aug 29 2012 - 6:13am
Last seen: 6 years 6 months ago
@ajinkya_c,but where to add this condition.can u specify by seeing related file attached.
Whatever you use table or crosstab
Add this condition in field value expression.
e.g. $F{Net services provided by physician}==null? 0:$F{Net services provided by physician}
@ajinkya_c,thanks it works
I think so it should be in these way $F{Field}=/null?0:$F{Field} rather then in these $F{Field}==null?0:$F{Field}.
http://www.atlanticprecision.com