Comparison methods are used with Filters and Parameters to refine or limit the rows that are returned to a report in Microsoft Excel.
1. Add your Parameter/Filter to the Report in the Report Manager
2. Go to the Parameter/Filter Tab and select the Add Button
3. Select the Parameter/Filter Field to use. For Example: (CustomerName)
4. Then Choose your Comparison Method
Below is a list of Various Comparison Methods with an example:
| Comparison Method | Example | Search Objective | Alpha/Numeric |
| Equal To | Atlanta | True when the expression contains ‘Atlanta’. |
Both |
| Greater Than | 100 | True when the expression is greater than 100. |
Both |
| Less Than | 100 | True when the expression is less than 100. |
Both |
| Greater Than Or Equal To | 100 | True when the expression is greater than or equal to 100. |
Both |
| Less than Or Equal To | 100 | True when the expression is less than or equal to 100. |
Both |
| Is Like | %S%3% | True when the expression is contains an ‘S’ and a ‘3’ (but not before the ‘S’). |
Alpha |
| Not Equal To | Ken | True when the expression is not equal to ‘Ken’. |
Both |
| Begins With | Peach | True when the expression begins with ‘Peach’. |
Alpha |
| Ends With | K | True when the expression ends with ‘K’. |
Alpha |
| Contains | Woodridge | True when the expression contains the text ‘Woodridge’. |
Alpha |
| Does Not Begin With | doc | True when the expression does not begin with ‘doc’. |
Alpha |
| Does Not End With | s | True when the expression does not end with ‘s’. |
Alpha |
| Does Not Contain | @ | True when the expression does not contain ‘@’ symbol. |
Alpha |
| Is Not Null | True when the expression is Not Null. |
Both |
|
| Is Null | True when the expression is Null. |
Both |
|
| Is In | 1,3,4 | True when the field is equal to one of the values in the comma separated list. |
Both |
| Is Not In | 1,3,4 | True when the field is not equal to any of the values in the comma separated list. |
Both |
| Is Not Like | %S%3% | True when the expression does not container an ‘S’ and a ‘3’ (but not before the ‘S’). |
Alpha |
