raja.shekar Posted December 5, 2014 Share Posted December 5, 2014 I need to use case statement in calculated fields while creating the domain using domain designer of jasper server. It would be helpful if i get any suggestion.. Link to comment Share on other sites More sharing options...
Solution nthapa Posted December 5, 2014 Solution Share Posted December 5, 2014 JRS does support "if" in calculated field, but doesnt support case. HTH. Link to comment Share on other sites More sharing options...
djohnson53 Posted December 8, 2014 Share Posted December 8, 2014 If you really need a SQL CASE statement, you can implement it as part of the SQL Query in a Derived Table. Link to comment Share on other sites More sharing options...
raja.shekar Posted December 9, 2014 Author Share Posted December 9, 2014 Hi all, Thanks for the reply. I need to use if statement in calculated fields of domain designer.for single condition it's working. if(a='10',a,b) its working. However i need to check b also. Example if(a='10' or b='15,a,b) it's not working. Please help me on this. Link to comment Share on other sites More sharing options...
djohnson53 Posted December 10, 2014 Share Posted December 10, 2014 Ok: Calc Field Z: a='10' Calc Field X: b='15' Calc Field Y: if(Z or X,a,b) 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