Expression Conversion
I have a crystal expression:
if isnull({TYPEDESCRIPTION}) then "" else {TYPEDESCRIPTION}) + " " +
(if isnull({ENDSCONDITION}) then "" else {ENDSCONDITION})
This is how i wrote it
iif(isnothing(Fields!TYPEDESCRIPTION.Value),(
""),(Fields!TYPEDESCRIPTION.Value)) +""+
iif (isnothing(Fields!ENDSCONDITION.Value),(
""
),(Fields!ENDSCONDITION.Value)
I get an error as syntax error Can you help me convert this to an SSRS expression ????
Thank you
FM
March 22nd, 2011 12:14pm
Hi FM,
try this out,
= IIf ( IsNothing(Fields!TYPEDESCRIPTION.Value), "", Fields!TYPEDESCRIPTION.Value + " " + IIf ( IsNothing(Fields!ENDSCONDITION.Value), "", Fields!ENDSCONDITION.Value )
Please let us know your feedback.
Thanks
KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
March 22nd, 2011 1:14pm
Thank you kumar that worksFM
March 22nd, 2011 2:27pm