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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Eliminating duplicate names

Status
Not open for further replies.

newbie0423

IS-IT--Management
Oct 29, 2012
103
US
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

 
I found a previus post that did exactly what I needed it to do. Thanks you

not onfirstrecord and
{v_basic_case_rec_data.surg_descr} = previous({v_basic_case_rec_data.surg_descr})

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top