title: SQL Server Report Builder 3 using SQL IN operator with parameter not working
body: <p>I am attempting to filter a dataset in SSRS using the IN operator on a single column. When I add more than one value it fails.</p>
  
  <p>For simplicity this is my SQL statement excluding other filters to focus on the new problem.</p>
  
  <p><code>SELECT * FROM vActivityDetailed WHERE Category IN (@Category)</code></p>
  
  <p>@Category is affected by an override expression under Dataset properties.</p>
  
  <pre><code>=Split(Parameters!Category.Value, ",")
  </code></pre>
  
  <p>Instead of using a multivalue parameter, I treat this as a single value and hope that by doing a split, the SSRS should execute like this.</p>
  
  <p>C# - ASP.NET Code</p>
  
  <pre><code>string categoryString = "Expenses, Misc, Accounts-Receivable";
  paramPayType.Name = "Category";
  paramPayType.Values.Add((categoryString!= "" ? categoryString : null));
  </code></pre>
  
  <p>SSRS Final SQL Execution (Expected)</p>
  
  <pre><code>SELECT * FROM vActivityDetailed WHERE Category IN ('Expenses', 'Misc', 'Accounts-Receivable')
  </code></pre>
  
  <p>Since I've tested this directly on the SQL using SQL Server Management Studio, I know the above SQL should work since it returns records, but when applied in SSRS it fails with <code>An error has occurred during report processing. (rsProcessingAborted)</code></p>