CODEWITHSUNDEEP
reporting-servicessyntax
Tadhg
Tadhg

Reputation: 193

Where does the syntax for expressions in SSRS come from?

The syntax for the expressions in SSRS seem to be very different to the other products that Microsoft produces.

For example, I am not aware of any other tool that uses IIF() for an if statement and using 'is nothing' to assess if value is NULL.

Is there any history of where this syntax came from or a reason for why it is in this format?

Upvotes: 0

Views: 155

Answers (1)

Sébastien Sevrin
Sébastien Sevrin

Reputation: 5405

The SSRS expressions are based on Visual Basic.

Expressions are written in Microsoft Visual Basic, and can use built-in functions, custom code, report and group variables, and user-defined variables. Expressions begin with an equal sign (=).

Source: Expression Examples (Report Builder and SSRS)

The IIF() function is "inherited" from VB, same goes for is nothing.

Upvotes: 1

Related Questions