Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Newbie Q - Details section of Design Post Reply Post New Topic
Author Message
swoops
Newbie
Newbie


Joined: 06 Jun 2007
Online Status: Offline
Posts: 15
Quote swoops Replybullet Topic: Newbie Q - Details section of Design
    Posted: 06 Jun 2007 at 9:08am
Hi,
 
I have entered a row of static data in the Details section of the Design. When I preview the report, the row shows up 3 times! How do I get rid of the multiple occurences??
 
Thanks in advance for your help.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 06 Jun 2007 at 10:17am
You most likely have what is called a 'cartesian join'. This means that your are joining two tables together and the second table has multiple records for each primary key. Thus, the detail records show up multiple times. You can get rid of this by possibly cleaning up your database to get rid of bad records; using Groups to only show each record once, or doing a SELECT DISTINCT in the SQL to get rid of duplicate data.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.016 seconds.