Running Total on Report

[MIKElaw]

Fairly simple report based on a table. Running Sum Over Group box, Hidden, on right of Detail section. Total in the Footer is about 4x what it should be (Added them up in Excel)
Make the Running Total box visible and run the report. The field(a calculated one) on the first line that is being summed is 533.20. The now visible box shows 18367.57
Next line shows 103.50 and the sum is now 18471.07 which is the correct difference???????

That is the running sum is OK but is starting other than at 0

Anyone any idea where to start?


Mike

 

[MIKElaw]

After steping through the code I found it


If you use a

me.detail.visible = false 'to ignore the line

The running sum includes it anyway just as it does if you set it true. So the total is not what you see on the report