Removing Case Sensitivity on Parameter selection

[BeeBear]

Hi,

Using CR V10 still...

I know that fields are case sensitive unless you specify 'lowercase' or 'uppercase' on the field name, but how do I make it so that regardless of how the user enters the parameter text, it will still match up to the data in the field?
So I need the Parameter field to be converted to lowercase.

This is what I have in the formula at the moment, but that just allows for the name to be entered in lowercase by the user, or from the default list I have already provided, which matches the name in the field with case.

(lowercase({SPRIDEN.SPRIDEN_LAST_NAME}) like {?Name}
or
{SPRIDEN.SPRIDEN_LAST_NAME} like {?Name}
)

I thought maybe EDIT MASK "<" would do it, but I'm not sure how. as I couldnt get it to work.

Any help would be appreciated.

thanks


regards

BB

*** Count your blessings not your problems******

 

[lbass]

If you are not allowing multiple values, you can use:

lcase({SPRIDEN.SPRIDEN_LAST_NAME}) = lcase({?Name})

It would speed up your report if you converted the field in a SQL expression like this {%name}:

{fn lcase(SPRIDEN.`SPRIDEN_LAST_NAME`)}

Then change the selection formula to:

{%name} = lcase({?Name})

-LB

 

[kenhamady]

I think you could use an Edit Mask like this:

<aaaaaaaaaaaaaaaaaaaaa

The lower 'a' is an optional alphanumeric character. If you just use the < by itself as the mask CR won't let you enter anything in the parameter.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[lbass]

I forgot that option, since CR XI isn't set up to use masks like that, but I think Ken is right that it is available in CR10.

-LB