Operators are used in connection with a text string or numeric filter input value that determines what data to include in the report. Operators are specified by clicking on the default operator to bring up the pull-down menu of available operators.
Depending on the selected field type, text string or numeric, several filter operators are available. The filter operators are used with a filter input value to restrict the information displayed in the Detail report.
Different types of Filter Operator:
You can also use wild-cards (*) in filters to match anything. For instance, you might want to match a User name. You would select LIKE as the operator, and use * in connection with a string. For example, “joh*” would match all users starting with “joh,” such as John, Johnny, Johan, and so on.