title: Crystal Reports: Showing first row for one field, but sorting on a different field
body: <p>I have a report that shows three rows per item number with different transaction dates (itemnum, transdate). My issue is either the query or Crystal Reports. I want to sort on another field called UnusedMonths desc, but want to continue showing the most recent row for each ItemNum. I am able to hide the older rows in Section Expert:</p>
  
  <pre><code>   Previous ({ItemHistory.ItemNum}) = ({ItemHistory.ItemNum})
  </code></pre>
  
  <p>If I don't group ItemNum first, duplicate ItemNum will appear in the report. How do I fix this?</p>