Post reply

ssrs iif expression

  • January 16, 2014 at 8:19 am

    #284458

    In an ssrs 2008 report, I need to place a 'customer short name' in a detail line when the field has a value in it. When there is no value in the 'customer short name', I am suppose to use the 'customer long name'.

    Thus can you should me how to setup this code in an iif expression?

  • January 16, 2014 at 10:32 am

    #1680765

    found answer

  • January 16, 2014 at 2:50 pm

    #1680882

    please share the solution it will help others.Please try to add the techincal keywords in you reply so that any one can search it with those key words.

    Thanks,

    RUshi

  • January 16, 2014 at 3:18 pm

    #1680895

    wendy elizabeth (1/16/2014)

    In an ssrs 2008 report, I need to place a 'customer short name' in a detail line when the field has a value in it. When there is no value in the 'customer short name', I am suppose to use the 'customer long name'.

    Thus can you should me how to setup this code in an iif expression?

    =iif(Fields!ShortName.Value="", Fields!LongName.Value, Fields!ShortName.Value)

    Should cover blanks or NULL for ShortName

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply