title: Filter expression at runtime in SSRS 2008 R2
body: <p>I have applied a filter expression for group level like this in SSRS 2008 R2:</p>
  
  <pre><code>=((Fields!Cases_Shipped.Value &gt;= Parameters!CasesShipped.Value 
      And Fields!Stocked.Value In('','Yes','No'))
  Or
      (Fields!Cases_Shipped.Value &lt; Parameters!CasesShipped.Value 
      And Fields!Stocked.Value In('Yes',''))) 
  </code></pre>
  
  <p>Here <code>Cases_Shipped</code> is the name of the column in which the filter has to be applied
  when we select a value of cases shipped value from a drop down list.</p>
  
  <p><code>Stocked</code> is another column.</p>
  
  <p>Criteria is working ok at sql server but in this manner in SSRS it shows error.</p>
  
  <pre><code>The FilterExpression expression for the tablix ‘table1’ contains an error: [BC30198] ')' expected.
  </code></pre>
  
  <p>Help Please!!</p>