How to use case statement in calculated fields in domain designer of jasper server?

0

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..

raja.shekar's picture
Joined: Apr 21 2014 - 12:28am
Last seen: 4 years 10 months ago

2 Answers:

0

JRS does support "if" in calculated field, but doesnt support case. HTH.

 

 

nthapa's picture
463
Joined: Jan 24 2014 - 9:53am
Last seen: 3 years 5 months ago
0

If you really need a SQL CASE statement, you can implement it as part of the SQL Query in a Derived Table.

djohnson53's picture
76459
Joined: May 25 2012 - 11:10am
Last seen: 8 hours 30 min ago

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.

raja.shekar - 4 years 11 months ago

Ok:

Calc Field Z: a='10'
Calc Field X: b='15'
Calc Field Y: if(Z or X,a,b)

djohnson53 - 4 years 11 months ago
Feedback