-
Book Overview & Buying
-
Table Of Contents
Microsoft Dynamics CRM 2011 Reporting
By :
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, Not, Or, AndAlso, OrElse)
Bit Shift (<<, >>)
Common Functions
Text
Date and Time
Math
Inspection
Program Flow
Aggregate
Financial
Conversion
Miscellaneous
The basic expressions are available in the Expression editor dialog box, as shown in the following screenshot:

The Constants option will show you all the constants you have defined for your report. Constants are useful if you want to avoid using values in your expressions that would not make sense in a big piece of code. For example, asking if a variable such...
Change the font size
Change margin width
Change background colour