incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Bug 121160] New: Simple report from query remains empty
Date Thu, 04 Oct 2012 16:30:03 GMT

          Priority: P3
            Bug ID: 121160
           Summary: Simple report from query remains empty
          Severity: major
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Hardware: All
            Status: UNCONFIRMED
           Version: AOO 3.4.1
         Component: code
           Product: database access

Created attachment 79732
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.

View raw message