Bug 62248

Summary: REPORTBUILDER: multiple groupings on same field broken
Product: LibreOffice Reporter: Lionel Elie Mamane <lionel>
Component: DatabaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: anthony, iplaw67, libreoffice, robert
Version: 4.1.0.0.alpha0+ Master   
Hardware: All   
OS: All   
Whiteboard: EasyHack DifficultyInteresting SkillCpp
i915 platform: i915 features:
Attachments: Shows, how multiple groupings should work (by interval) and what happens with the same group

Description Lionel Elie Mamane 2013-03-12 17:28:14 UTC
In a reportbuilder report, when grouping on the same field multiple times (with different interval/prefix characters setting), the two groupings interact and in the end it does not work right; both grouping levels behave like one of them.

That's because the report function created by Report Builder for each of the groupings share the same name (!). Have to make that name unique in some way (and possibly switch to a better way of storing that information, the current system is horrible).

Note to people trying to reproduce that: Groupings on interval/prefix characters did not work at all until commit on branch master (4.1.0.0.alpha0+):


commit 4178806bb010129f3b13b62825476666fe48ddcd
Author:     Lionel Elie Mamane <lionel@mamane.lu>
AuthorDate: Tue Mar 12 17:57:57 2013 +0100
Commit:     Lionel Elie Mamane <lionel@mamane.lu>
CommitDate: Tue Mar 12 18:16:45 2013 +0100

    reportbuilder: make "Group on" not-"Each Value" actually work
    
    Change-Id: Id5d73f9aac48ebfb6987e5bf0df37e62f1817bdc


So don't bother trying with anything older than that.
Comment 1 Lionel Elie Mamane 2013-03-12 17:39:06 UTC
Code pointers:

File reportdesign/source/filter/xml/xmlExport.cxx
function ORptExport::exportGroupsExpressionAsFunction
That's where the name is chosen. Need to make it unique somehow.

Please choose a naming scheme that is predictable and stable. I mean:
 - the user that happens to know LibreOffice's implementation details knows
   what the function name is just from the grouping information
 - stable: does not change as long as the grouping information does not change

Take care that in file reportdesign/source/filter/xml/xmlGroup.cxx
function OXMLGroup::OXMLGroup
parses back what ORptExport::exportGroupsExpressionAsFunction
creates. You need to keep that in sync *but* take care of
backwards compatibility! That code needs to be able to parse
old files, that is what *old* versions of ORptExport::exportGroupsExpressionAsFunction
were creating, as well as new files.

Rather than piling up fragility in this parsing, you might want to actually take the occasion to clean up this mess by actually storing the values chosen by the user in the UI directly (in new attributes of the <group> node). See the introduction of sort-expression in commit 4178806bb010129f3b13b62825476666fe48ddcd to see what I mean. For backwards compatibility, if the new clean way is not present, fall back to parsing the group-expression attribute.
Comment 2 Alex Thurgood 2013-04-24 16:47:42 UTC
This situation, i.e. where I attempt to define, e.g. an accumulation function on the same field in both the Group Footer and Detail sections of the report,  appears to cause a mutex lock / race condition on Mac OSX, requiring a force kill of the office for all versions I have tested so far :

3.5.7 - beachball requiring force kill
3.6.5.2 - direct SIGABRT
4.0.2.2 - beachball requiring force kill
Version 4.1.0.0.alpha0+ (Build ID: 44019e1c9a6b2072c70de121d15ad477e38cacb)



Alex
Comment 3 robert 2013-08-17 08:49:49 UTC
Created attachment 84162 [details]
Shows, how multiple groupings should work (by interval) and what happens with the same group
Comment 4 Björn Michaelsen 2013-10-04 18:46:13 UTC
adding LibreOffice developer list as CC to unresolved EasyHacks for better visibility.

see e.g. http://nabble.documentfoundation.org/minutes-of-ESC-call-td4076214.html for details
Comment 5 Alex Thurgood 2015-01-03 17:39:56 UTC
Adding self to CC if not already on

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.