Print Page | Close Window

suppressing duplicate records

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1779
Printed Date: 01 May 2024 at 8:32pm


Topic: suppressing duplicate records
Posted By: Jfaulk
Subject: suppressing duplicate records
Date Posted: 28 Nov 2007 at 7:26am
is there any easy way to suppress duplicate records and pull only the most recent record?


Replies:
Posted By: hilfy
Date Posted: 28 Nov 2007 at 3:53pm
Most recent record: 
1.  Add a descending sort on the posted date, last change date, or whatever field determines "most recent".  This sort will go after the innermost group.
2.  Put all of your data in either a group header section and suppress the details section.
 
Suppress Duplicate Records:
Some of this is determined by what  your data looks like.  First try turning on "Select Distinct Records" on the Database menu.  If that doesn't work, you may have to use groups instead of details to get the distinct data.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window