Joined: 13 Feb 2009
Location: United States
Online Status: Offline
Posts: 5
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.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
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.
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
IP Logged
