Using Functions (Report Builder)
Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order. Functions can be used to perform simple or complex calculations. The structure of a function begins with the function name, followed by an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis.
Arguments can be field references, numbers, text, and logical values such as TRUE or FALSE. Arguments can also be constants, formulas, or other functions. The arguments that you enter must produce a valid value for that argument. For example, if the formula is multiplying two integers, the result cannot be a text string.
Report Builder comes with nine categories of commonly used functions.
Note
Function examples presented sometimes use field references to show how the function works. All field names referenced here are fields that exist in the sample Adventure Works data source that ships with Microsoft SQL Server.
In This Section
Topic | Description |
---|---|
Lists which aggregate functions are available and when to use them. |
|
Lists which conditional functions are available and when to use them. |
|
Lists which conversion functions are available and when to use them. |
|
Lists which date and time functions are available and when to use them. |
|
Lists which information functions are available and when to use them. |
|
Lists which logical functions are available and when to use them. |
|
Lists which math functions are available and when to use them. |
|
Lists which operator functions are available and when to use them. |
|
Lists which text functions are available and when to use them. |
See Also
Concepts
Working with Formulas (Report Builder)
Understanding Formulas (Report Builder)
Report Builder How-to Topics