I have a report and I want to render it to Excel file by the url. If the report has a parameter which allows multiple values (e.g. the name is KPI) and has no default value or availble value. I can render a excel file by the following url: http://<reportingserver>/<servername>?/<reportpath>&rs:Command=Render&rs:Format=Excel&KPI=A,B OR http://<reportingserver>/<servername>?/<reportpath>&rs:Command=Render&rs:Format=Excel&KPI=A&KPI=B But if I set the availble valus (get values from query) which are from a dataset(e.g. sharepoint list) The url above doesn't work. Can anybody tell me why? Thanks

Hi Conia, Reporting Services multi-values parameter works fine always no matter whether you set available values. For this issue, a possible cause is that if you make the multi-value parameter get available values from a query, the parameter will become case sensitive, you need to make the parameter value and the available values match case. In addition, the correct method to pass value for multi-values parameter is: http://<reportingserver>/<servername>?/<reportpath>&rs:Command=Render&rs:Format=Excel&KPI=A&KPI=B If there is anything unclear, feel free to ask. Thanks, Albert Ye