I have a report built in a standard LO Base file. It uses a query that
combines two tables in my film library database—one table is the detail of
the films, the other is for the “box sets”. Both tables have a cost field
that I want to accumulate in subtotals and the report total.
I have the report subtotaled by box set. My problem is with the BoxSetCost
from the BoxSet table. I can get the subtotals by box set to work, but the
report total will not. It accumulates the BoxSetCost for each film in the
set, not once for the set.
Here are a couple of things that I have tried:
I tried setting up the BoxSet.BoxSetCost subtotal as a user-defined
function, then accumulating that function in the report total. The report
total field produces an error when the report is run.
I have tried to set up a text box in the Report Total section that was
based on a separate query to simply add up the BoxSetCost field of the
BoxSet table. Apparently that is not possible.
So, here is some sample data and the results I am working toward.
For raw data like this from the query driving the report:
Film BoxSet FilmCost BoxSetCost
1 A 2.00 0.00
2 B 0.00 3.00
3 B 0.00 3.00
The report total section should show Total FilmCost of 2.00 and Total
BoxSetCost of 3.00.
Does anyone have any ideas on how to make this work?
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] Totals in Base Report · nomen
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy