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
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