In the Select Data Filters dialog box, you can apply filters to determine which data Integration Services retrieves for the drill-through report.
To apply an existing filter:
Perform the tasks described in Selecting Data Sort Order.
In Filter, select a filter to apply to this drill-through report.
The full string of the filter is displayed in the lower Condition box.
Integration Services generates the customized drill-through report and displays the results in the spreadsheet. The worksheet is added before the current active worksheet.
To apply a new filter:
Perform the tasks described in Selecting Data Sort Order.
The columns in the Column list box are those that you selected in Selecting and Ordering Columns.
If a filter is attached to the column, it is displayed in the Condition list box. The full string of the filter is displayed in the lower Condition box.
To set the conditions of the filter, see Creating Member Filters.
To add this filter to the list of saved filters, click Add new filter.
In Filter Name enter a Name for this filter.
If you want the filter description and conditions to match the filter that you just created, select Copy definition of current filter, and then click OK.
To clear a filter, select the filter; and then click Clear; to clear all filters, click Clear All.
Clicking Clear or Clear All does not delete permanently saved filters.
When you are finished editing and deleting filters, click Finish.
Integration Services generates the customized drill-through report and displays the results in the spreadsheet. The worksheet is added before the current active worksheet.