Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Blessed1978
Yak Posting Veteran
97 Posts |
 Posted - 2014-03-26 : 19:40:13
|
I have 5 columns, A,B,C,D,E in a ssrs report
i am grouping by column "A" what i would like to do is if anytime a particular person name shows up in column a, i would like to automatically highlight columns "A through E" in yellow. I can right click on cell "A" and go to properties then background color and click expression and write my syntax there. however if i say =iif(Fields!A.Value = "Joe Smith" , "Yellow", "white")
what if i have over 200 names to highlight if it meets the criteria would i say =iif(Fields!A.Value = "Joe Smith","ken brown","mark coy" (etr), "Yellow", "white")
am i correct , please let me know. I would also like to make the entire Row YELLOW not just A. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2014-03-26 : 22:39:26
|
Regarding the color, instead of putting the expression on the field boxes, put it on the detail section background. Then make all the field backgrounds transparent.
I believe you can use the following expression for multiple conditions:
=iif(Fields!A.Value IN("Joe Smith","ken brown","mark coy"), "Yellow", "white")
|
 |
|
|
|
|
|
Conditionally FORMATTING ENTIRE ROW IN SSRS 2012