SSRS Switch Statement

=Switch(Fields!Orders.Value < 100,"Red", Fields!Orders.Value > 100, "Green")

The above statement is an example on how to use the ‘Switch’ statement in SQL Server Reporting Services. This example checks the ‘Orders’ value in a row and if the value is less than 100, displays “Red”. If the value is greater than 100, then display “Green”


Comments

One response to “SSRS Switch Statement”

  1. What if the values are same & both conditions fail?
    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.