sagarnikam123 Posted December 5, 2012 Share Posted December 5, 2012 i have below query...i want to show zero instaed of null.i tried with different datatypes for last two variables null-send. Link to comment Share on other sites More sharing options...
Solution ajinkya_c Posted December 5, 2012 Solution Share Posted December 5, 2012 for last two column write a condition that$F{Field}==null?0:$F{Field} Link to comment Share on other sites More sharing options...
sagarnikam123 Posted December 5, 2012 Author Share Posted December 5, 2012 @ajinkya_c,but where to add this condition.can u specify by seeing related file attached. Link to comment Share on other sites More sharing options...
ajinkya_c Posted December 5, 2012 Share Posted December 5, 2012 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} Link to comment Share on other sites More sharing options...
sagarnikam123 Posted December 6, 2012 Author Share Posted December 6, 2012 @ajinkya_c,thanks it works Link to comment Share on other sites More sharing options...
henryesteban Posted July 17, 2013 Share Posted July 17, 2013 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now