O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required