SSRS Expression error with IIF


  • i have on my report a field with inside this expression:

    =First(Fields!namefield.Value, "namedataset")

    namefield is a boolean data type and always return true or false

    but when i want to change expression in

    =Iif(First(Fields!namefield.Value, "namedataset"), "True option", "False option")

    return #Error.


    Edit for more details I tried follow expression

    =Iif(1000>100, "True option", "False option")

    and it works fine then problem is First(Fields!namefield.Value, "namedataset")

    • Edited by Mas_67 Wednesday, October 23, 2013 9:14 AM details
    Wednesday, October 23, 2013 9:04 AM

All replies