Running total / Summary - 3 groups

[Former Member]

Dear All,

I am facing an problem in Summary / Running Total in my crystal Report. I have 3 groups as under :

1) Document Series

2) Territory

3) Transaction Details which includes Document Total

Now Example my document series is Projects and Territory is Japan and India and in Transaction Details which is document total has values of 100, 200, 300,500 for Japan and 300,400 for India

Now I am not able to bring a summary / running total of Japan which should be 1100 and for India 700 respectively.

I want summary for Document Series Also means for Projects it should show the total of 1100 + 700 = 1800

and a grand total of 1800 if its only projects series and if other series it should show projects + handling series.

Pleas help as I have tried but not been successful.

regards,

kamlesh

[Former Member · Accepted solution]

for Territory Running total

1. Field to summarize : documentTotal

2. Evaluate : for each record

3. Reset: on change of field -> Territory

Place it in Territory Group footer

for Document Series Total

1. Field to summarize : documentTotal

2. Evaluate : for each record

3. Reset: documentseries

Place it in Document Series group Footer

for Grand Total

1. Field to summarize : documentTotal

2. Evaluate : for each record

3. Reset: never

Place it in Report Footer

HTH,

Jyothi