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??