I have a report that gives these lines as an example to better explain my question.
CALL PERSON DISPATCHED ARRIVE TIME DIFF
001 SMITH 04:00:00 04:10:00 00:10:00
001 JONES 04:00:00 04:15:00 00:15:00
002 EDGE 15:00:00 15:17:00 00:17:00
002 OKUBO 15:00:00 15:20:00 00:20:00
002 SMITH 15:00:00 15:35:00 00:35:00
003 JOHNS 19:30:00 19:38:00 00:08:00
004 SMITH 20:45:00 21:10:00 00:25:00
Now, here's what the above report does. For each call more than one person may respond. I'm trying to suppress this further so that I only see the lowest response time for each call. For example, call 001 should only display SMITH and NOT JONES. Now, my report does sort by arrive time within each call so that the lowest time diff for each call displays first.
So, here's what I did. I took the CALL field and Suppressed if duplicated and it looks like this:
CALL PERSON DISPATCHED ARRIVE TIME DIFF
001 SMITH 04:00:00 04:10:00 00:10:00
JONES 04:00:00 04:15:00 00:15:00
002 EDGE 15:00:00 15:17:00 00:17:00
OKUBO 15:00:00 15:20:00 00:20:00
SMITH 15:00:00 15:35:00 00:35:00
003 JOHNS 19:30:00 19:38:00 00:08:00
004 SMITH 20:45:00 21:10:00 00:25:00
Currently, I just export to excel, sort by CALL, and then delete the rows without the CALL. Then, my report is complete.
However, is there a way to have Crystal do what I'm manually doing in excel. TIA
CALL PERSON DISPATCHED ARRIVE TIME DIFF
001 SMITH 04:00:00 04:10:00 00:10:00
001 JONES 04:00:00 04:15:00 00:15:00
002 EDGE 15:00:00 15:17:00 00:17:00
002 OKUBO 15:00:00 15:20:00 00:20:00
002 SMITH 15:00:00 15:35:00 00:35:00
003 JOHNS 19:30:00 19:38:00 00:08:00
004 SMITH 20:45:00 21:10:00 00:25:00
Now, here's what the above report does. For each call more than one person may respond. I'm trying to suppress this further so that I only see the lowest response time for each call. For example, call 001 should only display SMITH and NOT JONES. Now, my report does sort by arrive time within each call so that the lowest time diff for each call displays first.
So, here's what I did. I took the CALL field and Suppressed if duplicated and it looks like this:
CALL PERSON DISPATCHED ARRIVE TIME DIFF
001 SMITH 04:00:00 04:10:00 00:10:00
JONES 04:00:00 04:15:00 00:15:00
002 EDGE 15:00:00 15:17:00 00:17:00
OKUBO 15:00:00 15:20:00 00:20:00
SMITH 15:00:00 15:35:00 00:35:00
003 JOHNS 19:30:00 19:38:00 00:08:00
004 SMITH 20:45:00 21:10:00 00:25:00
Currently, I just export to excel, sort by CALL, and then delete the rows without the CALL. Then, my report is complete.
However, is there a way to have Crystal do what I'm manually doing in excel. TIA