Multiples showing when doing a count

[leedy33]

Im using crystal 8.5 and what im trying to do is have a report that i can simply enter into and it will show me how many of each "Test\Method" were ran during a certain period of time. So i connected to my "Method" Field and i did a simple count on the Method.
So by setting up a range parameter i can easily pick a date range and the methods that were used during that time will show up, as will the number of how many for each method (count). The problem that im having is that for some reason i'm getting duplicates of each method and count. I have already suppressed the Dups but still some dups are present. Any suggestions would be helpful, i can also help clear up anything if need. Thanks

 

[Madawc]

Have you tried Distinct Count for Method? If that doesn't do the trick, try grouping.

Note that Crystal works by assembling all linked records into a 'row', which is also the detail line. If an account is linked to 10 transactions, the account is present in 10 'rows'.

Madawc Williams (East Anglia, UK)