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

[raja.shekar]

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

[nthapa]

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

 

 

[djohnson53]

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

[raja.shekar]

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.

[djohnson53]

Ok:

 

Calc Field Z: a='10'

Calc Field X: b='15'

Calc Field Y: if(Z or X,a,b)