[Solved] Group Total in Report

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
wolfe69
Posts: 6
Joined: Thu Nov 15, 2012 6:13 pm

[Solved] Group Total in Report

Post by wolfe69 »

I have a report based on a query. I am trying to get a sum of the field "Truck Gross" (a calculated field created by the query, i.e. not found in the underlying table) by date.

Once I have the total by date I want to create another total that sums the date totals.

Is this possible and if so how do I accomplish this?
Last edited by Hagar Delest on Wed Nov 21, 2012 10:15 pm, edited 1 time in total.
Reason: tagged [Solved].
LibreOffice3 3.5.7.2 Build ID: 350m1 (Build:2) running on Linux Fedora 17
eremmel
Posts: 1080
Joined: Tue Dec 30, 2008 1:15 am

Re: Group Total in Report

Post by eremmel »

You can do it in the query, but that is rather complex for two sums over different groups. But you can do it also in oracle/sun report builder. See here. Note that you have to read the data in the correct order and have the report create groups at the right level (by date).
It's Microsoft marketing that tells you computers are qualified for non-technicians
W11 22H2 (build 22621), LO 7.4.2.3(x64)
wolfe69
Posts: 6
Joined: Thu Nov 15, 2012 6:13 pm

Re: Group Total in Report

Post by wolfe69 »

I actually figured it out before I was able to get back here. I just used the Accumulation(sp) function and it worked like a charm.
LibreOffice3 3.5.7.2 Build ID: 350m1 (Build:2) running on Linux Fedora 17
Post Reply