<div>
<div class="content wysiwyg-content">
I am writing a report for my client that has a grouping by Site and a grouping by Internal Program. I then have a running total that resets on the change of grouping Internal Program which counts the distinct member id values and displays them as a total for each group. Obviously, the running total field cannot just be summed up using a summary field. Here is some sample data and what the client expects:<br />
<br />
Program 1 &nbsp; &nbsp; 50<br />
Program 2 &nbsp; &nbsp; 48<br />
Program 3 &nbsp; &nbsp; 52<br />
Program 4 &nbsp; &nbsp; 50<br />
Site total &nbsp; &nbsp; &nbsp; &nbsp;200<br />
<br />
However, if I insert another running total that resets on site and get a distinct count of the member id values for the entire site grouping, I might wind up with 145 instead of 200. &nbsp;The client wants 200, not 145.<br />
<br />
How do I accomplish this? &nbsp;I am assuming I would use variables, but have never tackled that before. &nbsp;Any example code would be greatly appreciated. &nbsp;Thanks!
</div>
</div>


I am writing a report for my client that has a grouping by Site and a grouping by Internal Program. I then have a running total that resets on the change of grouping Internal Program which counts the distinct member id values and displays them as a total for each group. Obviously, the running total field cannot just be summed up using a summary field. Here is some sample data and what the client expects:

Program 1     50
Program 2     48
Program 3     52
Program 4     50
Site total        200

However, if I insert another running total that resets on site and get a distinct count of the member id values for the entire site grouping, I might wind up with 145 instead of 200.  The client wants 200, not 145.

How do I accomplish this?  I am assuming I would use variables, but have never tackled that before.  Any example code would be greatly appreciated.  Thanks!

Summarizing Running Totals

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.