Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: suppressing duplicate records Post Reply Post New Topic
Author Message
Jfaulk
Newbie
Newbie


Joined: 27 Nov 2007
Location: United States
Online Status: Offline
Posts: 5
Quote Jfaulk Replybullet Topic: suppressing duplicate records
    Posted: 28 Nov 2007 at 7:26am
is there any easy way to suppress duplicate records and pull only the most recent record?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.