Page 1 of 1

Running Sum in report

PostPosted: Mon Jun 09, 2014 6:54 pm
by gpaunica
HELLO,
In OPENOFFICE BASE reports can I do running sums over group like in access?
Please help me?

Re: RUNNING SUM IN REPPORT

PostPosted: Mon Jun 09, 2014 7:42 pm
by Villeroy
Same self-explaining SQL as with any other database:
Code: Select all   Expand viewCollapse view
SELECT "This", "That", SUM("Blah") AS "Sum of Blah"
FROM "Table"
GROUP BY "This", "That"