Post reply

iif or switch

  • July 27, 2011 at 4:42 pm

    #245121

    Hello All,

    I am a new in ssrs.

    I have a condition.

    if id in(1,2,3) then "yes" elseif "no".

    How can i use iif or switch function.

    Thanks

    L

  • August 1, 2011 at 9:18 am

    #1361641

    Using Switch

    =SWITCH(

    Fields!ID.Value = 1, "yes",

    Fields!ID.Value = 2, "yes",

    Fields!ID.Value = 3, "yes",

    1=1, "no")

    Using IIF

    =IIF(Fields!ID.Value = 1

    OR Fields!ID.Value = 2

    OR Fields!ID.Value = 3, "yes", "no")

    Good luck,

    Steve

  • August 1, 2011 at 2:20 pm

    #1361834

    Thanks

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

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