https://issues.apache.org/ooo/show_bug.cgi?id=121160
Priority: P3
Bug ID: 121160
Assignee: [email protected]
Summary: Simple report from query remains empty
Severity: major
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: AOO 3.4.1
Component: code
Product: database access
Created attachment 79732
--> https://issues.apache.org/ooo/attachment.cgi?id=79732&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
