newbie0423
IS-IT--Management
I am writing a report that shows the implants that were placed in several patients. If I run this report for a day there could be twenty patients with implants.
The report fields consists of the following:
Patient Name
Implant description (there can be multiple items implanted)
CR # (unique identifier)
Date of Surgery (DOS)
Surgeon
My issue is that for every record the physician's name and date are displaying each time an implant is listed
This is my desired result
Joe Doe CR#123456 DOS 6/3/13 Surgeon: Dr. A
IMplant
Implant
Implant
this is what I'm returning
Joe Doe CR# 123456 DOS 6/3/13 Surgeon: Dr. A
Implant 6/3/13 Dr. A
Implant 6/3/13 Dr. A
Implant 6/3/13 Dr. A
I have selected the Select Distint Records funtion but this does not eliminate the problem. I have also tried using suppress if duplicate, but the problem with that is that it will eliminate the doctor's name when it needs to appear on the next record.
I am using Crystal XI
Any help will be appreciated - Thanks
The report fields consists of the following:
Patient Name
Implant description (there can be multiple items implanted)
CR # (unique identifier)
Date of Surgery (DOS)
Surgeon
My issue is that for every record the physician's name and date are displaying each time an implant is listed
This is my desired result
Joe Doe CR#123456 DOS 6/3/13 Surgeon: Dr. A
IMplant
Implant
Implant
this is what I'm returning
Joe Doe CR# 123456 DOS 6/3/13 Surgeon: Dr. A
Implant 6/3/13 Dr. A
Implant 6/3/13 Dr. A
Implant 6/3/13 Dr. A
I have selected the Select Distint Records funtion but this does not eliminate the problem. I have also tried using suppress if duplicate, but the problem with that is that it will eliminate the doctor's name when it needs to appear on the next record.
I am using Crystal XI
Any help will be appreciated - Thanks