I currently have the following 2008 SSRS Report and I want to conditionally format background of the columns based on some logic.
I have three columns and two of which I would like to change the background color. Columns "Current Risk Level", "Trend", "Tolerance". Each contains rows of either Low, Moderate, Medium, High, Very High
For column "Current Risk Level" I would like Low="Green",Moderate="Blue",Medium="Yellow",High="Orange",Very High="Red"
For column "Tolerance" I would like Low="Red",Moderate="Orange",Medium="Yellow",High="Blue",Very High="Green"
I don't know how to set up a SWITCH or IIF function to accomplish this.
Any help would be really appreciated!
This question is related to
reporting-services
ssrs-2008
switch-statement
iif-function
To dynamically change the color of a text box goto properties, goto font/Color and set the following expression
=SWITCH(Fields!CurrentRiskLevel.Value = "Low", "Green",
Fields!CurrentRiskLevel.Value = "Moderate", "Blue",
Fields!CurrentRiskLevel.Value = "Medium", "Yellow",
Fields!CurrentRiskLevel.Value = "High", "Orange",
Fields!CurrentRiskLevel.Value = "Very High", "Red"
)
Same way for tolerance
=SWITCH(Fields!Tolerance.Value = "Low", "Red",
Fields!Tolerance.Value = "Moderate", "Orange",
Fields!Tolerance.Value = "Medium", "Yellow",
Fields!Tolerance.Value = "High", "Blue",
Fields!Tolerance.Value = "Very High", "Green")
Source: Stackoverflow.com