Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: data duplication in report Post Reply Post New Topic
Author Message
pfheg67
Newbie
Newbie
Avatar

Joined: 13 Feb 2009
Location: United States
Online Status: Offline
Posts: 5
Quote pfheg67 Replybullet Topic: data duplication in report
    Posted: 13 Feb 2009 at 1:16pm

Relatively new to crystal.  added a new table that grabs the team member who owns a ticket.  The problem is it is pulling the ticket # multiple times based on the different team members that have had ownership along the way.  We only want the ticket # to appear once with the team member that had last ownership.

ideas?

Patrick
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 13 Feb 2009 at 1:23pm
Are you grouping by ticket # first or by team member?
 
If you're grouping by ticket #, this is fairly simple.  Assuming that there is some sort of "assigned date" field, set up a descending sort on this field.  Then put all of the information in the group header section instead of in the details.  Because the most recent assignment is the first one, you should only see that in the header.
 
-Dell
IP IP Logged
pfheg67
Newbie
Newbie
Avatar

Joined: 13 Feb 2009
Location: United States
Online Status: Offline
Posts: 5
Quote pfheg67 Replybullet Posted: 17 Feb 2009 at 4:48am
thanks - i will give it a try.  i will try to get an example of my output if that does not work.
 
I am grouping by ticket #
Patrick
IP IP Logged
pfheg67
Newbie
Newbie
Avatar

Joined: 13 Feb 2009
Location: United States
Online Status: Offline
Posts: 5
Quote pfheg67 Replybullet Posted: 17 Feb 2009 at 9:34am
seems to have worked.  I really appreciate your help.
 
 
Patrick
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.000 seconds.