SyntaxFix

[reporting-services] SSRS Conditional Formatting Switch or IIF

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")

Examples related to reporting-services

• How to use multiple conditions (With AND) in IIF expressions in ssrs • Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=11.0.0.0 • Line break in SSRS expression • SSRS expression to format two decimal places does not show zeros • SSRS Expression for IF, THEN ELSE • SSRS Conditional Formatting Switch or IIF • SQL variable to hold list of integers • Could not load file or assembly 'Microsoft.ReportViewer.WebForms' • How do I format date and time on ssrs report? • How do I display todays date on SSRS report?

Examples related to ssrs-2008

• Line break in SSRS expression • SSRS Conditional Formatting Switch or IIF • Add column to SQL query results • How do I format date and time on ssrs report? • How do I display todays date on SSRS report? • Cannot create a connection to data source Error (rsErrorOpeningConnection) in SSRS • In SSRS, why do I get the error "item with same key has already been added" , when I'm making a new report? • How to pass multiple values to single parameter in stored procedure • Right pad a string with variable number of spaces • SSRS Query execution failed for dataset

Examples related to switch-statement

• Switch in Laravel 5 - Blade • Switch case: can I use a range instead of a one number • SQL use CASE statement in WHERE IN clause • SSRS Conditional Formatting Switch or IIF • Switch statement equivalent in Windows batch file • OR operator in switch-case? • Regarding Java switch statements - using return and omitting breaks in each case • Using two values for one switch case statement • C# how to use enum with switch • Switch statement multiple cases in JavaScript

Examples related to iif-function

• SSRS Conditional Formatting Switch or IIF • Iif equivalent in C#