Joined: 06 Jun 2007
Online Status: Offline
Posts: 15
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??
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
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