Filter List Dialog Box (Report Builder 1.0)
When adding an entity to the filter area in the Filter Data dialog box and specifying certain comparison operators, you need to select which instance(s) of the entity that you want to use in your filter. If the list of instances is small enough, a list of the items is displayed when you click the criteria area. For example, if you add the Customer entity to your filter area and you only have 50 customers, all 50 customers are listed in a drop-down list and you can select the check box for each customer that you want to add to the filter. However, suppose you have 10,000 customers; to work with a list this large would simply not be practical.
In situations where the entity contains a large quantity of data and you need to select which items to use in the filter, Report Builder automatically launches the Filter List dialog box when you click the no values selected criterion within the filter clause on the Filter Data dialog box. Use the Filter List dialog box to reduce the number of items listed in the drop-down list box that is displayed in the filter. The purpose of the Filter List dialog box is to help you pre-filter the data that you want to add to your filter.
The Available data list is pre-populated when the number of entities is less than a pre-determined value set in the data source. To reduce the number of items listed in the Available data list, you can type a word in the Filter text box and then click the Filter button.
The Available data list is not pre-populated when the number of available entities exceeds the pre-determined value set in the data source. In this case, a filter is required and the Filter List dialog box opens with a Find button, which is used to open a second Filter Data dialog box. From here, you can create a filter that returns only those items from which you want to select. After filtering the data, the Available data list is populated with the items returned in your filter.
After you have filtered your data to a manageable list, you can select the items that you want to display in your criteria drop-down list by moving them to the Selected data list. When you click OK, the items in the Selected data list are displayed in a drop-down list in your original filter.