I need some help with a couple of issues. I am new to Crystal and am still learning.

Issue 1:

I have records for ambulance responses. Each incident is assigned an incident number, each unit assigned to the incident is assigned a Run#, I want to track the overall response time to each incident

Unit#     IncidentID         Run#     Time of Call      Time On scene  @RespTime        @IncRespTime

FX4      51,151              243       00:00:43            00:49:44                 3.02                         3.02

43         51,151              244       00:00:43            00:50:51                 4.13            

.

The @RespTime is the response time for that unit and the @IncRespTime is the shortest response time for an Incident.

Formula for @IncRespTime.

if {@RespTime}=Minimum ({@RespTime}, {Trips.IncidentID})then Minimum ({@RespTime}, {Trips.IncidentID})else 0

I need to be able to do calculation, summaries, and possibly grouping based on that value.

But Crystal does not allow me to do summaries on that value. Any suggestions on how to address this?

Issue 2:

I have a report grouped by unit number.

 In the group header I have a field for Distinct Count Of IncidentID for that unit.

I want to be able to get a sum of all of the units Distinct Count to place in the Report Footer, but again Crystal will not do a summary on this value.

Again any help would be appreciated.

Bruce Mowrey