Displaying only first date and calculating on it.

[MadCatmk2]

Hi all.

I'm relatively new to crystal so bear with me. I have a report which is to give response times to different patient referrals and then calculate average, range, percentage values etc. At present i have a grouping on the patient referral reason and then on the patients individual number. This gives the basis to my report, but i am having a problem with the next part. At present all of the patients contacts are listed but i only require each patients first contact (maximum of the Contactdate field) to do the calculations on. I have tried to get this to work but to no avail. The closest i have got is to move the report fields from the details section to the patient number group header. When ordered in descending, this shows only the first date of contact. The problem with this method is that when i run a summary it takes all of the contacts into account, not just the visible ones in the report.
Hope this makes some sense.

Any help would be most appreciated.

Thanks in advance

 

[Madawc]

In Crystal 8.5, you can do a running total of a field that specifies the maximum value. You'd get this by grouping the data by patient.

If it's an older version of Crystal, you'll be able to get the same result using summary totals.

Madawc Williams
East Anglia, Great Britain

 

[MadCatmk2]

Hi Madawc

Thanks for that. i actually just realised myself that the running totals do that.

Thanks for the reply, its appreciated