kktd58
asked on
Can you use immediate iif in crystal report command object?
Can you use immediate iif in crystal report command object?
Select total
iif(a>0,a/100,b) as Total
from tableA
Select total
iif(a>0,a/100,b) as Total
from tableA
if your database's brand of sql supports iif() then you should be able to; if it doesn't, you can't.
ASKER
i am receiving an ODBC Informix Driver syntax error (-201)when trying this. I just wasn't sure if there was some different syntax that i should be using. I guess it just does not work. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have you tried it?
mlmcc