Hi,
I have a stored procedure that has a parameter called @type. This parameter is setup to expect multiple values delimtered with a comma. The stored procedure then splits these values out and performs mutiple tasks.
My question is how can i pass mutiple values to one paramter field? eg
i would like the report to prompt asking for type, so i have a mutiple values true paramter field:
With these types available:
Type1
Type2
Type3
So the user could select Type1 and Type3 and this would get passed to the stroed procedure as Type1,Type3
Does any one have any ideas?
Many Thanks.