title: Crystal reports, selecting latest apearence of group in table
body: <p>I am new in this Crystal Reports thing and I have problem, since my coworker usually doing this stuff is sick at home I need to figure it out my self. I have 2 tables. </p>
  
  <p>First is like this:</p>
  
  <p><code>Article.ID    Article.name Article.buyingprice
  1              aa           2.00
  2              bb           1.00
  3              cc           3.50
  4              dd           4.20
  5              ee           2.00</code></p>
  
  <p>And second is like this:</p>
  
  <p><code>Income.ID Income.article  Income.date  Income.number Income.quantity
  1          2               79100        P1            2.00
  2          1               79100        P1            3.00
  3          4               79101        P2            2.00
  4          3               79101        P2            1.00
  5          1               79101        P2            4.00
  6          5               79101        P2            1.00
  7          2               79103        P3            15.00</code>       </p>
  
  <p>What I need is formula for selecting Income.quantity from the latest Income document. For example for article aa it will be 4.00 and for article bb it will be 15. Please save my job folks :)</p>
  
  <p>Report is grouped by article.name.</p>