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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics