total sums in reports, article Q132017

[Massoud]

To have total sums in my reports, I tested the instructions in the article q132017. There are two problems:
1- Applying the instructions to the Northwind sample database works well regarding the total sums, but in the case of producing the total sums of each page seperately, on some of the pages a negative number is generated that I don't know where it comes from.

2- How can we have the sum of the previous pages at the top of the next page?

Thanks

 

[barbarossaii]

Hi Massoud,

Regarding the 2nd part of your question:
try to calculate the wanted sum twice - before and after a page break...


HTH,

Barbarossa II