Crystal Reports Find duplicate entries

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Find duplicate entries

Post Reply

Post New Topic

Author	Message
barrymac1 Newbie Joined: 17 Aug 2009 Location: United States Online Status: Offline Posts: 10	Topic: Find duplicate entries Posted: 17 Aug 2009 at 12:16pm
	Have a table (person_style-view) of students (P_Unique_ID) and the courses (Course_Code) they have taken, and when they took it (Start_Date). I want to see ONLY students who have taken a course more than once. Is that enough information?
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 17 Aug 2009 at 12:29pm
	Do you want to calculate / present that all in Crystal or on the back end? In crystal here is one way. Create a formula field called "Count" as... (NOTE: guessing here as I do not know your field data types)... totext({table.p_unique_ID},0,'') + "-" + {Table.Course_Code} group on that formula field. Create a Summary of that field as a COUNT location group footer. Supress all details. Supress all GFs Condtionally supress GH as COUNT({@Count},{Count})<1
	IP Logged

barrymac1 Newbie Joined: 17 Aug 2009 Location: United States Online Status: Offline Posts: 10	Posted: 18 Aug 2009 at 5:04am
	thanks, i'll give it a try.
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum