I am trying to pass a list of selected values on the drop down menu in CR to Store procedure written in SQL based on which the data should be retreived from the databse. Basically these list of values replace the parameter in the Where class. Please suggest how can I do this also what is the evenyt I can use .

Shan

 

for example if my identifier is company_name in the CR and it can take multiple values like 'abc,'def','xyz' and then it passes this list to store procedure where it should retrieve based on these values

 

SElect * from company_Db

where comapny_name in &Param;

 

Here it should replace &Param with the list (abc,def,xyz)