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 (220.127.116.11.alpha0+):
Author: Lionel Elie Mamane <firstname.lastname@example.org>
AuthorDate: Tue Mar 12 17:57:57 2013 +0100
Commit: Lionel Elie Mamane <email@example.com>
CommitDate: Tue Mar 12 18:16:45 2013 +0100
reportbuilder: make "Group on" not-"Each Value" actually work
So don't bother trying with anything older than that.
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
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.
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
18.104.22.168 - direct SIGABRT
22.214.171.124 - beachball requiring force kill
Version 126.96.36.199.alpha0+ (Build ID: 44019e1c9a6b2072c70de121d15ad477e38cacb)
Created attachment 84162 [details]
Shows, how multiple groupings should work (by interval) and what happens with the same group
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
Adding self to CC if not already on
Migrating Whiteboard tags to Keywords: (EasyHack DifficultyInteresting SkillCpp)
JanI is default CC for Easy Hacks (Add Jan; remove LibreOffice Dev List from CC)
Unable to see the problem -- the attachment shows reports in Base, but trying to open the Bug62248 report shows an error stating:
"The document "Bug62248" could not be opened. Column not found: INT_INT_count_Number in statement [SELECT * FROM "Bill" ORDER BY "Number", "INT_INT_count_Number", "Number"]"
Can you please upload a new document, and please provide instructions on how to exactly see the problem? I see intervals in the group settings the same field field but am not sure how to see what the grouping level is supposed to show.
It looks like the report is corrupted on saving or loading :-(
edit the report "Bug62248"
menu view / Sorting and Grouping
second line, column "Field/Expression", INT_INT_count_Number" to "Number"
with that second line selected, change properties:
Group On: Interval
Group Interval: 5
close "sorting and grouping" dialog
in toolbar, click "execute report" button
compare the result with "Bug62248_should_be". They are different. They should be the same.
I tried editing the report but got an error stating:
"An error occurred while creating the report." after executing the report. Do you know how to fix it, and should the output of the report exactly match the "should_be" report, or just some part of it?
Created attachment 172017 [details]
Shows where to change the grouping - wont be saved right.
The added screenshot will show where to change the grouping and where to set the interval the right way.
You could execute the report while editing the report. If you save the report it will show the same behavior as the report in the database I created. The second groupname will be changed and the report couldn't be executed.
(In reply to Matt K from comment #10)
> should the output of the report exactly match
> the "should_be" report, or just some part of it?
It has to exactly the same.
Interval Number 10: 10 Numbers should appear after this group header.
Interval Number 5: 5 Numbers should appear after this group header.
Each Value Number: After changing the value of the number this group header should appear for the next value.
I tried editing and saving the report but still get an error stating:
"Column not found: INT_INT_count_Number in statement [SELECT * FROM "Bill" ORDER BY "Number", "INT_INT_count_Number", "Number"]"
Is there anything else I need to change in the report to get it to work?
Created attachment 172108 [details]
screenshot showing how to execute a report without saving it
(In reply to Matt K from comment #13)
> I tried editing and saving the report but still get an error stating:
> "Column not found: INT_INT_count_Number in statement [SELECT * FROM "Bill"
> ORDER BY "Number", "INT_INT_count_Number", "Number"]"
> Is there anything else I need to change in the report to get it to work?
Don't save the report. Run it from its modification window. See this screenshot (red arrow).
(or menu Tools / Execute report)
I did what the screenshot showed and still got an error. What version are you running on?
(In reply to Matt K from comment #16)
> I did what the screenshot showed and still got an error. What version are
> you running on?
Yo have to open the report and change the second group. Then execute the report. Every time you save the report close it and reopen it the code will be wrong code.
Its the same behavior with every LO-installation here. LO 188.8.131.52 at this moment for OpenSUSE 15.2 64bit rpm Linux.