O'Reilly logo

Microsoft Dynamics CRM 2011 Reporting by Damian Sinay

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

Appendix A. Expression Snippets

In this appendix, we are going to see the basic and advanced Reporting Services expressions that we can use to show data in different ways and formats. We are also going to look at some user interactions with the reports to handle some of the common mouse click events.

Basic expressions

With expressions, we are talking about the Microsoft SQL Server Reporting Server expressions that we can use from either the Visual Studio Report editor or with the SQL Report Builder tool.

The basic expressions are grouped in the following categories:

  • Constants
  • Built-in fields
  • Parameters
  • Fields
  • Datasets
  • Variables
  • Operators
    • Arithmetic ( ^, *, /, \, Mod, +, -)
    • Comparison ( <, <=, >, >=, =, <>, Like, Is)
    • Concatenation ( &, +)
    • Logical bitwise ( And, ...

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