title: Using compound conditions in my Crystal Reports SQL query
body: <p>I am trying to adjust my query to consider a compound conditional statement, i.e. :</p>
  
  <pre><code>({tablea.fielda} &lt;&gt; 5566 And Not ({tablea.fieldb} like '%889009%))
  </code></pre>
  
  <p>The initial problem was that Crystal would take that statement and remove the outside parenthesis and execute the statements independently of each other.  I thought I had a fix by putting the entire statement in a "NOT" statement and reversing the conditions, like so:</p>
  
  <pre><code> Not ({tablea.fielda} = 5566 And ({tablea.fieldb} like '%889009%))
  </code></pre>
  
  <p>Although Crystal did reverse the conditions and keep the conditions grouped, it is now changing the center <code>and</code> to an <code>or</code>.  </p>
  
  <p>This is a report that was created before my time that I am just modifying, and as such, I dont want to create a view or stored procedure that would cause me to go back and change all of the fields in the report.  Any ideas?</p>