[Libreoffice-bugs] [Bug 50132] Provide as-is order for groups in Reports

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=50132

--- Comment #7 from Lionel Elie Mamane <lionel at mamane.lu> 2012-07-11 21:00:01 PDT ---
This is a reasonable request from an "advanced user's" point of view, I've at
times wished for a similar thing.

I'm not sure how to present it UI-wise, though.

1) Separate "grouping" and "sorting" in different dialogs?

   I think that is a bad idea, too confusing for non-expert user,
   that one has to put the same field in sorting *and* in grouping.

2) A boolean (yes/no) option on each group/sort field: sort yes/no?
   In that way, one can do grouping on a field without requesting sort
   on that field, and the UI is relatively clear.

   But what would happen if one enters the following:

   GROUP ON field foo / no sort
   SORT BY field bar

   Does it do the same as:

   SORT BY field bar
   GROUP ON field foo / no sort

   because the whole query is sorted by "bar"?
   I'm not too eager, confusing.

   Does it first group by "foo" and *within* each group,
   it sorts by "bar"?
   IMHO, it seems natural from the user's POV,
   but it would be delicate to implement,
   unless LibO does the sorting itself;
   I don't think it would be possible to delegate
   the sort to the database engine in this scenario.

3) Global switch "do not sort, only group"?
   Not sure how to present it UI-wise.
   Feels too ad-hoc.



Indeed a work-around now is (in the given example)
to include the ID in the result query,
not show the ID anywhere in the report,
sort & group by ID,
show the Category (name) in the "group by ID"
header / footer / whatever.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.