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 reporti 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