I have to implement row text color based on column condition. Even though this is simple to do, but thought to share. Hope it helps!
Scenario:
I have a simple report which displays person information in Adventure Works database.In that person data, where ever person title is "Ms.", then complete row should be display in other text color.Because it helps to easily identify who are female persons.
Implementation:
I just take top 20 rows from table and few of the columns which looks like below:
Now where Title is "Ms.", row should be in other color font. To do this, check out the below image
Scenario:
I have a simple report which displays person information in Adventure Works database.In that person data, where ever person title is "Ms.", then complete row should be display in other text color.Because it helps to easily identify who are female persons.
Implementation:
I just take top 20 rows from table and few of the columns which looks like below:
Now where Title is "Ms.", row should be in other color font. To do this, check out the below image
Write expression as =IIF(Fields!Title.Value = "Ms.","White","Black")
Then you can see the report as below
No comments:
Post a Comment