Backgroundcolor from an cell in the table based on a condition. RRS feed

  • Question

  • Hi everyone,


    I have created an report in report studio. In that report I have placed an table. In that table I wanted to highlight an row based on an condition(In my report I wanted to highlight an staff member with the personal ID='00030'). Can i fix this in the expression editor from the cell in the table?


    Anyone any ideas, because I can't seem to find the way to do this.


    Thanks a lot,


    Frank Ruiter

    Tuesday, November 20, 2007 10:53 AM

All replies


    Try this in your "BackGroundColor" property for the whole row:

    =iif(Fields!PersonalID.Value="00030", "The color you want","Transparency")

    Good luck,


    Wednesday, November 21, 2007 1:14 AM