Who is this guide for?
Case Management Supervisors, System Supervisors and Report Writers
This guide explains how to link parameters to the filter string of your report – this enables the user to filter the report at run time.

Function | Description |
---|---|
Equals | Allows you to filter for an exact data match to the value you enter into the filter box |
Does not equal | Allows you to filter for data which does not equal the value you enter into the filter box |
Is greater than | Use for numbers or dates – report will show data where the field selected is greater than the value you enter |
Is greater than or equal to | Use for numbers or dates – report will show data where the field selected is greater than or equal to the value you enter |
Is less than | Use for numbers or dates – report will show data where the field selected is less than the value you enter |
Is less than or equal to | Use for numbers or dates – report will show data where the field selected is less than or equal to the value you enter |
Is between | Use for numbers or dates – report will show data where the field selected is between the values you enter |
Is not between | Use for numbers or dates – report will show data where the field selected is not between the values you enter |
Contains | Use for text – report will show data where the field selected contains the word or characters you enter in the filter box |
Does not contain | Use for text – report will show data where the field selected does not contain the word or characters you enter in the filter box |
Begins with | Use for text – report will show data where the field selected begins with the word or characters you enter in the filter box |
Ends with | Use for text – report will show data where the field selected ends with the word or characters you enter in the filter box |
Is like | Use for text – report will show data where the field selected contains the word or characters you enter in the filter box, use with wild card % |
Is not like | Use for text – report will show data where the field selected does not contain the word or characters you enter in the filter box, use with wild card % |
Is blank | Report on records where the field selected is blank or empty e.g. Matter Date Archived Is Blank would return all live matters |
Is not blank | Report on records where the field selected is not blank e.g. Matter Date Archived Is Not Blank would return all archived matters |
Is any of | Use with Fee Earner/Work Type filters for example, where a list is required. e.g. Matter Fee Earner ID Is Any Of ?FeeEarner would allow you to select one or many fee earners to filter the report by |
Is none of | Use with Fee Earner/Work Type filters for example, where a list is required. e.g. Matter Fee Earner ID Is None Of ?FeeEarner would allow you to exclude the chosen fee earners from your report |