crystal-reportscrystal-reports-2008crystal-reports-2010

Crystal Reports list of total distinct values


Fairly new to Crystal Reports. If someone could point me in the right direction that would be great.

So I have a report that when run will produce the following:

ID  |   Car
-----------
1   |   Audi
2   |   Ford
3   |   Audi
4   |   Ford
5   |   Honda

In the report footer I want to produce a count of each distinct car. So for example I should have:

Audi - 2
Ford - 2
Honda - 1

Any help will be much appretiated!


Solution

  • The following should give you the desired result: