To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110535 Issue #|110535 Summary|Report fails with error 'SQL Status: S1000' on groupin |g wiht MSAccess Component|Database access Version|OOO320m12 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|SRB Assigned to|dbaneedsconfirm Reported by|eremmel
------- Additional comments from [email protected] Wed Mar 31 19:23:22 +0000 2010 ------- When a report is made based on a query accessing MSAccess and this report is using grouping the following error is generated: Error: SQL Status: S1000 An error occurred while creating the report. Information: An exception of type com.sun.star.lang.WrappedTargetException was caught. Error: The specified field '`X`' could refer to more than one table listed in the FROM clause of your SQL statement. Error: The specified field '`X`' could refer to more than one table listed in the FROM clause of your SQL statement. This error occurs when there is more than one table in the from-clause of query involved and the field X from the select clause of that query is available in more than one table. Possible workarounds are: 1 Edit the report and change the property 'Analyze SQL command': No at the Data-tab of the root element of the report (Navigator). But than no parameters can be used. 2 Make from the query derived table and query that. (see Query2 in issueN.odb) It looks like that when 'Analyze SQL command' is active the Meta-data MSAccess interface is used, but the implementation or the interface itself has some short comings. Please find attached a reproduction document issueN.odb and a MSAccess database issueN.mdb with N is this case number. In the reproduction document one can find: Queries: Query1: query that joins two tables with same field names ID and Value. Query2: query that uses Query1 and workaround 2. Reports: q1.ReportNoGroup: report bases on query1 without grouping and with 'Analyze SQL command' is active, so runs fine. q1.ReportWithGroupingFails: report bases on query1 with grouping on ID and with 'Analyze SQL command' is active, this is failing. q1.ReportWithGroupingOK: report bases on query1 with grouping on ID and with 'Analyze SQL command' is NOT active, this is OK. q2.ReportWithGroupingOK: report bases on query2 with grouping on ID and with 'Analyze SQL command' is active, this is OK (workaround 2). --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
