title: Crystal Reports equivalent of 'WHERE'
body: <p>I'm familiar with SQL but not Crystal Reports.  I'm trying to deal with an imported data set with 5 columns:</p>
  
  <pre><code>id           deathDate           giftDate        giftAmount       Dead
  123           2008-01-06          2011-09-08       25.00          TRUE
  456           2009-06-08          2011-10-13       10.00          TRUE
  789              0                2011-12-04       50.00          FALSE
  ...
  </code></pre>
  
  <p>I'm trying to do a subquery but can't figure out what the CR equivalent of WHERE in SQL would be.  I'd like to do something along the line of:</p>
  
  <pre><code>SELECT count(id) from tab1 where dead=TRUE
  </code></pre>
  
  <p>Any suggestions?</p>