Logical Functions (Report Builder 1.0)

Use these functions to test the logic of a condition. For example, suppose you want your report to include all customers that fall into a specific age range and live in a specific region of the country. Using the AND function, you could specify which region the customers should live in (condition 1) and fall into a specific age range (condition 2). When testing the conditions, if both conditions prove TRUE, then Report Builder will include the data for that customer within the report.

Logical functions can use the following data type: Boolean.

In This Section

Topic

Description

AND (Report Builder 1.0)

Returns TRUE if all arguments are TRUE.

NOT (Report Builder 1.0)

Returns TRUE if the argument is false.

OR (Report Builder 1.0)

Returns TRUE if any argument is TRUE.