Using multiple value parameter in select expert 1

[akatdhare2000]

Hello,
I am using crystal reports 9.0 and want to get the records based on selection criteria. I have a number of parameters, however, one of them is a multi-value paramater. I get the values in the form of an array, however, i am not able to select the records based on the array. e.g, i want the report to fetch like
select columns from table name where some criteria and column_name in (list of values in multi-value parameter)

 

[synapsevampire]

Perhaps you want to dynamically pull certain columns? A shame you couldn't supply example dtaa and expected output, that eliminates the guess work.

The standard means to use the Report->selection formulas->Record for multiple parameters is to state:

{table.field} IN {?MyMultiParm}

Although

{table.field} = {?MyMultiParm} works as well, Crystal is forgiving.

If your problem is more complex, try using proper technical terms and supplying example dtaa and expected output rather than a description.

-k