Share via


Using Functions (Report Builder 1.0)

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.

An example of a function.

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 MicrosoftSQL Server.

In This Section

Topic

Description

Aggregate Functions (Report Builder 1.0)

Lists which aggregate functions are available and when to use them.

Conditional Functions (Report Builder 1.0)

Lists which conditional functions are available and when to use them.

Conversion Functions

Lists which conversion functions are available and when to use them.

Date and Time Functions (Report Builder 1.0)

Lists which date and time functions are available and when to use them.

Information Functions (Report Builder 1.0)

Lists which information functions are available and when to use them.

Logical Functions (Report Builder 1.0)

Lists which logical functions are available and when to use them.

Math Functions (Report Builder 1.0)

Lists which math functions are available and when to use them.

Operator Functions (Report Builder 1.0)

Lists which operator functions are available and when to use them.

Text Functions (Report Builder 1.0)

Lists which text functions are available and when to use them.