Bulk updating table filters

Starting with version 6.0.1, IBM® SPSS® Data Collection Survey Reporter allows you to bulk update the filters for multiple tables. When you select multiple tables, that have the same filters, the selected tables will display as a single table. Expression and level changes for the displayed filter will apply to all selected tables.

When the selected, multiple tables have different filters, the Multiple filters place holder will display for the filter.

Multiple filter bulk update

The Multiple filters place holder indicates that the selected table filters have differing expressions or levels. The place holder can only be replaced or deleted.

Replacing the Multiple filters place holder

You can replace the place holder by selecting different variables and clicking Replace. After clicking Replace, all filters for the selected tables will be replaced with the selected variables and all filters will be set to the top level.

Deleting the Multiple filters place holder

You can delete the Multiple filters place holder by selecting the place holder and pressing the Delete key. After pressing Delete, the filters are cleared for all selected tables.

Advanced multiple table filter conditions

The Filter pane displays multiple table filters in a graphical format. The full filter expression displays in the Filter Syntax pane at the bottom of the screen. The place holder is identified in the expression as %Multiple filters%. Using the tables displayed in the image above as an example, selecting three tables that have different filters will display the following in the Filter Syntax pane:

%Multiple filters%

The %Multiple filters% place holder can only be removed or replaced in the Filter Syntax pane.

Click Apply to validate the current syntax. If the syntax is valid, the Filter pane will automatically update to display the filter conditions. If the syntax is not valid, an error will display.

Click Cancel to return the previously applied syntax.