title: Suppress Group by Condition
body: <p>I've a crystal report like this:</p>
  
  <pre><code>Page Header
         2013 &amp; 2014 Salesman Performance Report
  
  Group Header
         Salesman: {Salesman}
         Month     2013         2014
  Details
         {Month}   {2013Amt}    {2014Amt}
  Group Footer
         Total:    {#2013}      {#2014}
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>2013 &amp; 2014 Salesman Performance Report
  
  Salesman: Billy
          2013        2014
  Jan     1,000.00    0.00
  Feb     500.00      800.00
  Total   1,500.00    800.00
  
  Salesman: Keith
          2013        2014
  Jan     0.00        0.00
  Feb     0.00        0.00
  Total   0.00        0.00
  
  Salesman: Candy
          2013        2014
  Jan     (200.00)    0.00
  Feb     0.00        200.00
  Total   (200.00)    200.00
  </code></pre>
  
  <p><p>Is it possible to suppress the salesman group "Keith" if there're no transaction on 2013 &amp; 2014?</p>
  
  <hr>
  
  <p><p>Thank you for the suggestions from craig &amp; Siva. There's a problem, if the total sum for a salesman is 0 but there're transactions. How to handle it?
  <br>For example:</p>
  
  <pre><code>Salesman: Kitty
          2013        2014
  Jan     (200.00)    0.00
  Feb     200.00      0.00
  Total   0.00        0.00
  </code></pre>
  
  <hr>
  
  <p><p>I can have the finally result now although I'm not sure the method is correct or not.
  <br>Create formula field Count1 &amp; Count2 and input the following formula</p>
  
  <pre><code>Count1: If {2013Amt} &lt;&gt; 0.00 then 1 else 0
  Count2: If {2014Amt} &lt;&gt; 0.00 then 1 else 0
  </code></pre>
  
  <p><br>Then input the following formula into Group header, details and group footer (section expert> Suppress)</p>
  
  <pre><code>Sum({@Count1},{Salesman})=0 and Sum({@Count2},{Salesman})=0
  </code></pre>