Totals of COUNT fields

[dadoggh]

I am working on a call center program. Each call generates a call number. Calls are categorized as "Open" or "Closed". I have two groups set up - the first one groups the calls by employees. The second one groups the calls by being either "Open" or "Closed". I can get the total number of "Open" or "Closed" calls to come out for each user by using the COUNT command. I would like to get a Grand Total number of "Open" and "Closed" calls. Here is what I would like to have come out:

Employee #1
Open Calls: 2 (count field)
Closed Calls: 4 (count field)

Employee #2
Open Calls: 1 (count field)
Closed Calls: 2 (count field)

-----------------------------------
Totals
-----------------------------------
Open Calls: 3
Closed Calls: 6
-----------------------------------

What would be the best way for me to get the Total number of Calls sorted by "Open" or "Closed"?

 

[IdoMillet]

Insert a CrossTab in the Report Footer to provide counts by Status (Opened versus Closed).

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com