Microsoft® SQL Server 2012 Unleashed

Understanding Expressions

A powerful feature of report development is the use of script expressions to dynamically populate report fields and other property values. Report expression syntax is organized into two logical groups: simple and complex. Complex expressions are simply the Visual Basic .NET (VB.NET) expressions you’ve used for years. Simple expressions are a newer kind of syntax, allowing for shorthand expression of simple values. For example, instead of expressing a ProductID field value as Fields!ProductID.Value, you can express it simply as [ProductID]. Simple expression syntax is summarized with examples in Table 55.2. (Complex expressions are summarized in Table 55.3.)

TABLE 55.2 Simple Expression Syntax

TABLE 55.3 SSRS Complex ...