Crystal Reports Adding up totals in details section

I'm working on a report where I need to add multiple amounts in a single group.  Here's an example:

The report now shows....

Grouped by Church Name

Detail Section
      Amount     Name
       100           John Doe
       -50           John Doe
      200           Jane Doe
       -25          Jane Doe

I need this to show...

Grouped by Church

Detail Section
      Amount     Name
       50           John Doe
      175           Jane Doe

I can put a running total field in the Details Section, but the report still shows each record with duplicate names.

Any ideas on getting the output above?  I'm working with CR 2008.

Thanks,

Steve
LVL 2
stkoontzAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Is the church name the NAME field or is that an additional name?

Group by the NAME field (Jane Doe/John Doe)
Put the amount field in the detail section
Right click it
Click INSERT  -->  SUMMARY
Set it as a sum
Set it to go in the NAME group
CLick OK

You can drag it to the group header and put it next to the name or drag the name to the gorup footer
Suppress the details section

mlmcc
0
Simone BSenior E-Commerce AnalystCommented:
I've used this often in previous versions of Crystal. You should be able to add another group, grouping by the person's name. Put the sum beside the person's name, and hide the detail section. In this way, the secondary group essentially becomes your detail.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
stkoontzAuthor Commented:
Thanks Buttercup1.  Adding a second grouping under the name did the trick.

Steve
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.