Report Studio

Constructs

Constructs allow you to create more complex queries:

if then else

Syntax

IF ([Country] = 'Canada')

THEN ([List Price] * 0.60)

ELSE ([List Price])
in_range

Specify one or more constants or ranges. A range can be open ended.

Example

[gosales].[CONVERSIONRATE].[COUNTRYCODE] IN_RANGE { :30 , 40, 50, 999: }

search case

Syntax

CASE

WHEN [Country] = 'Canada' THEN ([List Price] * 0.60)

WHEN [CountryCode] > 100 THEN [List Price] * 0.80

ELSE [List Price]

END
simple case

Syntax

CASE [Country]

WHEN 'Canada' THEN ([List Price] * 0.60)

WHEN 'Australia' THEN [List Price] * 0.80

ELSE [List Price]

END

Related Topics:

Concatenating Strings—How to concatenate strings in expression editor.
Common Functions—Some common functions for use in Expression Editor.
Operators—About the operators available in Expression Editor.
Using the Expression Editor—How to use the Expression Editor in Report Studio reports.