none
SSRS Expression error with IIF

    Question

  • 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.

    Why?

    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