This alias will be the display text for this filter within the report at runtime, if visible. The alias must be unique inside the whole report. Any duplicated value will result in an error message. The alias can contain any characters except for [” and “]”.

Open

Figure 1.1

A filter with a fixed condition (such as ‘Directorate’ always equals 'Corporate Services') should be hidden at runtime.

A mandatory or required filter will force the user to enter filter values in order to run it. Contrary to a fixed condition, a report could be more flexible if the ‘Directorate’-equals-'Corporate Services' filter is visible and not required. Then the report still shows Actions in Corporate Services by default, but the end-user can select another Directorate or even empty the value to show all Actions across Directorates.

A cascading filter will constrain the available values in other filters behind it. For example, if a report has two filters: System Period and Directorate, and a value was selected for System Period, then the only possible values that can be selected for Directorate will be ones with a match for the current System Period.

Choose sorting order for filter values: unsorted, ascending or descending by repeatedly clicking the icon.

Select the operator group Comparison, Equivalence, Field Comparison or String and select the specific operator.

Now you can enter or select the fields or values depending on each operator.

Open