kamalisto Posted March 4, 2010 Share Posted March 4, 2010 Code:Dear all, Here is the error when I try to use a < less than or > more than character. How to write this statement in ireport? eg:($F{ELAPSED} < 1440 ? "":null) thx for the response.. Link to comment Share on other sites More sharing options...
ckampshoff Posted March 4, 2010 Share Posted March 4, 2010 Hi kamalisto,what kind of field is your $F{ELAPSED}? As far as I know this will only work with double or int Values. So if your field is a BigDecimal just try the following term: ($F{ELAPSED} .doubleValue() < new java.math.BigDecimal(1440).doubleValue() ? "":null)Please note that this will work with Java, not with Groovy.HTHChristina. Link to comment Share on other sites More sharing options...
kamalisto Posted March 5, 2010 Author Share Posted March 5, 2010 Code:thanks ckampshoff for your suggestion, actually i used the other alternative which is write those condition in report query eg : select (CASE WHEN ("ISSUE"."RELEASE_DATE" - "ISSUE"."ORI_DEADLINE_DATE") < 0 THEN 'VERY GOOD' END) as ratingDate 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