Ok looking for some of you crystal wizards here to give me a wee hand.
Am still waiting on my crystal training but have been playing round a bit in it and have come across a bit of a problem which I can't find a solution for in the help files.

Data is storred in a SQL database which I'm linking into through ODBC - in the table there is a field CALL_OUTCOME which stores the outcomes each agent saves at the end of their calls.

Now I want to write a report that shows how many of each outcome we have per day/week/month

now i can work it out one at a time by using

{database.CALL_RESULT} = "The call result"

but how do i make it count for different types so that i have a report like :::

call outcome 1 = 400
call outcome 2 = 259
call outcome 3 = 736

and so on

any one got any ideas? and please in complete newbie terms

thanks

v_Ln