Feb 17, 2005 #1 dzavad Programmer Apr 17, 2000 167 US How can i create the report showing duplicate records only? EX: Duplicate Account numbers
Feb 17, 2005 #2 dgillz Instructor Mar 2, 2001 10,045 US Right click on the field that would make it a duplicate record and select insert, summary, and make this a count summary operation. Then go into report edit selection formula, group and enter a formula like this: Count({YourField},{YourGroupingField})>1 Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports http://www.srhconsulting.com Upvote 0 Downvote
Right click on the field that would make it a duplicate record and select insert, summary, and make this a count summary operation. Then go into report edit selection formula, group and enter a formula like this: Count({YourField},{YourGroupingField})>1 Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports http://www.srhconsulting.com