Apache OpenOffice (AOO) Bugzilla – Issue 121160
Simple report from query remains empty
Last modified: 2014-06-10 08:43:31 UTC
Created attachment 79732 [details] Base document with embedded HSQLDB, queries, forms and reports The attached demo database contains a main "Data" table with foreign keys to "Categories" and "Persons". There is one query "qReport_All" to get all human readable data without any IDs from all 3 tables. Please ignore any other queries and forms. The query goes like this: SELECT "D"."D" AS "Date", "P"."N" AS "Person Name", "C"."N" AS "Category", "D"."V" AS "Value" FROM "Categories" AS "C", "Data" AS "D", "Persons" AS "P" WHERE "C"."ID" = "D"."CID" AND "P"."ID" = "D"."PID" From that query I called the old style report wizard (with no ORB installed) to create a report "qReport_All" grouped by category and person, ordered descending by values. The report does not load any data. I created the same kind of report from the "Data" table alone which works fine. Of course it is not useful because it is grouped by numeric freign keys.
I can confirm it, AOO 3.4.1 on win7.
I tested more, and it seems to me as working in Xubuntu 12.04 and win7. Your report not contains data, but if I create new report on "qReport_All" query with "old" type report wizard, it takes time to fetch all report data, but finally creates report. Set back to unconfirmed.
Created attachment 79769 [details] your database file with two new reports created under win7 qReport_All3, and qReport_All4 report created by me
Another database created on the same system as my first attachment: http://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=56785&p=250000#p249972 The job.odb contains 3 reports. Only the monthly report works.
Created attachment 80346 [details] Simple report based on a query which don't work Issue confirmed on my computer (XP with Java 1.7.0_13-b20) .Database with 2 tables linked with a simple query. Report "liste" based on one table works, report "Adresses" based on the query doesn't work.
New attachments on this issue: 1) A soccer database WordCup.odb with a query "qGroupStageReport" and 2 "old style reports" built without Report Builder extension and derived from that query. One report was make with AOO 4.1, the other with LibreOffice 3.5 under Ubuntu 12.04. 2) One of the reports saved as Writer document using AOO 4.1. It shows that the report failed to run. Any of the 2 reports gives this disappointing results with AOO 4.1. 3) The report made with AOO run by LibreOffice and saved as Writer document. It shows that LO is able to run the report but that the report design is broken, the grouping in particular. 4) The report made with LibreOffice 3.5 run by LibreOffice and saved as Writer document. It shows that LO is able to create and run the report as intended. These are the exact steps to rebuild the report: Right-click query "qGroupStageReport > "Report Wizard ..." Field selection = All Labelling = As is Grouping = Tournament, Group Sorting = Tournament, Group + Rank Layout = "Outline, indented - Highlighted" Orientation = Portrait Modified first page header. Removed page header from page style "Default"
Created attachment 83519 [details] Database document with 2 reports
Created attachment 83520 [details] AOO Writer document from AOO report
Created attachment 83521 [details] LibreOffice Writer document from AOO report
Created attachment 83522 [details] LibreOffice Writer document from LibreOffice report
Further discussion with work-arounds: https://forum.openoffice.org/en/forum/viewtopic.php?f=42&t=70257