title: Crystal Reports Grouping
body: <p>My data looks like this.</p>
  
  <pre><code>Fruit, Apple, Fuji, 1, 1
  Vegetable, Potato, Russett, 2, 2
  Fruit, Apple, Red, 1, 3
  Fruit, Apple, Granny, 1, 2
  Vegetable, Potato, White, 2, 1
  </code></pre>
  
  <p>This data is not sorted beforehand.</p>
  
  <p>I have every field in a group (say Group1, Group2, 3, 4, and 5).  I would like for the data to read like this.</p>
  
  <p>I've creates a group combining the fields 4 and 5 using a formula.  </p>
  
  <p>The problem is when I drop my cross tab into Group 5 it keeps repeating the column header.  Whereas, if I drop into Group 4 it does not repeat the column header.  However, it does not sort on Field 5.  </p>
  
  <p>I would think there is some easy way around this.  </p>
  
  <p>TIA.</p>
  
  <p>Name</p>