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: http://nabble.documentfoundation.org/Totals-in-Base-Report-tp4067292.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
