Sum of Group figures 1

[idehen]

I am using CR 10 and want to get grand total of figures displayed in a group.

Example

Group name: IDNos

and have fields displayed as:

IDNos Date Amount
123 01/01/2007 220
345 01/02/2007 620
678 07/02/2007 800

The above data are all showing at the group level called IDNos.

Is there anyway i can get a GRAND TOTAL based on the Amount at the group level rather than at the data level.

The result showing at the group level is not the result of the sum figures at the detail section but rather the highest amount been automatically picked up instead.

Please advise if there's anyway of getting a grand total based on a group result.

Thanks in advance....

Solomon

 

[dgillz]

Use variables. In the group footer:

WhilePrintingRecords;
Numbervar Mytotal:=Mytotal +insert your group max field here

In the report footer:

WhilePrintingRecords;
Numbervar Mytotal;

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[idehen]

Thanks dgillz,

This has worked perfectly just how i wanted it.

Cheers mate!!