Duplicate records

[TheGirlNextDoor]

Hello,
I created two reports the first one likes fine except it does not give the item number, cost, and quantity of items used on specific work orders. When I add the item information it duplicates the work orders time materials what am I doing wrong. Please look at both reports “Report 2_6_17_10 has all the information that in but is duplicated. Please let me know what I can do to resolve this problem?

 

[Madawc]

Crystal works by 'detail lines'. When you link two records, each possible combination becomes a detail line. So if a record on Table A is linked to two records on Table B, the Table A record will appear on two separate detail lines, and any count or sum may get double the result you expect.

The solution is to group, and base your count or sum on groups. There is also 'distinct count', which ignores duplicated values.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP