In the Select Data Filters dialog box, you can apply filters to drill-through columns to determine what data Integration Services retrieves for the report.
Column—Select a column to apply or define a filter for that column.
Condition—Displays the filter string, if a filter is attached to the column.
Add Condition—Click to create or edit a filter.
Clear—Click to clear the filter conditions from the selected column.
Note: | Clicking Clear does not delete the permanently saved filters in the Filter list box. |
Clear All—Click to clear all filter conditions from all columns in the report.
Note: | Clicking Clear All does not delete the permanently saved filters in the Filter list box. |
Filter—Contains the list of saved filters. Click the arrow to view the list of available filters.
Description—Enter a description for the filter selected in the Filter list box.
Condition—Displays the conditions of the currently-selected column or filter.
Add New Filter—Click to add a filter. When you click the Add New Filter button, the Filter Name dialog box is displayed. If you want to base the filter on the currently-selected filter, select Copy definition of current filter.
Delete—Click to delete the filter displayed in the Filter list box.
Rename—Click to display the Filter Name dialog box. Enter a name for the filter in Name and click OK.
Save Filters—Click to save modifications to all filters created for this drill-through report.
Back—Click to move to the previous screen of the Drill-Through Wizard.
Next—Click to move to the next screen of the Drill-Through Wizard.
Finish—Click to generate a drill-through report and display the results in the spreadsheet.