Problem resetting running value

[Elsje]

Hello,

I have an rdlc report with multiple groups.
I should becom the following:
- Group 1a
* group 2a total 25
......
* group 2b total 55
.......
* group 2c total 100
........
- Group 1b
* group 2a total 45
......
* group 2b total 75
.......
* group 2c total 99
........

Now i have used runningvalue because because the total of group 2b needs to be the total of group 2a and 2b. And the total of 2c needs to be the total of 2a + 2b + 2c.
But when it start a new header group 1b it should start again at 0 and now it continues. So my totals in group 1b are
group 2a: 145 instead of 45
group 2b: 220 instead of 75
group 2c: 319 instead of 99

Is there a way to reset a runningvalue when an other group1 begins?

Thanks for your help!

 

[xlbo]

runningvalue takes a 2nd parameter that defines where to restart values from:

=RunningValue(Fields!FieldName.Value,Sum,"GroupNameToRestartOn")

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question