Case sensitivity in Crystal Reports

Monday 5 December 2011 @ 10:14 am

When you specify field values in Crystal Reports formulas do you have to match the case?  Well, it depends on where you are. Take this example:

{Name} = “Joe”

It would only be true when the first letter was upper case and the other two were lower case.    So what if you have values in your data that use different case patterns?  You could get around the problem with something like this:

UpperCase ( {Name}) = “JOE”

That way no matter what case is entered in the database, Crystal will convert the data to upper case before it does the comparison, so you are comparing apples to apples.

However, Crystal has a setting that can make your formulas NOT case sensitive.  See this post for more info.

(For examples of my most popular formulas, please visit the FORMULAS page on my website.)







Leave a Reply

Jeff-Net
Recrystallize Pro

Crystal Reports Server