Dynamically Dropping a Filter Condition in the Data Binding Wizard
A parameterized filter condition can be dynamically dropped by passing null as the parameter value. To allow a condition to be dropped this way, follow the steps below:
1. Specify the desired parameterized condition using the Conditions tab (see Filtering Data in Data Binding Wizard), and exit the 'Data Binding' dialog box.
2. Select the 'Parameter' option from the Style Studio Report menu. This opens the 'Parameter Definition' dialog box.
3. In the 'Parameter List' panel, select the desired parameter name.
4. Click the 'Set Selection List' button.
5. Under the List tab, click the 'Add' button.
6. In the 'Label' column, enter the text “All” (without quotes) or something similar.
7. In the 'Value' column, enter “null” (without quotes).
8. Click 'OK' to close the 'Selection List' dialog box.
9. Click 'OK' to close the 'Parameter Definition' dialog box.
You can achieve the same effect by using the onLoad script of a report by using the following syntax.
parameter.{parameter name} = null;
For example, “parameter.state = null” drops any condition that uses the 'state' parameter. See onLoad Handler in Report Scripting for more details.
As described above, setting the value of a parameter (in a parametrized filter condition) to NULL effectively drops the filtering condition. In order to explicitly filter null values or empty string values, you should use the key words. 'NULL_VALUE' and 'EMPTY_STRING'.
| << Reserved Parameter Names | © 1996-2013 InetSoft Technology Corporation (v11.4) | 6.2.5 Grouping and Summarization in Data Binding Wizard >> |