I have a crystal report that has a database field "Payee" name. I would like to use a parameter to search any string in the Payee name field and bring all the checks that has this string or Employee Name(Ex.Sandra) on it.
For Example, I have the Employee name "Sandra" in Payee name field...I should be able to get all the records that has this employee name in it....when i type this string "Sandra" in the parameter field.
Also, i have this same field "Payee" name in a subreport of this main report. I would like to bring up all the checks in there as well that has this string "Sandra" on them. Any ideas?...
What is the best approach to achieve this without affecting the performance of this report?
Thanks very much!