renatomitsunami Posted October 30, 2017 Share Posted October 30, 2017 Hi...I'm trying to construct a conditional script with many "OR" operators.I have a variable $V(TOTAL) counting numbers of rows... IF {Field1} not blank "OR" {Field2} not blank "OR" {Field3} not blank.Thanks a lot. Link to comment Share on other sites More sharing options...
honeybakliwal Posted October 31, 2017 Share Posted October 31, 2017 $F{Field1} != ""|| $F{Field2} != "" ....... and so on considering the $F{Field1} is of string datatype. Jaspersoft accept one liner IF Else statement for eg (Condition) ? True :False RegardsHoney Link to comment Share on other sites More sharing options...
renatomitsunami Posted October 31, 2017 Author Share Posted October 31, 2017 Hi honeybakliwalI have Field1 = Timestamp, Field2 = String and Field3 = StringHow could I resolve this problem ?Thanks Link to comment Share on other sites More sharing options...
honeybakliwal Posted February 7, 2018 Share Posted February 7, 2018 Create a variable with variable expression as Field1 !=null || Field2 !=""||Field3 !="" and set the calculation type to count Thanks Honey 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