Filters are used to filter the dataset field by passing the specific dataset field value to limit the data in a report. It can be used to filter the data in a data regions.
To add a filter, Click on the Add icon.
Operator types are listed in the second drop-down list.
To filter specific range of data use Between operator.
To add multiple filters, follow steps 1 - 4.
Follow steps 1 - 4, to add filters.
To edit/create an expression, click on the square icon and select
Expressiondialog will be open as shown below, Refer Expression section for better understanding with the following sections.
The icon will be indicated in
Black color, if the expression is applied to the dataset field.
White color, after reset action.
To change the order of an filter, click and hold the icon in the left corner, and then drag filters to higher or lower position.
The position of dragged sort expression is shown as below:
Click Delete icon in the right corner to remove the respective filters.