incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 121160] New: Simple report from query remains empty
Date Thu, 04 Oct 2012 16:30:03 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=121160

          Priority: P3
            Bug ID: 121160
          Assignee: ooo-issues@incubator.apache.org
           Summary: Simple report from query remains empty
          Severity: major
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: villeroy@t-online.de
          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.

Mime
View raw message