For CR to know which record is oldest, it has to return all of them. It can't truly 'select' the oldest.
To display the oldest you can do it two ways:
1.
A. Group by Product and again by Vendor
B. Sort by date in ascending order.
C. Hide the details and put the fields on the vendor's Group Header, which will display the oldest.
2.
A. Group by Product and again by Vendor
B. Create a Minimum summary of the date
C. Add a Group Selection formula that says:
Depends on the cross-tab. But you could make the row field your group field, and then the Summarized field would be the date. Set the operation to minimum (oldest date) or maximum (newest date). Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.