I have a Parameter field called ?Un 4

[sameer11]

I have a Parameter field called ?Unit ( string type) and is a allow mutliple values

If my users enter iscs000 in lower case or mixed case how can I make sure that it gets converted to Uppercase for multiple values befor it query the database. It work for one value when i do this

{tab.unitfield} = uppercase({?Unit})

When I do this i get a error(forgot what error it was something array)

{tab.unitfield} in [uppercase({?Unit})]

Please Help.

Thanks,
Sameer

 

[lbass]

If your database field is all in caps, one of the two following methods should work:

Go to report options and check "Case-Insensitive SQL Data." From what I've read this works for SQL Server, but not for Oracle, and there might be other cases where it does or does not work. So, if necessary, you could use the following method:

I just discovered this, and it does work for multiple, discrete parameter values. Go to field explorer->parameter fields->edit->set default values and at the bottom where it says "edit mask" enter: >CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
where C is repeated until it is >= maximum length of your parameter field. The ">" forces the user's entry to appear as upper case, regardless of whether they are using lower case, mixed cases, etc., as they type it in. Conversely, if your database field was all in lower case, you could use:
<CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC

Your record selection can then remain as:

{table.unitfield} = {?Unit}

Also, with parameters, you don't have to use &quot;in&quot; to include multiple values.

-LB

 

[synapsevampire]

Purdy slick there, LB*

-k

 

[chelseatech]

There is also the option to force any user input into Upper or Lower case using the Edit Mask option in the parameter specification.


Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[sameer11]

Thanks very much guys

I will try it on monday.