SSRS Conditional Formatting Switch or IIF

by

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

More Related Contents:

  1. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  2. Does the iif function compute both paths in SSRS or is it short-circuited?
  3. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
  4. Pivot a table in reporting services?
  5. Access Page number in report body In SSRS
  6. How to get rid of blank pages in PDF exported from SSRS
  7. SSRS multi-value parameter using a stored procedure
  8. Compare SQL Server Reporting Services to Crystal Reports [closed]
  9. SSRS Expression Divide by Zero Error
  10. Reporting Services export to Excel with Multiple Worksheets
  11. Changes to parameter not showing on Report Server after deployment
  12. When to use RDLC over RDL reports?
  13. SSRS 2005 Set SimplePageHeaders on the report instead of the server?
  14. divide by zero/null workaround in SSRS 2008 report
  15. Need help in calculation using two Datasets using Expression SSRS
  16. SSRS – How to build a simple multi-column report?
  17. SSRS – How to continue data to next column?
  18. SSRS distinct lookupset function
  19. How do I format date and time on ssrs report?
  20. Optional multi-valued parameters in SSRS
  21. Passing Credentials to Sql Report Server 2008
  22. How to combine aggregates within a group with aggregates across groups within SSRS
  23. Programmatically Export SSRS report from sharepoint using ReportService2010.asmx
  24. The permissions granted to user ‘ are insufficient for performing this operation. (rsAccessDenied)”}
  25. Should switch statements always contain a default clause?
  26. What is the difference between IF-ELSE and SWITCH?
  27. Swift: Test class type in switch statement
  28. Can I declare variables inside an Objective-C switch statement?
  29. PHP: two values in the case of Switch? [duplicate]
  30. Does a break statement break from a switch/select?

Leave a Comment