Skip to Content
avatar image
Former Member

Crystal Reports, Selecting latest apearence of group in table

0 favorite

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.

First is like this:

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

And second is like this:

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

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 :)

Report is grouped by article.name.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers