Post reply

Iif statement help

  • November 28, 2007 at 12:40 pm

    #181582

    I can't get the following to work:

    =IIf(First(Fields!PositionType.Value, "devCECS")="3",false,true)

    I want to show or hide depending on this text within the specificed field. The field may contain other values separated by commas, i.e, 1,3,4,

    Can I use wildcard before and after? If so, what is the correct syntax?

    Thanks for your help.

    SSRS 2005

  • November 28, 2007 at 1:15 pm

    #755118

    Tammi Harris (11/28/2007)

    I can't get the following to work:

    =IIf(First(Fields!PositionType.Value, "devCECS")="3",false,true)

    I want to show or hide depending on this text within the specificed field. The field may contain other values separated by commas, i.e, 1,3,4,

    Can I use wildcard before and after? If so, what is the correct syntax?

    Thanks for your help.

    SSRS 2005

    Try

    =IIf(First(Fields!PositionType.Value, "devCECS") Like "*3*",false,true)

    Make sure all your stuff is in matching case. "devCECS" does not match "DevCECS" SSRS is picky

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]

  • November 29, 2007 at 10:12 am

    #755540

    Thank you! That worked.

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

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