Bug 103387 - Record value does not show up in report even if "print repeated value on group change" is set to yes
Summary: Record value does not show up in report even if "print repeated value on grou...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.2.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-10-21 14:55 UTC by froilens
Modified: 2024-05-29 15:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
repeated value is not shown (161.28 KB, image/png)
2016-10-21 14:55 UTC, froilens
Details
example database (571.35 KB, application/vnd.oasis.opendocument.database)
2016-10-23 18:04 UTC, froilens
Details
screenshot of buggy report (338.10 KB, application/pdf)
2024-05-29 15:46 UTC, Bob Clare
Details

Note You need to log in before you can comment on or make changes to this bug.
Description froilens 2016-10-21 14:55:25 UTC
Created attachment 128128 [details]
repeated value is not shown

I the report builder if I set "print repeated value on group change" to yes it won't show up in the actual report. You can see this bug here too https://youtu.be/tuqM0_0hXdw?t=5m42s
Comment 1 Robert Großkopf 2016-10-23 16:42:30 UTC
Have had a look at the screenshot. I can't recognize what grouping you are using. So please attach an example-database and not a link to youtube or a screenshot, where nobody could know, what you expect as value for "Department".
Comment 2 froilens 2016-10-23 18:04:44 UTC
Created attachment 128192 [details]
example database

@robert I've attached the database now, do you need anything else?
Comment 3 Robert Großkopf 2016-10-23 18:26:13 UTC
(In reply to Matteo Paolini from comment #2)
> Created attachment 128192 [details]
> example database
> 
> @robert I've attached the database now, do you need anything else?

I will now have a look on the report
odb69-Employee-Info+Phone1

Could be I will give a feedback later in the evening.
Comment 4 Robert Großkopf 2016-10-23 19:15:49 UTC
Have tested with the attached database.
Seems "Print repeated value on group change" has no function.

Expected behavior is, when the group will be changed there must be a value and no empty field.
At this moment no value appears.
Also it is has no effect to set "Print repeated value on group change" to "No". Expected is here, that no value should appear when the group has been changed. But every value appears if "Print repeated values" is set to "Yes".

Tested this with OpenSUSE 42.1 64bit rpm Linux, LO 5.2.2.2, LO 5.3.0.0alpha1, LO 4.4.7.2 and also LO 3.6.7.2 
In LO 3.6.7.2 there doesn't exist the possibility of "Print repeated values", only the possibility to "Print value on group change".
Comment 5 Robert Großkopf 2016-10-23 19:30:57 UTC
Have tested it a little bit more.
You could choose this function in LO 4.1.6.2. If you set it to "Yes" the content of the field will be repeated all the time in the first group. So it didn't work right in this version, but it has an "effect".
You couldn't choose this function in LO 4.0.5.2. So could be the button has been added to the report-builder in LO 4.1.0

It seems to be introduced with bug52948
Comment 6 QA Administrators 2017-10-24 06:59:38 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2021-07-04 04:36:32 UTC Comment hidden (obsolete)
Comment 8 Robert Großkopf 2021-07-04 06:08:51 UTC
Bug appears also in LO 7.1.4.2 on OpenSUSE 15.2 64bit rpm Linux
Comment 9 QA Administrators 2021-07-05 03:46:59 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2023-07-06 03:15:14 UTC Comment hidden (obsolete)
Comment 11 Robert Großkopf 2023-07-07 09:15:22 UTC
Bug still exists with LO 7.5.5.1 on OpenSUSE 15.4 64bit rpm Linux.

Open the report
odb69-Employee-Info+Phone1
for editing and set 
Detail → Group_Name → Print repeated values → Yes
Detail → Group_Name → Print repeated value on group change → Yes

Execute and you could see all Group_Name. Have a look at Emp-ID 9,10,11 and 15. All Group_names are the same as in the Emp-ID 8 and Emp-ID 14.

Now switch
Detail → Group_Name → Print repeated values → No

There won't be shown any value for Group_Name n the group for Emp-ID 9,10,11 and 15 any more, but 
Print repeated value on group change → Yes
is set.
Comment 12 Bob Clare 2024-05-29 15:46:00 UTC
Created attachment 194429 [details]
screenshot of buggy report
Comment 13 Bob Clare 2024-05-29 15:53:50 UTC
This bug still exists in LO 7.6.5.2 (MacOS).  It appears to be a duplicate of (or closely related to) bug 52948.  At any rate, the bug still exists.  The attached screenshot shows a report where for field "#Res" "Print repeated value on group change" is set to "Yes".  The grouping is on "Address".  Each line is a "detail".  If I have "Print repeated values" set to "Yes", then I get the "2" repeated twice for the first address and twice for the second address.  I would like it printed only once per address.  However, when I do that, it doesn't get printed for the second address, ie, after the group has changed.  The same is true for addresses 3 and 4, where there is only one resident per address.

This bug seems to have been around forever, and nothing seems to have changed.  My skills at programming are not good enough to try to weave through the code that is in reportdesign...

Thanks for listening, and hopefully this bug can be squashed.