O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, 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 48.2. (Complex expressions are summarized in Table 48.3.)

TABLE 48.2 Simple Expression Syntax

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