Programming Enhancements

SSRS 2008 R2 includes a number of enhancements to the VB.NET script used in expressions, as well as to the report rendering engine.

New Simple Expression Syntax

Report expression syntax has been reorganized 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 new 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 now express it simply as [ProductID]. Simple expression syntax is summarized with examples in Table 53.1 (complex expressions are summarized in Table 53.3).

Table 53.1 New Simple Expression ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.