To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=79214


User fs changed the following:

                What    |Old value                 |New value
================================================================================
                  Status|RESOLVED                  |REOPENED
--------------------------------------------------------------------------------
              Resolution|WONTFIX                   |
--------------------------------------------------------------------------------




------- Additional comments from [EMAIL PROTECTED] Fri Sep 21 19:44:03 +0000 
2007 -------
Sorry, but that's not acceptable.

The user designs a report where s/he enters a query as data source, groups this,
and the result is mere nonsense which has no relation to the grouping the user
entered (aka: asked our application to respect): this certainly is not how our
product should behave.

We could
a) strip the order from the query's statement (it is halfway meaningless,
anyway, since the grouping implies another ordering)
b) append the query's ordering to the ordering which is implied by the grouping.
That is, if the query is ORDERed BY, say, "foo", and the report is grouped by
"bar", then the statement we use when executing the report should be ORDER BY
"bar", "foo".
In this case, the grouping would be correct, and the ordering *inside* a given
group block would be as described by the query.
c) prevent grouping when the query is ordered (which isn't a valid solution
until a) and b) are proven to not work).

---------------------------------------------------------------------
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]

Reply via email to