Home Forums SQL Server 2005 SQL Server Newbies IIF-function gives error RE: IIF-function gives error

  • January 29, 2013 at 4:40 am

    #1582018

    You need to qualify what Rank is, if its a field in a Data Set then you need to do something like the below.

    =IIF(Fields!Rank.Value =1,'Gold', IIF(Fields!Rank.Value =2, 'Silver', 'Bronze'))