Skip to Content
0
Former Member
Apr 22, 2008 at 02:49 PM

urgent: need help on removing semi-duplicate records

10 Views

Post Author: mnguyen2032

CA Forum: Crystal Reports

when I join two tables, the resulting dataset is the following:

ID DATE FSD_ID VALUE ACCOUNT_ID PAT_NAME RECORDED_TIME Line7978945 03-Apr-08 108207 Medical 70464509 WILEY,DEJAHN 4/3/2008 3:22:00 AM 217978945 03-Apr-08 108207 Medical;Pediatric 70464509 WILEY,DEJAHN 4/3/2008 3:58:00 AM 17978965 03-Apr-08 108229 Medical 70464517 THORSEN,ZITA M 4/4/2008 3:22:00 AM 117978976 03-Apr-08 108234 Medical 70464519 SNYDER,TORI M 4/5/2008 3:22:00 AM 1

Question: How do I tell Crystal Report to pull only one distinct ID record into my report SINCE you can see that we have 2 rows of ID = 7978945 above?

Thanks so much in advance!!!!!