I don't know if this will help, but if there are multiple rows in the second table that relate to a row in the first table, the row from the first table will repeat once for each unique value from the second table. The solution is to put the info from the second table that is repeating into a subreport, and link the subreport to the first table, which is in the main report.
So, for example, say you have a vendor, which has 3 order records in their own table related to this vendor. All the info about the vendor from the vendor table will probably repeat once for each of those three records unless you put them in a subreport. Or at least, that's what I've found to happen with me when I have two tables linked together, one of which has more than one row for each row fro the other one.
I'm not entirely sure this is what's happening for you, there are other reasons that things repeat, but maybe it'll help.
Just a thought on this one - it sounds to me like there is more than one record for each "Vendor Name" in the Vendor table and so that is why you are getting duplicates.
I would want to find out the root cause of why and try creating a silly little report just on the Vendors table grouping by Vendor Name and showing all of the data set (ie all columns from the table). If I insert a count (not a distinct count, though) on the "Vendor Name" field which is evaluated on each Group and then set a group selection criteria to ignore any groups where the count is only 1. This should show where duplicates are occuring. Then I would study the results to spot a field that I can filter on so that I only get one line out per vendor and put that into my selection criteria in the originial report and then the duplicates may disappear.
Does this sound anything like your original problem?
I have another idea involving the unique field if you are using SQL and then a running total, but that's much harder to deliver.
Here we are two years later and this problem continues to plague me to no end.
Every time I try and reference fields that are linked to a table which is linked to another table I get duplicate recoreds. I've tried every possible join combination I can think of in the current situation I'm working on and I can't get the duplicates to go away.
I've also tried to improve the join links to no avail.
I would appreciate if any experienced Crystal users could explain to me thier reasoning when the do table joins. I am not an expert with the whole "Join from"; "Join to" and enforcement states even though I've read the helpfile at length.
If anyone could offer advice on preventing duplicates in CR I would be forever in your debt.
What is the data you are reporting on stored in? Is it a SQL database? Or an Excel spreadsheet? Or what?
With regard to joins, an equal join means the data must be in both tables, whereas an outer join means the data is in one table, but does not need to be in the other.
So if I have Table 1 containing "A", "AA", "AB", "BB" and I link that field to Table 2 which contains values "A", "AB", "D", "E" in the corresponding field. With an equal join, only the entries showing "A" and "AB" will appear in the report. If I use a left-outer join from Table 1 and then report on the entries I will get "A", "AA", "AB", "BB" from Table 1 and I will get "A", <NULL>, "AB", <NULL> from Table 2. On a report the <NULL> will just appear as a blank or empty space. If you start using these fields in formulae then yiou have to think carefully about what you are doing and what you want.
Coming back to your duplicate records, there must be a reason for it and knowing the underlying data structure will help. If I get anything like this then I write the simplest possible reports with just the 2 tables at question and try and zero in on one set of results that exhibit the problem and then start hunting through ALL of the fields to try and spot what is duplicating and how I can find a better unique join. Is it still the Orders and Vendors tables that you are wrestling with?