Skip to Content
0
Former Member
Nov 02, 2010 at 04:04 PM

Multivalue Parameter

43 Views

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.