Record Selection

[harding1031]

CR v9
ODBC
I have a report that requires the user enter the
location(s) for the search criteria. The parameter field is a pick list in which the user can select multiple locations, the problem is when I execute the report, crystal is expecting an array for the locations. How do I write my selection criteria to allow for one or more values for a parameter field?
For instance:
if the user selects L.A. and N.Y, how do I set this up in my record selection formula?

 

[bdreed35]

Try this in your record selection:

{table.field} in {?param_name}



~Brian

 

[harding1031]

Thank, but I tried that, but crystal was expecting and array defined variable. Not sure how to do that.

 

[lbass]

If you have your parameter set up for multiple, discrete values, then you should be able to use a record selection formula like:

{table.field} = {?parameter}

-LB

 

[kskid]

Hmmmm... I did the same in CR 8.5 and it worked for me.

Do you have your parameter set for "Allow Multiple Values"? And are you inserting them one at a time?

-LW

 

[harding1031]

OOOPS!!! Sorry BDREED, "{table.field} in {?param_name}"
works, THANKS.