|
The report has one Parameter field, which allows the user to search the database. In an effort to make my report more user friendly, I want to allow the search criteria to not be case sensitive. Listed is what I have in my selection formula:
uppercase({STAT.NAM}) like "*"+uppercase({?Name})+"*"
where {STAT.NAM} is the field name in the database and {?Name} is the parameter field that the user enters
My report displays the correct data, but is extremely, extremely slow. When I remove the "uppercase" function, it runs very fast, which is the outcome that I want. Can anyone tell me how to solve this problem? Thanks in advance.
|