Insert Summary. Choose these options: field: qty; Summary: Sum; Summary location: Grand Total (Report Footer).
Move the summary to the report header.
I suppose you have a report with no groups.
What do you mean with " the result is reset"? What result, and why is it reset? Anyway, even if you are grouping, I don't see why the solution I gave to you is not working.
Please, could you explain in more detail?
Joined: 15 Oct 2010
Online Status: Offline
Posts: 52
Posted: 21 Apr 2016 at 3:25pm
reset mean is the summary always return to the summary of the groups. for example : A --> 200
B --> 300
C --> 100
it is because I put group by Name. If there were no groups I can't copy as you tell into page header is like cannot copy to the area..
Let's try to clarify.
Please, read carefully my first answer. If you insert a summary with these settings, then you'll end with a Gran Total at the report header showing the value 600 which is the sum you want. Is it correct?
The result is the same whether you are grouping by Name or not.
Note I don't tell you "copy into page header". I do tell "move the summary to the report header"
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum