Passing more than one parameter value to a stored procedure...

[marydn]

Can anyone tell me if there is a way in Crystal to allow for multiple select for a parameter that is passed to a sp?

For example, I have, let's say a customer table and the end-user can select Inactive or Active customers or both. How do I get Crystal to accept both values and pass it to SQL?

Thanks!!!!!!!!!!!!

 

[JoeCrystal]

Use a Select when the user want either Active or Inactive. Use a Union when the user wants both.

 

[JoeCrystal]

Sorry I misunderstood your question. Why do you need more than one parameter. Can you use one parameter set to either "Active:, "Inactive", Or "Both" and write your stored procedure with logic to use the appropriate Select/Where clause based on the parameter.