title: How to group by one field and sort by another field with Crystal Report
body: <p>I would like to group by one field and sort by another field with Crystal Report.</p>
  
  <p>For example: <code>Group A</code> with <code>PO Number</code> (sort ASC). For each PO Number, there is one Name with it and I would like to sort by <code>Name_x</code>.</p>
  
  <p>I have tried to add a field with <code>Record sort Expert</code> or I created a new group with <code>Name_x</code> and then sort by a new one but it does not work.</p>
  
  <pre><code>PO_1         Name_4
  PO_2         Name_2
  PO_3         Name_3
  PO_4         Name_1
  PO_5         Name_7
  PO_6         Name_6
  </code></pre>
  
  <p><strong>The result must be:</strong></p>
  
  <pre><code>Name_1       PO_4
  Name_2       PO_1
  Name_3       PO_1
  Name_4       PO_1
  Name_6       PO_6
  Name_7       PO_5
  </code></pre>