A Run Report Filter is used in a Run Report Function to add a filter to the data. These can be created in the Insert Run Report function wizard, or they can be created manually.
There are three parameters in the function.
| Parameter | Description |
|---|---|
| Field | The name of the field returned in the SQL. |
| Operator | The operator. |
Value | The value of the Field |
Example: =RW_Run_Report_Filter("Bank Account Number","Equals","10271-17621-619")
Operators
The full list of valid operators are:
- Equals
- Not equal to
- Less than
- Greater than
- Less or equal
- Greater or equal
- Contains
- Does not contain
- Starts with
- Is NULL
- Is Not NULL
- Advanced