Selection criteria slowness
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11769
Printed Date: 06 May 2024 at 5:39am
Topic: Selection criteria slowness
Posted By: VStevens
Subject: Selection criteria slowness
Date Posted: 02 Dec 2010 at 5:42am
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.
|
Replies:
Posted By: DBlank
Date Posted: 02 Dec 2010 at 8:05am
|
maybe :
{?Name} in {STAT.NAM}
|
|