Select oldest invoice from a vendor 1

[Tremplo]

I am accessing an ODBC file with multiple vendors, sometimes for the same product, and I wish to select only the earliest invoice recorded.

I will be grouping the data by product. Within this group I will be sorting by vendor number.

 

[kenhamady]

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:

Maximum ({Date},{Vendor}) = {Date}



Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[GaryWilsonCPA]

Will this work in a crosstab report.

 

[kenhamady]

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

http://www.kenhamady.com/