Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.