IN (Report Builder)
Determines whether an item is a member of a set.
Syntax
IN(item, set)
item |
Indicates the item to be tested for to determine if it is included in a set. |
set |
Specifies the values within which to determine if the item is a member. |
Remarks
- All values in the set must be literal values.
- A set must contain at least one value.
- All values within the set must have the same type.
- Boolean values are not allowed in a set.
- Sets containing literal EntityKey values are not displayed and cannot be entered.
Example
| Formula | Result |
|---|---|
IN(State Province, {"California", "Oregon", "Washington", "Alaska"}) |
All values listed in the State Province field are compared to the formula filter condition. All State Province records that match the set (California, Oregon, Washington, or Alaska) are displayed in the report. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Conditional Functions [(Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
5 December 2005 |
|