Combine Runtime Selectable Filters

When your report includes multiple runtime selectable filters that expect the same type of search input, you can combine the filters to display a single search field on the report’s Search window or docked filters.

This lets report users enter one search value to search by two or more filters simultaneously. For example, you could have one search field to search by contacts’ first names, last names, and organizations’ names.

The combined filters can be joined using AND or OR logical expressions. Using AND logic, the search value you enter must match values in all the combined fields to return results. Using OR logic, the search value you enter needs to match a value in only one of the combined fields. By default, filters are joined using AND logic. See Edit a Logical Expression.

Runtime selectable filters that have the same data type, operator, and search options, such as items in a menu field, can be combined. You can combine multiple report filters and multiple level filters, though you cannot combine report filters with level filters.

1. Create a runtime selectable filter. See Create a Fixed or Runtime Selectable Filter.
2. Create a second runtime selectable filter.
   This filter must have the same name as the other filter you are combining. In addition, the two filters must use the same operator and must be of the same data type. For example, you can combine two integer fields, but you cannot combine an integer field with a menu field.