none
SSRS 2005 Conditional Formatting in a Matrix

    Question

  • I have this code

    =IIf(Fields!USERDEF1.Value =

    "CARA","Red","LimeGreen")

    in the colour propetry of a text box but I cannot get it to evaluate to TRUE - I have tried everything including changing it to Like "%A%" - which should work


    • Edited by BossIT Tuesday, February 28, 2012 11:28 AM
    Tuesday, February 28, 2012 11:07 AM

Answers

  • Are you sure you have the value "CARA" in the field? Also, try this and see if it works.

    =IIF(LTRIM(RTRIM(Fields!USERDEF1.Value)) = "CARA","Red","LimeGreen")




    Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

    • Marked as answer by BossIT Tuesday, February 28, 2012 11:54 AM
    Tuesday, February 28, 2012 11:52 AM

All replies

  • Are you sure you have the value "CARA" in the field? Also, try this and see if it works.

    =IIF(LTRIM(RTRIM(Fields!USERDEF1.Value)) = "CARA","Red","LimeGreen")




    Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

    • Marked as answer by BossIT Tuesday, February 28, 2012 11:54 AM
    Tuesday, February 28, 2012 11:52 AM
  • Thats fixed it - thanks a million - I spent hours at this yesterday and couldn't get it working. Super.

    =IIF(LTRIM(RTRIM(Fields!USERDEF1.Value)) = "CARA","Red","LimeGreen")

    Tuesday, February 28, 2012 11:54 AM