Skip to Content
0
Former Member
Jan 25, 2018 at 10:03 PM

Crystal Reports: Select minimum record only

492 Views

I have a table that holds unique "entries" related to help desk tickets. Each entry is given a sequence number (assigned ascending for each entry regardless of ticket association). So, a ticket ID can have multiple entry records with ascending numbers. I need to be able to list the ticket id and only the first entry, which would be the min value of all entries. For instance:

CALLID CALLSEQ DATE TIME

0011 91038 01/01/18 8:10am

0011 91041 01/01/18 9:30am

0012 91053 01/01/18 8:45am

0012 91059 01/02/18 3:45pm

I need to return the following:

CALLID CALLSEQ DATE TIME

0011 91038 01/01/18 8:10am

0012 91053 01/01/18 8:45am

Ultimately, I need to evaluate ticket open date/times against the first entry date/time and display the DateDiff. Thanks in advance!!