Using Operators in Expressions (Report Builder 3.0 and SSRS)
An operator is a symbol that represents actions applied to one or more terms in an expression. The following categories of operators are supported in an expression: arithmetic, comparison, concatenation, logical or bitwise, and bit shift.
Note
You can create and modify report definitions (.rdl) in Report Builder 3.0 and in Report Designer in Business Intelligence Development Studio. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS) on the Web at microsoft.com.
Arithmetic
Arithmetic operators perform mathematical operations on two numeric terms in an expression.
Operator |
Description |
|---|---|
^ |
Raises a number to the power of another number. |
* |
Multiplies two numbers. |
/ |
Divides two numbers and returns a floating-point result. |
\ |
Divides two numbers and returns an integer result. |
Mod |
Returns the integer remainder of a division. For example, 7 Mod 5 = 2 because the remainder of 7 divided by 5 is 2. |
+ |
Adds two numbers together. |
- |
Returns the difference between two numbers or indicates the negative value of a numeric term. |
Comparison
Comparison operators test whether two expressions are the same.
Operator |
Description |
|---|---|
< |
Less than. |
<= |
Less than or equal to. |
> |
Greater than. |
>= |
Greater than or equal to. |
= |
Equal to. |
<> |
Not equal to. |
Like |
Determines whether a specific character string matches a specified pattern. A pattern can include regular characters and wildcard characters. During pattern matching, regular characters must exactly match the characters specified in the character string. However, wildcard characters can be matched with arbitrary fragments of the character string. Using wildcard characters makes the LIKE operator more flexible than using the = and != string comparison operators. The following table lists characters that can be used as wildcards:
CharacterDescription
%Any string of zero or more characters.
_Any single character.
[ ]Any single character within the specified range (for example, [a-f]) or set (for example, [aeiou]).
[^]Any single character not within the specified range (for example, [^a-f]) or set (for example, [^aeiou]).
|
Is |
Compares two object references. |
String Concatenation
String concatenation appends the second string to the first string in an expression. For other string operations, use built-in functions.
Operator |
Description |
|---|---|
& |
Concatenates two strings |
+ |
Concatenates two strings |
Logical and Bitwise
Logical and bitwise operators perform logical manipulations between two integer terms in an expression.
Operator |
Description |
|---|---|
And |
Performs a logical conjunction on two Boolean expressions, or bitwise conjunction on two numeric expressions. |
Not |
Performs logical negation on a Boolean expression, or bitwise negation on a numeric expression. |
Or |
Performs a logical disjunction on two Boolean expressions, or bitwise disjunction on two numeric values. |
Xor |
Performs a logical exclusion operation on two Boolean expressions, or a bitwise exclusion on two numeric expressions. |
AndAlso |
Performs logical conjunction on two expressions. |
OrElse |
Performs logical disjunction on two expressions. |
Bit Shift
Bitwise operators perform bit manipulations between two integer terms in an expression.
Operator |
Description |
|---|---|
<< |
Performs an arithmetic left-shift on a bit pattern. |
>> |
Performs an arithmetic right-shift on a bit pattern. |