Ssrs Conditional Formatting Switch or Iif
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...
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!
1 Answer
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")
David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.
