title: In SQL Reporting Services, how to filter a dataset according to a parameter?
body: <p>I've got an unfiltered dataset to deal with so as to generate a report <em>(SQL Server 2005 btw)</em>. </p>
  
  <p>Let's say I've got a <em>Name</em> column, and I'd want to add a parameter to my report, so as to select only the names containing some characters.</p>
  
  <p>Does one know how to deal with these filters? </p>
  
  <p>I've tried with no luck these:</p>
  
  <pre><code>=Fields!Name.Value Like =Parameters!FilterName.Value
  
  =Fields!Name.Value = = "%" + Parameters!FilterName.Value + "%"
  </code></pre>
  
  <p>I'd like to be able to get the names 'foo' and 'foobar', if I give the parameter 'oo'</p>
  
  <p><strong>Edit:</strong> <em>I know the filtering should be done on the SQL server side, but I don't control the dataset I'm given (a webservice gives it with a no-parameters method), so I have to filter on the report side.</em></p>