Summarizing Group Section (GoldMine user)

[sharvey90]

In my report, I have a group and a detail section (that I need).
The group breaks the report out by "user".
The detail section shows data such as activities and each activity has it's own code (for example, "A"=Appt., "CO"=Outgoing call, "CI"=Incoming call, etc.)
I want to get a total of each type of activity for each grouping.
I've already created the following formulas:
If {CONTHIST.RECTYPE}="A" then 1 else 0
If {CONTHIST.RECTYPE}="CO" then 1 else 0
If {CONTHIST.RECTYPE}="CI" then 1 else 0

What I originally tried to do is summarize each of the formulas in the group footer. This isn't working.
Next, I tried creating a running total - thinking it would work by group. This isn't working either.

My question: How can I get a total for each type of activity by user (group)?

Thanks in advance.

 

[synapsevampire]

Consider posting technical information instead of what doesn't work:

Crystal version
Database used
Example data
Expected output

If you want a summary of each type at the group footer try just inserting a Cross-Tab and place the Rectype in the columns, and the rectype in the summary section with a count.

Alternatively you can also place the rectype in the rows instead of the columns depending upon what the output should be.

-k