Return-Path: X-Original-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 689F6DAE5 for ; Thu, 4 Oct 2012 16:30:27 +0000 (UTC) Received: (qmail 9960 invoked by uid 500); 4 Oct 2012 16:30:27 -0000 Delivered-To: apmail-incubator-ooo-issues-archive@incubator.apache.org Received: (qmail 9931 invoked by uid 500); 4 Oct 2012 16:30:27 -0000 Mailing-List: contact ooo-issues-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-issues@incubator.apache.org Delivered-To: mailing list ooo-issues@incubator.apache.org Received: (qmail 9923 invoked by uid 99); 4 Oct 2012 16:30:27 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Oct 2012 16:30:27 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.123] (HELO sif.zones.apache.org) (140.211.11.123) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Oct 2012 16:30:25 +0000 Received: by sif.zones.apache.org (Postfix, from userid 80) id 3D7727AD2; Thu, 4 Oct 2012 16:30:04 +0000 (UTC) From: bugzilla@apache.org To: ooo-issues@incubator.apache.org Subject: [Bug 121160] New: Simple report from query remains empty Date: Thu, 04 Oct 2012 16:30:03 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: database access X-Bugzilla-Component: code X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: villeroy@t-online.de X-Bugzilla-Status: UNCONFIRMED X-Bugzilla-Priority: P3 X-Bugzilla-Assigned-To: ooo-issues@incubator.apache.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: priority bug_id assigned_to short_desc bug_severity cf_bug_type classification op_sys reporter rep_platform bug_status version component product Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://issues.apache.org/ooo/ Auto-Submitted: auto-generated MIME-Version: 1.0 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.