In the Query Builder, click the ellipsis button for the Filter or Group Filter property to filter data at the data source level.
The Filter Editor displays filter criteria as a tree where individual nodes specify simple filter conditions. The root node is the logical operator combining all the conditions.
Click the plus button next to the operator to add a new condition or group.
You can select the required data field and comparison operator from the corresponding drop-down lists and enter an operand value in the dedicated value box.
Expand the drop-down menu for a value placeholder and select Property or Parameter to compare a data field with another data field or a report parameter. Then, click the converted placeholder and select the required item.
You can change the logical operator by clicking it and selecting the desired type.
Click the filter condition's button to delete it.
In the advanced mode, the Filter Editor allows you to type a filter string manually.