Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying only first date and calculating on it.

Status
Not open for further replies.

MadCatmk2

Programmer
Oct 3, 2003
145
GB
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
 
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
 
Hi Madawc

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

Thanks for the reply, its appreciated
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top