Command buttons can be used to defer setting filters from when a control is pressed to when the command button is pressed. A command button can set all values for check boxes, list boxes and text boxes at one time, or it can be set up to control individual list boxes and text boxes.
The advantage to deferring the setting of filters is that all selections will be done at the same time, which is most efficient. In addition, when using a pure thin-client, there is one round-trip to the server versus a trip with each click. The disadvantage is that users can make mutually exclusive selections that result in no data displayed. For example, choosing Calendar Quarter 4 and January would result in no data shown.
A command button called qiqall^qiqlbxcbt activates and sets all filters based on selections made in the Quick Filters controls in the active section. A command button with a prefix other than qiqall (for example City^qiqlbxcbt) activates and sets a list box called City^qiqlbx or a text box called City^qiqtxb.
To configure Quick Filters so one command button sets multiple filters:
In Interactive Reporting Studio, press Ctrl+D to enter Design mode.
Use the command button called qiqall^qiqlbxcbt to set multiple Quick Filter controls.
Select the check box, list box, or text box to be processed by the command button; then, right-click and select Scripts.
Delete the line of script under each check box, list box, and text box for which the command button will set values.
This prevents setting the filter when the control is clicked.
Repeat to steps 3 and 4 for each additional Quick Filter control you want to set.
To configure Quick Filter command buttons associated with each list or text box:
In Interactive Reporting Studio, press Ctrl+D to enter Design mode.
Double-click a command button to display Properties.
In Name, replace qiqall with the name of the associated list or text box.
For example, to set filters for Region values, replace qiqall with Region. In this respect Interactive Reporting Studio is case-sensitive.
Enter a title to be visible to end users.
Copy and paste as many instances of the command button as required.
Select the list box or check box associated with the filter, right click and select scripts, and remove the line of code under the object.
Repeat steps 2–6 to configure each copied button.
You do not need to configure the sample button if a command button is not assigned to each list or text box.
Position the configured filter handlers in the frame.
Filter handlers are activated when selections are applied in the documents.
Click OK, and press Ctrl+D to exit Design mode.