Summing over multiple groups

[Ivan Debono]

Hi all,

I have a report with 3 groups: group1, group2, and group3. I have a number
field placed on the detail section.

I want to sum up the number field and place the running total on each of the
groups, so that group1 will display the total of the detail section, group2
will display the total of group1, and group3 will display the total of
group2.

How can I do it?

Thanks,
Ivan

 

[Marshall Barton]

I have a report with 3 groups: group1, group2, and group3. I have a number
field placed on the detail section.

I want to sum up the number field and place the running total on each of the
groups, so that group1 will display the total of the detail section, group2
will display the total of group1, and group3 will display the total of
group2.

Not totally clear what you want here, but maybe this will do
it?

Add a text box to the group footer section. Set its control
source expression to =Sum(thenumberfield)
and set its RunningSum property to Over All