I've looked through the forums and can't find this answer (probably because it is too simple). I want to count the # of customers from a sales db but there are multiple records for each customer. I have tried to suppress duplicate customers but have found that the count function still includes the suppressed records. So if I have 100 records but only 20 customers, count {sales.customer} produces a result of 100. What is the simplest way to get a count of customers here? I intend to use this as a subreport in another report just to show the # of customers at the top so the report doesn't need anything else in it.

distinctcount is the simplest approach.