Tag: SQL

  • 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”