Sum of Running Totals in Report Footer 1

[paljnad]

Hello,

I have a crystal report v 10.0 that has two groups defined:
Group A: Company Code
Group B: Entry Operator

The report currently is summarized by entry operator within a company and then by company.

A sample report would look like this:

GH1: Company 01

Detail: ABC 123 $230.00
Detail: ABC 345 $2377.00
GF2: Entry Oper: ABC - entered 2 transactions
Detail: XYZ 123 $34.00
Detail: XYZ 344 $54.00
GF2: Entry Oper: XYZ - entered 2 transactions

GF1: Total for Company 01: 4

GH1: Company 02

Detail: ABC 123 $230.00
GF2: Entry Oper: ABC - entered 1 transactions
Detail: XYZ 123 $34.00
Detail: XYZ 344 $54.00
GF2: Entry Oper: XYZ - entered 2 transactions

GF1: Total for Commpany 02: 3

I have used running totals to calculate the total by entry operator and company code and put them in GF1 and GF2.

Is there a way to display the total by entry operator in the report footer section.

So the above report in the RF section would be:
RF: Entry Oper: ABC - entered 3 transactions
Entry Oper: XYZ - entered 4 transactions

Thanks.

 

[Madawc]

Running totals can be made selective for a particular value or set of values, rather that being refreshed for each new group. The use of Crystal's automated totals is outlined at FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Is there a reason you used running totals instead of inserted summaries? If you don't have record inflation, you could simply insert a crosstab in the report footer where you use Entry Operator as the row field and a distinctcount of a unique ID that applies to each transaction as the summary.

-LB

 

[paljnad]

Thank you, lbass.

The crosstab worked like a charm.

I wanted a count so I used a running total - I guess, I just assumed that running total is the only way to get a count.

 

[lbass]

You can insert all kinds of summaries by right clicking->insert->summary. You really should use running totals as a last resort, as they process more slowly. However, there are cases when only running totals will work, so they are a necessary tool. One way of knowing whether you need a running total or could just insert a summary is that if your running total is based on evaluating all records--with no conditional formula--and you are getting the correct result in the footer, you can probably get the same correct result by inserting a summary.

-LB