Skip to Content
0

Crystal Reports, Selecting latest apearence of group in table

Oct 13, 2017 at 09:07 AM

13

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers