To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110536 Issue #|110536 Summary|SRB generates wrong 'order by' on report based on quer |y with MS Access 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:52:32 +0000 2010 ------- When I've created a Query2 for MSAccess like SELECT `ID`, `Value` FROM ( SELECT `T1`.`ID`, `T1`.`Value` FROM `T2`, `T1` WHERE `T2`.`ID` = `T1`.`ID` ) `X` and make a report with grouping on field ID the query text is copied to the report source and extended with an order by. But this fails: SELECT `ID`, `Value` FROM ( SELECT `T1`.`ID`, `T1`.`Value` FROM `T2`, `T1` WHERE `T2`.`ID` = `T1`.`ID` ) `X` ORDER BY `T1`.`ID` It looks like SRB is using the meta-data API but this is returning unexpected information. For a reproduction see issue 110535. It contains a Base document with the example Query2 and the corresponding MSAccess database. 1 Make a report with the wizard 2 Select Query 2 as source 3 Select grouping on ID 4 Finish report 5 When one tries to open the report an error is shown. 6 Open report and check the data source query text and note the wrong field specification on the ORDER BY. Note that one can also specify in (most?) databases an ORDER BY with field-sequence numbers according the sequence-number of that field in the SELECT clause. --------------------------------------------------------------------- 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]
