<div>
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 &nbsp;--&gt; &nbsp;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
</div>

<div>
Thanks Buttercup1. &nbsp;Adding a second grouping under the name did the trick. 
 
Steve
</div>

<div>
<div class="content wysiwyg-content">
I'm working on a report where I need to add multiple amounts in a single group. &nbsp;Here's an example: 
 
The report now shows.... 
 
Grouped by Church Name 
 
Detail Section 
&nbsp; &nbsp; &nbsp; Amount &nbsp; &nbsp; Name 
&nbsp; &nbsp; &nbsp; &nbsp;100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John Doe 
&nbsp; &nbsp; &nbsp; &nbsp;-50 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John Doe 
&nbsp; &nbsp; &nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jane Doe 
&nbsp; &nbsp; &nbsp; &nbsp;-25 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jane Doe 
 
I need this to show... 
 
Grouped by Church 
 
Detail Section 
&nbsp; &nbsp; &nbsp; Amount &nbsp; &nbsp; Name 
&nbsp; &nbsp; &nbsp; &nbsp;50 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John Doe 
&nbsp; &nbsp; &nbsp; 175 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 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? &nbsp;I'm working with CR 2008. 
 
Thanks, 
 
Steve 

</div>
</div>

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


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  --&gt;  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

Thanks Buttercup1.  Adding a second grouping under the name did the trick.

Steve

Crystal Reports Adding up totals in details section

I&#39;m working on a report where I need to add multiple amounts in a single group.  Here&#39;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&#39;m working with CR 2008.

Thanks,

Steve


Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.