Condition is used to set the range of values for inclusion in the report. The conditions displayed on the combo box list will depend on the Field List Manager setup. Below are the commonly used filter conditions.
| Condition | Example | From/ To field | Description |
|---|---|---|---|
| Like | Account Description Like 'Cash on Hand' | From field is enabled. To field is disabled. | The report will search and show the data containing the entered From value. |
| Not Like | Account Description Not Like 'Cash on Hand' | From field is enabled. To field is disabled. | The report will search and show the data not containing the entered From value. |
| Starts With | Account Description Starts With 'Cash on Hand' | From field is enabled. To field is disabled. | The report will search and show the data that starts with the entered From value. |
| Ends With | Account Description Ends With 'Greenfield Admin' | From field is enabled. To field is disabled. | The report will search and show the data that ends with the entered From value. |
| Equal To | Account Description equals 'Petty Cash' | From field is enabled. To field is disabled. | The report will search and show the data equal to the entered From value. |
| Not Equal To | Account Description does not equal 'Petty Cash' | From field is enabled. To field is disabled. | The report will search and show the data that is not equal to the entered From value. |
| Greater Than | Ending Balance Greater Than '100' | From field is enabled. To field is disabled. | The report will search and show the data that is greater than the entered From value. |
| Greater Than or Equal | Ending Balance Greater Than or Equal to '100' | From field is enabled. To field is disabled. | The report will search and show the data that is greater than or equal to the entered From value. |
| Less Than | Ending Balance Less Than '100' | From field is enabled. To field is disabled. | The report will search and show the data that is less than the entered From value. |
| Less Than or Equal | Ending Balance Less Than or Equal to '100' | From field is enabled. To field is disabled. | The report will search and show the data that is less than or equal to the entered From value. |
| Between | Ending Balance Between '1' to '100' | From and To fields are enabled. | The report will search and show the data starting with From value up to the To value. |
Overview
Content Tools