|
3
|
In New Filter Condition, shown in Figure 2-25, do the following tasks:
|
|
Figure 2-25
|
|
3
|
In Data type, verify that the displayed data type matches the data type of the column to which the filter applies. If necessary, choose a different type.
|
For example, the selections shown in Figure 2-26 name a filter called customer name filter. The filter displays the text Customer Name and provides a combo/list box control that displays values of data type string.
|
Figure 2-26
|
|
5
|
In Dynamic Filter Condition, select the operators to display on the Parameter page, and, optionally, the default operator.
|
For example, the selections shown in Figure 2-27 specify that the customer name filter displays:
|
Figure 2-27
|
Defining the source column, available operators, and a default operator for a dynamic filter
|
|
2
|
If you chose Dynamic, for Data Set, select a data set from the list, or choose Create New.
|
|
3
|
To create a new data set of values that appear in the filter prompt, create a query using the graphical or textual data set editor.
|
|
4
|
In Select value column, select the column from which to display values for the report parameter.
|
For example, the selections shown in Figure 2-28 specify a sorted list of customer name values from which a report users chooses. The customer name Atelier graphique appears as the default customer name.
In New Filter Condition, choose OK. The customer name filter appears in Filters for the customer info data set, as shown in Figure 2-29.
In Data Explorer, the customer info and customer name data sets appear in Data Sets, and the customer name filter appears in Report Parameters, as shown in Figure 2-30.
