Running Sum in report

Getting your data onto paper - or the web - Discussing the reports features of Base

Running Sum in report

Postby gpaunica » Mon Jun 09, 2014 6:54 pm

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
gpaunica
 
Posts: 17
Joined: Thu Jun 05, 2014 1:23 pm

Re: RUNNING SUM IN REPPORT

Postby Villeroy » Mon Jun 09, 2014 7:42 pm

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"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27729
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests