SWITCH (Report Builder)
Evaluates a list of expressions, and returns the value associated with the first condition that returns TRUE. Switch can have one or more condition/value pairs.
Syntax
Switch(condition1, value1, …)
condition1 |
Indicates the condition to test. |
value1 |
Specifies the value or expression that the item should be replaced with, if the condition is True. |
Example
| Formula | Result |
|---|---|
SWITCH(Customer Type = "I", "Individual", Customer Type = "S", "Shop") |
If the Customer Type is "I", the word "Individual" is displayed. If the Customer Type is "S", the word "Shop" is displayed. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Conditional Functions [(Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)