Microsoft® SQL Server 2008 R2 Unleashed

Understanding Expressions

You’ve seen some simple expressions (covered in the earlier section “New Simple Expression Syntax”). Now it’s time to delve a bit deeper into complex expressions. Almost every property of every reporting control can have its value determined at runtime as the result of an expression (either simple or complex). You write expressions using VB .NET code. This means you can derive the value of almost any writable report property from contextual report data, built-in or custom function output, .NET assembly method output, or static content. This is no small statement (no pun intended). Table 53.3 shows some examples of complex expressions.

Table 53.3 SSRS Complex Expression Examples

You don’t even have to remember these ...