Post reply

Conditional font color...Overload error...

  • November 3, 2010 at 12:31 pm

    #242607

    So I have an expression in textbox27 that will print "X","DONE", or "OPEN" depending on the value it calculates. I'm trying to format the font color with this expression:

    =IIF(ReportItems!textbox27 ="X","Green","Black")

    I get this error when I try to preview the report.

    Overload resolution failed because no accessible '=' can be called with these arguments:

    Build complete -- 1 errors, 0 warnings

    Not sure what this means, any I ideas?

  • November 3, 2010 at 12:34 pm

    #1246226

    try this

    =IIF(ReportItems!textbox27.value ="X","Green","Black")

  • November 3, 2010 at 1:14 pm

    #1246247

    Magic! Thanks much!

  • November 3, 2010 at 2:29 pm

    #1246284

    I will frequently forget to add the .value in the expression builder the first time through.:-)

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

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