To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97560
------- Additional comments from [email protected] Sun Jan 11 16:22:43 +0000 2009 ------- I may have partially solved this myself. There seem to be 2 issues, only one of which is an SRB problem. The SRB issue is that it appears to be necessary to have the underlying query sorted in the same order as is required by the sorting/grouping window. This isn't documented, and is counter-intuitive. One question: does the setting of the "Analyse SQL" mean anything here - it doesn't seem to do anything! The other issue is that the queries weren't giving the correct results. i...@m reporting this separately, obviously. I'm attaching a simplified database. The requirement is the same, except that the first sort field is now called "RealCollation". As you can see, using 3 different queries gives 3 different answers. --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
