Array in record selection

[dfwcharles]

I have a record selection fromula thats giving me some trouble.

{equipment.eqnum} like "*"&{?Eqcode}&"*"

Its works with one input parameter but when i check "allow multiple values", i get this error:

"This Array must be subscripted. For example: Array."

The cursors lands between & and {. Any suggestions. This on version 8 and SQL 2000.

Thanks

 

[lyanch]

It works if you require your users to add the wildcards when they enter their parameters.

Lisa

 

[dfwcharles]

Thanks, I guess I could live with that. I prefer that the user not have to enter the wildcard, any suggestions?

 

[mrudolph]

You could also try using the Edit Mask properties available with parameters to have the wildcard characters show up as default "hard-coded" values in the parameter and allow them to still enter whatever text necessary in between. That way they don't have to enter wildcards.

 

[Thanhly]

- I having similar problem with array parameter:

I Create a report with two parameters called "pRegion" and "pDistrict"
and define its as follow:

1. Type String,
2. Allow Mutiple values (Option Selected)
3 Discrete value(s) (Option Selected)

and from the Record selection formula I define as follow:

(ToText({Table.Region}) = {?pRegion}) AND
(Totext({EMeterInsp.ContribDist}) = {?pDistrict}

when I run the report from crystal tool,let say I selected
multiple region code pRegion = "1,3,5" and multiple District = "45,67,89"
The report fine, it display all the region and district I selected.

BUT where the report was call from Progress application the "pRegion" parameter is 1,3,5
and the district is 45,67,89 but the report display no record. Then I try to re-run from the application
with a single region "1" and District "45" but the report still give me no record.

It there any help

Thanks..