Grand total of a field

[Folkstone]

Have been creating a report where I have created parameters to be able to choose particular dispute reasons and particular credit officers. I have created summaries however I would like to compare them to total no. of disputes whether they appear on the report or not (eg chose Credit note as a dispute reason and a particular credit officer - preview report brings up the information and a summary - Total no. of credit note disputes for (?credit officer) = 50). The problem that I am having is that I want to show another summary which is the Total no. of disputes for (?credit officer). This would then show that (?credit officer) has a total no. of disputes being 138 and within that a total no. of credit note disputes being 50.

Any ideas?
Anything will help.

 

[Madawc]

If you want to get the grand total for a database field, right click and choose Insert and Grand Total. If you want something more complex, use a Running Total.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5

Madawc Williams (East Anglia, UK)

 

[lbass]

Since you are limiting the disputes to particular reasons within the report, you could use a subreport which does not limit the type of disputes to get the total number of disputes. The subreport would be placed in the group header or footer for officer and linked by the officer ID field.

Or, you could remove the dispute criteria from the record selection formula and use it instead in a formula like:

if {?dispute} = "TypeA" then 1

Then you could insert a summary (SUM, not count) on this to get the total of a particular type of dispute. You would insert a count on the {table.dispute} field to get the subtotals or grand total per officer.

-LB

 

[Folkstone]

Thank you both. I have solved the problem now so case closed. Ended up using a subreport and shared variables which worked well.

Thanks again