Hello all
I have a report where I have two nested groups.
I know there are only three standard options for running sum: None,
Over Group and Over All.
I have a MyTextBox in detail section where the data is summed over
group.
But the data is summed over the second group. When a new group begins
MyTextBox value is resetting to zero. I need a running sum over the
first group so when another second group begins MyTextBox value will
not reset to zero.
Can anyone tell me how one can make a running sum over only the first
group.
Is there some option RunningSum over first group, or can someone
suggest some VBA code to do that?
I'm using A2k2 SP3.
Thank you
Sebastian C.