I have a stored procedure where I would like it to accept multiple parameters into my Crystal report. I have it working where I have to populate the Crystal parameter with the values separated by a comma. But I would ideally like to have the end user select each value from a list of choices and that in turn to concatenate the selected multiple values separated by a comma so the stored procedure variable can be used that way.
This logic works to capture multiple values in my stored procedure based on the Crystal parameter field I have. But we have to enter the values like this:
Stored procedure @Parameter = value1,value2,value3, value4 (coming from the Crystal parameter)
Which forces the user to know what they are rather the select from a provided list of choices.
(@Parameter = "*ALL" or charindex(ltrim(rtrim(database_value))+",", ltrim(rtrim(@Parameter ))+",") > 0)
Any suggestions is greatly appreciated or if anyone has come across this and can share what has worked for you.