You can create a simple user defined filter parameter by applying a filter to the recordset and writing a bit of VB code
The VB code is as follows:
Public Function fnLike(ByVal val as string, ByVal Filter as string) AS Boolean
val = lcase(val)
Filter = lcase(Filter)
If len(trim(filter)) = 0 then
Return True
End If
If val.contains(filter) Then
Return True
Else
Return False
End If
End Function
To implement simply put the following in to the Filter Expression for the recordset
=code.fnLike(Fields!EMPLOYEE_NAME.Value, Parameters!PractitionerName.Value)
For the other parameters for the filter set
- Type - Boolean
- Operator "="
- Value - True
