Create a Join Filter

You can create join filters to filter data in tables that are joined to the primary table with an outer join. Tables joined with an inner join do not have the Join Filters option.

1. Click the Home tab while editing a report that has multiple tables.
2. Click Tables.
3. Select the table you want to add a join filter to.
4. Click Join Filters.
   The Data Set window displays the Join Filters section.
5. Click Add Filter.
   The Add Filter window opens.
6. Do one of the following:
   • Enter the expression for the join filter.
   • Click Use Data Dictionary to open the data dictionary where you can define the filter’s expression.
7. To use an expression filter value, select the Expression option.
   The Add Filter window then displays a Value field.
8. Do one of the following.
   • Enter the expression in the Value field.
   • Click Use Data Dictionary to open the Edit Expression window, from which you can create the value’s expression using database fields, functions, and variables listed in the data dictionary.
   Note: Currency fields aren't available for use in join filters.
9. Click OK.

Results:

After you add a join filter, the Data Set window is updated to display the filter, along with additional actions that are identical to those used when creating logical expressions for report, group, and level filters. These actions let you edit your filter, create additional filters, add OR logic to the join filters, negate filters, view a text definition of the join filters’ logical expression, and switch between the filters’ descriptions and names. See Edit a Logical Expression.