Running Sum in report

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
gpaunica
Posts: 17
Joined: Thu Jun 05, 2014 1:23 pm

Running Sum in report

Post by gpaunica »

HELLO,
In OPENOFFICE BASE reports can I do running sums over group like in access?
Please help me?
openoffice 4.1.0 on windows 7
Top
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: RUNNING SUM IN REPPORT

Post by Villeroy »

Same self-explaining SQL as with any other database:

Code: Select all

SELECT "This", "That", SUM("Blah") AS "Sum of Blah"
FROM "Table" 
GROUP BY "This", "That"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Top
Post Reply

Return to “Reporting”