That is correct, you cannot do an UpperCase on multiple values from a parameter this way. If you're familiar with SQL, this makes sense - Crystal replaces parameters in the SQL it generates by using the actual value(s) entered for the parameter. So, for example, when you enter a list of string values, you get something like this in the SQL (using Oracle syntax):
myTable.String_Field in ['Value1', 'Value2', 'Value3']
If you try to use UpperCase on the parameter, what Crystal will try to do is this:
myTable.String_Field in UpperCase(['Value1', 'Value2', 'Value3'])
This is invalid syntax for the database, you'd have to have something like this instead:
myTable.String_Field in [UpperCase('Value1'), UpperCase('Value2'), UpperCase('Value3')]
But, if you have just a single value, it works with no problems:
myTable.String_Field = UpperCase('Value1')
-Dell
IP Logged
