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 pt...@openoffice.org 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org