title: Crystal Report Group Count
body: <p>Lets say that I have this records in a dataset:</p>
  
  <pre><code>name1        XXXXX           XXXXXX 
  name1        XXXXX           XXXXXX 
  name1        XXXXX           XXXXXX 
  name2        XXXXX           XXXXXX 
  name2        XXXXX           XXXXXX 
  name2        XXXXX           XXXXXX 
  name2        XXXXX           XXXXXX 
  </code></pre>
  
  <p>I want to create a report where i can see the sum/count of records in each names:</p>
  
  <pre><code>name1      3
  name2      4
  </code></pre>
  
  <p>How can I achieve this output? Additionally, is it possible to assign a bound field in a crystal report from a query? For example:</p>
  
  <pre><code>select name, count(name) as [Count] from tbname  group by name
  </code></pre>
  
  <p>How can I get the Count field? (if it's really not a field in a table)? </p>