In the Set Filter on Column dialog box, you can create a filter for a column that you select in the Select Data Filters dialog box. Filters determine what data Integration Services retrieves from the relational data source for the drill-through report.
Column—Select the column to which the condition applies.
Operator—Select from the list of filter operators to create the filter definition.
Condition—Enter the condition or click to open the Select Filter Values from the List dialog box.
Add—Click to add filter conditions to the Filters box.
Add Type options—Select And or Or in the Add Type box or enter AND or OR in the Filters box.
The default value is Or. Integration Services applies the filter if the conditions you specify are met. If you select And, Integration Services applies the filter only if all conditions are met.
To determine the order in which the relational data source executes multiple conditions, enter parentheses around the conditions in the Filters box. How you define ordering depends on the relational data source. Consult the documentation for the relational data source.
Filters—To create a filter, use one method:
Build the filter interactively by selecting the operator to use from the Operator list box.
Enter the filter directly into the Filters box, using the SQL syntax supported by the relational data source.