Post reply

If a fieldname has a certain value, give another fieldname a different value????

  • April 29, 2010 at 5:46 pm

    #234465

    Hi all,

    Can someone please help?

    I have 2 fieldnames, =Fields!Type.Value and =Fields!Extension.Value.

    If Fields!Type.Value has a value of 'Intern' then I want =Fields!Extension.Value to be assigned a value of '345T'

    Does anyone know how to code this?

    BTW: We have SSRS 2005

    Thanks a lot in advance

  • April 29, 2010 at 8:38 pm

    #1160135

    Hi,

    In the field expression of =Fields!Extension.Value can you give the expression as

    =iif(Fields!Type.Value = "Intern" ,"345T",Fields!Extension.Value)

    Note:The value given in the "" is case sensitive, make sure you have given it in the same as it is coming from the dataset.

    Thanks & Regards,
    MC

  • April 30, 2010 at 5:20 pm

    #1160812

    Thank you very, very much.

    This worked great.

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

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