title: WHERE clause in SSRS expression
body: <p>What's the syntax for inserting a <code>WHERE</code> clause in an <code>SSRS expression</code>? I am using <code>BIDS 2008</code>.</p>
  
  <pre><code>=Sum(Fields!QuantityToShip.Value) WHERE FIELDS!Program.Value = "FC"
  </code></pre>
  
  <p>The code listed above represents the logic I want to use, but obviously inserting the <code>WHERE</code> in there creates a syntax error.</p>
  
  <p>The purpose of this expression is to define a series' value field in a stacked bar chart.</p>
  
  <p>Any help would be greatly appreciated!</p>