Print Page | Close Window

Crystal Reports 2008 duplicate records

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15830
Printed Date: 04 May 2024 at 6:26pm


Topic: Crystal Reports 2008 duplicate records
Posted By: Pankaj_Navlekar
Subject: Crystal Reports 2008 duplicate records
Date Posted: 07 Mar 2012 at 6:00pm
Hi,
I have 2 tables in my Crystal Report-2008. Both have a common column called Project_id and one table has 10 rows and the other 17 rows. I have linked both of them in the Links section on this Project_Id column.
 
But when I am using the columns of the second table in the Detail section to create a report I am getting 170 records, which is obviously the cross join of the 2 tables. Any idea how i can bring just the unique values from this second table in the Details section
 
Regards.


Print Page | Close Window