Converting string parameter input to upper case

[mocgp]

Crystal 10; Oracle 9

Is there a way to convert parameter string values to upper case? I need to retain the * option in the parameter, so this precludes the use of the edit mask character >. I can't use the UpperCase function on the parameter in the report filter because it is set to Allow Multiple Values.

I guess another related question might be this: If there is a way to do this in Crystal Pro, will it still work once the report is published in Enterprise?

 

[mocgp]

I tried that and I get the "Array must be subscripted" error on the parameter field in line 5 - ucase({?Resource Code})

 

[lbass]

Sorry, forgot the subscript!

numbervar i;
numbervar j := ubound({?Resource Code});
stringvar x;

for i := 1 to j do(
if {ODS_TIDSCHRC.RESOURCE_CODE} like "*"+ucase({?Resource Code})+"*" then
x := x + {ODS_TIDSCHRC.RESOURCE_CODE} + ", "
);
if {?Resource Code} <> "All" then
{ODS_TIDSCHRC.RESOURCE_CODE} in x else
if {?Resource Code} = "All" then
true

-LB