v2.2.0
v2.2.0v2.1.0v2.0.0v1.2.0

Decision Functions

Choose

Returns a value on the specified position from the list

Syntax

Choose(index, Value1[, Value2,…[, ValueN]])

Arguments

  • index - the one-based position of the value you want to return
  • Value1, ValueN - the list to return a value from

Examples

You can use the following expression to return the report header based on the DataToDisplay parameter value.

Choose(@DataToDisplay, "Current Year", "Actual-Prior Year")

IIF

Returns one of two values depending on whether the expression is true or not.

Syntax

Choose(expression, trueReturn, falseReturn)

Arguments

  • expression - an expression that should evaluate to a boolean value
  • trueReturn - the value to return if the expression evaluates to true
  • falseReturn - the value to return if the expression evaluates to false

Examples

You can use the following expression to return the color of text based on the SalesAmount field value.

{IIF(SalesAmount >= 1000, "Green", "Red")}

Switch

Returns the value associated with the first expression in a series that evaluates to true

Syntax

Switch(Expression1, Value1[, Expression2, Value2,…[, ExpressionN, ValueN]])

Arguments

  • Expression1ExpressionN - expressions that should evaluate to a boolean value
  • Value1ValueN - values associated with expressions

Examples

You can use the following expression to return the sales channel name based on the ChannelKey field value.

{Switch(ChannelKey = 1, "Store", ChannelKey = 2, "Online", ChannelKey = 3, "Catalog", ChannelKey = 4, "Reseller")}