CAPITALISE parameter entry 3

[CR85user]

Version 8.5

I have a parameter set which is looking for partial postcode matches, The table requires an exact match - i.e.
n14 would not return a result while N14 would.

Is there an easy way to either:

1) Ignore the case of the lettering when comparing to table.field
or
2) Force the parameter to allow capital letters only on entry
or
3) Convert the parameter input to capitals if in lowercase

I appreciate that I can probably do a replace function for this but there is surely a better approach?

Thanks in advance for any help.

 

[dgillz]

The following answers #3 for you:

Uppercase({?YourParm})={YourField}

I am interested in how to force only capital letters in a parameter entry box. I am sure edit mask has something to do with it but I have never been able to figure it out.



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[lbass]

In the set default options screen->edit mask, you can enter:

>CCCCCCCCCCC

Add uppercase C's up to the maximum number of digits to be entered. The user can enter fewer values, but not more than the number of C's. The > forces the upper case.

-LB

 

[CR85user]

Two great replies, Either will function perfectly for my needs.

Remember the saying 'You learn something new every day'? With Crystal I learn something new ten times a day

Thank you both for your time.