Get Summary of previous pages minus current

[Parham]

hello
i have been struggling here with getting the summary value ,let me explain how things are atm:
i have a report that might have up to 10 pages.
on each page's start i need to show a column's summary from all the previous pages and on every pages end i need to show the columns summary of all previous pages plus the current page.

i have tried using the summary windows in which thers a running page checkbox but that option only provides the sum of start page until the current page.
ive also tried reading up forums and the web but i didnt really find anything.
would be glad if you could help,thanks !

[Parham]

I managed to make it work with the running checkbox so that it would display up to the page summary but i still dont know how to get previous pages summary..

[HighAley]

Hello.

You should use the expression where you subtract sum of the current page from the the sum with running option.

Thank you.

[Parham]

Sorry to ask but is there any way you could explain more ?:(

[HighAley]

Hello.

You should use expression like this:

Code: Select all

{cSumRunning(DataBand2,Products.UnitsInStock) - cSum(DataBand2,Products.UnitsInStock)}

Thank you.