Post reply

Using Color Expressions

  • July 9, 2007 at 8:31 am

    #179683

    I currently have a report that uses color expressions, which works well.

    =IIf( Fields!Mark.Value> Fields!Target_Mark.Value ,"Black","Red" )

    However I now need to expand this code. I need to be able to change the colour of the report text based on the value of a string.

    I would like to have something along the lines of IIF(Fields!Mark.Value> Fields!Target_Mark.Value AND Fields!Exam_Description.Value LIKE "*Real*", "Black", "Red") OR IIF(Fields!Exam_Description.Value LIKE "*Test*", "Brown", "Blue")  but I do not know how to code this.

    Any help will be greatly appreciated.

    Thanks

     

  • July 9, 2007 at 9:31 am

    #718058

    Embed the next IIF in the false part of the previous:

    IIF(Fields!Mark.Value> Fields!Target_Mark.Value AND Fields!Exam_Description.Value LIKE "*Real*", "Black", IIF(Fields!Exam_Description.Value LIKE "*Test*", "Brown", IIF(criteria for blue or red, "Blue","Red)))

     

    Lee.

  • July 9, 2007 at 9:53 am

    #718062

    That's great thank you very much.

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

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