REPORT:  My report is to include all records that have an assignment and the 1^st assignment is to be made within 4 hours of receipt of the record.

PROBLEM:  The CR Report is including all assignments, some are made the same day while others can be made days later.  I need only the 1^st assignment.

RECORD CONDITIONS: There can be multiple assignments per record.

The assignment table has a “sequence” number, but it is like “1,262,015,054”.  Then the next assignment sequence (for that record or the next record) would be 1,262,015,055, etc. 

The creation date/time of that record’s assignments are often exactly the same, down to the seconds, because they can be automatically created.

Database is SQL.  Using Crystal Reports 10.

ALREADY TRIED:  1) I checked 'Select Distinct Records' under the 'Database' menu item.  2) Grouped by the Record #.  3) Database link is an Inner Join.