The MATCH command can be used to "match" against any data and has options for exact matching, wildcard, sounds-like, etc.

The default is to do a wildcard match which makes it straight forward for this example.

Here we're want to build a filter into a report that will pick up any course (or Activity) with "CLAIT" in the name - anywhere in the name.

Start in the report design
Go into Report Properties (off the File drown-down)
Click into the Record Filter section and type in ...

MATCH(vRA:ActivityName,'*CLAIT*')

This assumes you are using the ReportActivity in the filter
If you are using the ReportProgramme then the line would be ...

MATCH(vRAP:ActivityName,'*CLAIT*')

You can use any field/column from any report table available
The "*" is the wildcard and will match any number of characters and these can be combined in any order - e.g. "*AB*CDE*"
You could also use "?" which will match on single characters - e.g. "C?AIT"
Or, combine them - "*C?AIT*"

The MATCH command will return TRUE if (in this case) “clait” is found in the course name, so you only need this line as-is in your report filter. If you have more than one filter then you will need to AND/OR them together.

The build-in Report Filtering allows you to force filtering onto reports and has many applications - e.g. forcing a debtors report to only look at a certain group/day/period/etc.

Article ID: 7, Created: June 17, 2015 at 1:43 PM, Modified: June 17, 2015 at 1:43 PM

Wilcard filtering in reports

Add Feedback

Was this article helpful?

Share this article