I have a report that displays a list of cars.
Some are for sale, some are on hold, some are sold... etc

car 1       Sold
car 2       Available
Car 3      sold
Car 4      under finance
...
...
Car 1      Available

All I want at the end of my report is
n car sold
n car Available

Something like COUNT(carID) WHERE Status='sold' but in Crystal, not SQL.

I'm having trouble returning values. (I'm quite a beginner in CR)

thats it. if someone can help me.