title: Passing multiple values using URL to a drop down parameter in SSRS
body: <p>I am trying to pass multiple values for a parameter in ssrs which is delimited by ','.Limiting the result data set using where condition using split function in stored proc, this gives me results of my report data set</p>
  
  <pre><code>WHERE YEAR(a.month_start_date)IN (SELECT Value FROM dbo.FnSplit(@year,','))
  --AND datename(month,month_start_date) IN (SELECT Value FROM dbo.FnSplit(@month,','))
  AND b1.branch_cd IN (SELECT Value FROM dbo.FnSplit(@branch,','))
  </code></pre>
  
  <p>I created a data set to get available values for year filter</p>
  
  <p>Configured the parameter to get available values from my filter data set and also checked option to "Allow multiple values"</p>
  
  <pre><code>Select distinct year(month_start_date) as Year
  From [DB].[dbo].[table]
  </code></pre>
  
  <p>Then I also limited my report data set to accept parameters with following condition.I configured parameter to accept the following value</p>
  
  <pre><code>=Join(Parameters!year.Value,",")
  </code></pre>
  
  <p>I pass in values in url</p>
  
  <pre><code>http://&lt;servername&gt;/ReportServer/Pages/ReportViewer.aspx?&lt;reportname&gt;rs:Command=Render&amp;year=2012,2013,2014
  </code></pre>
  
  <p>My filter does not select the values passed thru the url. The report only shows me the list of values in drop down but does not select the values parsed thru url</p>
  
  <p>I am not sure if I am missing anything else. Please suggest.</p>
  
  <p>Thanks!</p>