title: Group By ID in Crystal
body: <p>I have data pulling via a SQL query into Crystal.</p>
  
  <p>For example:</p>
  
  <pre><code>ID    Test     Answer
  001   Test_A   A
  002   Test_B   A
  002   Test_B   NULL
  002   Test_B   B
  003   Test_B   NULL
  003   Test_B   NULL
  </code></pre>
  
  <p>Basically on Crystal Syntax, I need to do 2 things:
  1. Group by ID
  2. Create a formula for ID</p>
  
  <p>For example: </p>
  
  <ul>
  <li>If ID = 002 and so long as there's at least one value, then Yes </li>
  <li>If ID = 002 and they're all NULL values, then No</li>
  </ul>
  
  <p>Desired output:</p>
  
  <pre><code>ID     Test     Answer
  001    Test_A   Yes
  002    Test_B   Yes
  003    Test_B   No
  </code></pre>