When the old style report does not start, you should open the underlying query and check the 'direct SQL' option (menu:Edit>'Run SQL directly'), save the query and re-run the report. LibreOffice comes with ORB preinstalled, does not offer the creation of old style reports but still opens old style reports. The latter supports charts, pictures, multi-level grouping and sub-reports. The old style OpenOffice reports with plain Writer tables and the advanced reports created with Oracel Report Builder extension. How can I add totals to my report? The query I have lists the details of sales activity pretty well for the most part but how do I total all the commissions for each agency and count the number of sales for each agency? I don't see any way to do that? When I've created a report via the wizard and saved it, how do I change the things that I set within the wizard after I've completed the save? For instance, if I want to change the sort order after I've saved, how do I do that? Right-clicking on the report and choosing Edit lets me do things regarding the format of the report but I'm darned if I can find a way to change sort sequence or any of the others things I chose in the wizard. I've tried omitting the ORDER BY and controlling the sequence entirely from within the report but that never gives the desired result either.ģ. I get a few rows of the first agency, then a few rows of the second agency, then the remaining rows of the first agency, then the remaining rows of the second agency. When I use an ORDER BY AGENCY, ORDER_DATE clause in my query, the report does NOT show the rows such that all the rows of a given Agency appear together. I've got one report based on the query where it always prompts for the variables but the other reports based on the same query NEVER prompt for the variables, they just show the default report with the Latin text. However, when I base a report on that same query and then run the report, it's very hit or miss whether the report will prompt for the variables. When I run the query directly, it prompts for the variable values and the query executes successfully. I've got a rather simple report based on a query that includes two run-time variables. I'm rather new to Base but I'm quite familiar with databases in general.ġ.

Openoffice base report latin