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.