formula with number range 1

[mmarino]

Hi everyone, I'm using Crystal XI and connecting to a MS-SQL database.
I'm trying to get a report that selects one or multiple locations (and groups on them). Basically in SQL it would be something like "select * from table where Location in (1,2,3)".
I added a number parameter LocId and set "Allow multiple values" and "Allow discrete values" to true. The values passed could be a single number or a comma delimited list.
I was trying to do the following in the select expert:
{LocationId} in [{?LocId}]
but I get an error that says the array must be subscripted.
I'm sure it's pretty simple, but I've been searching and can't find anything like it, what I read it's confusing me even more.
Thanks in advance
mm

 

[KeertanaCR]

Hello

Just say

{LocationId} ={?LocId} in select expert>record

Thank you
Keerthana

 

[mmarino]

Thank you! I knew it had to be very simple...
Something else, how do I pass the parameter from VB6? As a string or as an array?
mm