Running Sum Changes when not visible

[sheri]

I have a subreport with a running sum which is referenced (=[RunningSum]) in
the main report under a grouping footer. When the running sum is visible it
totals properly and the referenced amount equals the running sum, but when I
change the running sum so it's no longer visible the referenced amount
changes and is off $500. This amount doesn't seem to tie to anything that i
can tell. Please help. Thanks!

 

[sheri]

Clarification: Running Sum not part of subreport - it is in the detail
section of the main report referencing to the subreport .

 

[sheri]

I've identified where the error is occuring but I still don't understand why.
Also, I mispoke in my second post the running sum is in the grouping footer
next to the subreport (also in the grouping footer). So for one of my
records it is picking up half the amount. It shows the total for the record
to be $1000 but only adds $500 to the running sum. The record is the sum of
two $500 amounts. It is not the only record with two amounts so it's not
happening every time. This is baffling.

I'm using a subreport that also has a subreport. Everything works correctly
when visible just not when invisible. Just so weird.

Clarification: Running Sum not part of subreport - it is in the detail
section of the main report referencing to the subreport .

I have a subreport with a running sum which is referenced (=[RunningSum]) in
the main report under a grouping footer. When the running sum is visible it
totals properly and the referenced amount equals the running sum, but when I
change the running sum so it's no longer visible the referenced amount
changes and is off $500. This amount doesn't seem to tie to anything that i
can tell. Please help. Thanks!