Record selection question

[scotchjc]

Please excuse what may be a very simple question from a newbie to Crystal Reports;

I have a table containing fields for order number, position number, and sequence number as well as various other fields. I want to select only the records with the highest sequence number for any order and position combination. How do I do this?

Thanks,
John

 

[synapsevampire]

Create 3 groups:

Order
Position
Sequence

Place the fields in the group footer of the Sequence grouping and you'll get the last Sequence for that Position, which will be the highest.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com