# Filter Settings

The Filter Settings provide control over what filter options are exposed to users and how the drop downs within filters behave.

Names for the following Parameters can be set:

### Show Group (Min/Max) Filters

Enables/Disables the Min/Max Filter menu. Set to 'False' to disable users from using Min/Max filters.

### Show Top N Filters

(v2017.1+) Enables/Disables the Top/Bottom Filters menu in the ExpressView and Advanced Report designer. Top N filters allow users to see the highest or lowest values for a data set. Set to 'False' to disable users from using Top N filters.

### Allow New Filters at Execution

Controls the creation of new filters when a user is prompted for a filter value at the time of report execution. Set to 'False' to disable new filters from being created at execution.

### Read Database for Filter Values

Enables/Disables filter drop downs to contain values from the database. Set to 'False' only if retrieving values for the drop down will take more than a couple of seconds.

### Allow Filter Dependencies

Causes filter drop downs to retrieve values dependent on the filters above them in the menu. Set to True to enable.

> NOTE: This setting only works for Data Objects from databases and will not change drop downs from Web Services, .NET Assemblies, stored procedures, etc.

> NOTE: Drop downs after an ‘OR’ filter will not be dependent on previous filters.

### Show Filter Description

Enables/Disables reports to have a description text for the filters menu. The filter description is set in the Description tab of the New Report Wizard or the Description Menu. A help button will appear in the Filters menu and display the filter description when clicked.

### Default Filter Execution Window

Species the type of filter execution window to new reports should use by default.

- Standard – New reports display the standard filter execution window.
- Simple with Operator – New reports display a simplified filter execution window that only allows the operator and value to be changed.
- Simple without Operator – New reports display a simplified filter window that only allows the value to be changed.

### Allow User to Change Filter Window

Enables/Disables reports to change the type of filter execution window that is displayed.

### Include Null Values for 'NOT' Filters

Indicates to include NULL values for filters with using the operators ‘not equal’ or ‘not one of’.

### Custom Filter Execution Window

Specifies a control or URL that contains Custom Filter Execution Window. See Custom Filter Execution Window for more details.

### Restore All Default Date Filter Functions

(v2016.3+) Restores the default Filter Functions to the Extensions menu.

### Restore All Default Formula Functions

(v2017.2+) Restores the default Custom Functions to the Extensions menu.