title: Multi Value Paramerter SSRS
body: <p>I have a multi value parameter <code>@products</code> and the main dataset has to fetch data of particular ids depending on the value provided to <code>@products</code>. 
  I gave available values for @products as specific values ( a, b and c). the main query is something like </p>
  
  <pre><code>select version,date from table
  where ( @products=a and id in('1','2','3')
  or @products=b and id in ('4','5','6')
  or @products=c and id in('7','8','9'))
  </code></pre>
  
  <p>This works fine when only 1 value of <code>@products</code> is selected but throws an error on selecting multiple values.</p>
  
  <p>Can anyone please help me in fixing this.</p>