In this tutorial, we will learn How to use Switch function features in your chart report. Switch is useful when there are three or more conditions to test because it's simpler to read than nested IIF statements. It's similar to a Case statement in t-sql. A Switch will return the first expression that it finds true, so the order of the conditions is very important. As with most things in SSRS you can do something in more than 1 way but today I wanted to introduce you to the Switch Function. The SWITCH function allows you to have multiple conditions when evaluating an expression. It evaluates each condition within the function. For more on SQL Server BI Stack, please visit us - http://www.sql-datatools.com
Comments