Dynamic parameter in report selection formula

[jnujella]

HI all,

I am working with crystal reports version XI release 2
I have a report where I am using the dynamic parameters.
And it has got multiple value selection.

The dynamic parameter is country.
It is displaying all the countries like country 1 to country n
User can select any number of coutnries from 0 to n.

I have show the records related to that particular countries.So i have wrote an record selection formula like
{tablename.field} in [{?Names}].

HOwever it is throwing error like "The array must be subscripted. For example : Array"

How can i correct the foumula

Thanks for any help extented.

 

[lbass]

Remove the square brackets:

{tablename.field} in {?Names}

-LB

 

[jnujella]

so easy ha....
thanks for your help ....
can you explain what was the difference between these two just throw some light if you can even other wise I am fine as my report worked..

Thank you so much for your help

 

[lbass]

While the values in the parameter do constitute an array, by adding the brackets, the formula was looking for more than one element, with the parameter field itself representing only the first element in the array. Then because that one element could have multiple values, the formula was looking for the subscript to limit it to one value.

-LB

 

[jnujella]

Thank you