Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: My data is repeating Post Reply Post New Topic
Author Message
pcdoc2010
Newbie
Newbie


Joined: 15 Apr 2015
Online Status: Offline
Posts: 6
Quote pcdoc2010 Replybullet Topic: My data is repeating
    Posted: 17 Apr 2015 at 5:50am
I am trying to get a report that shows me a user number, date started, product name, and product date started.

I am getting repeated data.  For example:

1 user can have 4 products. each product will have a different name and date on the system.  In my report the count of products is OK, the product date is OK, but the names all repeat.    I'm not finding what I need to adjust.
Thanks,
Dan
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Apr 2015 at 11:32am
this is your data set. If you are using multiple tables your joins are creating multiple rows.
sometimes this is expected and people use suppression or grouping options to limit what data is displayed.
IP IP Logged
pcdoc2010
Newbie
Newbie


Joined: 15 Apr 2015
Online Status: Offline
Posts: 6
Quote pcdoc2010 Replybullet Posted: 17 Apr 2015 at 11:47am
Totally spot on.  Got it figured out about 10 minutes ago!
Joins were bad.

Thanks!


Edited by pcdoc2010 - 17 Apr 2015 at 11:47am
Thanks,
Dan
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.