Dynamic Parameter (Allow multiple values) displaying array error.

[antonx]

Hi,

I'm using Crystal Reports XI with an Oracle database.

I changed my dynamic parameter field {?Job_name} to allow multiple values. When I run the report, an error message is displayed in the Records Selection Formula Editor with the parameter field {?Job_name) highlighted.

{ZEKE_JOB_HIST_V.JOB_NM} = UpperCase ({?Job_name})

The following error message is displayed:
This array must be subscripted. For example: Array.

It's telling me that {?Job_name} must be subscripted.

I can have up to 5000 job names.

Any idea on how to solve this?

Thanks

 

[antonx]

Never mind. I found the problem.

There was no need to put the Uppercase() function.

Now it looks like this and I did not get the error:
{ZEKE_JOB_HIST_V.JOB_NM} = {?Job_name}