Page 1 of 1

Get Summary of previous pages minus current

Posted: Mon May 30, 2016 1:29 pm
by 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 ! :cry:

Re: Get Summary of previous pages minus current

Posted: Mon May 30, 2016 1:51 pm
by 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..

Re: Get Summary of previous pages minus current

Posted: Tue May 31, 2016 11:04 am
by HighAley
Hello.

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

Thank you.

Re: Get Summary of previous pages minus current

Posted: Tue May 31, 2016 4:29 pm
by Parham
Sorry to ask but is there any way you could explain more ?:(

Re: Get Summary of previous pages minus current

Posted: Wed Jun 01, 2016 6:06 am
by HighAley
Hello.

You should use expression like this:

Code: Select all

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