SQL Server Performance

multivalued parameters for stored procedure in ssrs

Discussion in 'SQL Server 2005 Reporting Services' started by kcrocks, Aug 7, 2008.

  1. kcrocks New Member

    hi,
    i have a stored procedure and has 3 parameters, like projectname,project leader, dept. i am able to pass single value using sp,but multiple values using a query. when i use select all in the drop down box of the parameter list, it takes value in csv format? isnt it? so if i am using the sp it is not accepting multiple value , i mean if i select the select all check box, i am unable to generate the report, but query works fine with the select all option.
    so can anyone tell me the way in which a sp can accept the multiple values in each parameter??
  2. preethi Member

  3. kcrocks New Member

    THANK YOU
  4. Madhivanan Moderator

  5. preethi Member

  6. Madhivanan Moderator

    <P mce_keep="true">[quote user="preethi"] <P>[quote user="Madhivanan"] <P>The first link throws with the error <STRONG>Bad RequestBad Request</STRONG></P><P>[/quote]</P><P mce_keep="true">&nbsp;</P><P>That is a nice way of pointing my Double paste error <IMG alt="Big Smile" src="http://sql-server-performance.com/Community/emoticons/emotion-2.gif"></P><P><A href="http://weblogs.asp.net/jmoon/archive/2005/04/01/396649.aspx">http://weblogs.asp.net/jmoon/archive/2005/04/01/396649.aspx</A>&nbsp;is the first link&nbsp;</P><P mce_keep="true">&nbsp;</P><P>[/quote]</P><P>Thanks [:)]</P>

Share This Page