Hello. Very basic database to maintain a church directory. I have a simple report that groups by families. I have the “Print repeated values” set to “No” on the last name but also have “Print repeated value on group change” set to “yes”. The report is grouping properly and splitting families properly but when the same last name is encountered it doesn’t print the name again. So, for example last name “Jones” is printed once for each person in the John Jones family. The Sam jones family is the next group. it’s broken down properly and shows the correct family members in the group but it doesn’t print the last name since it’s the same. It appears to be working correctly in every other way. Any thoughts on what I may be doing wrong on that setup?
Hello,
Appears this is a reported bug and has been untouched in quite some time - tdf#103387
It’s now 2024, and this bug is still there. I have added a comment to tdf#103387 and I guess we’ll just have to see what happens next.
@dr_bob,
this feature has never been implemented and probably never will.
.
If it’s important to you then it can be achieved by including a value in your query which triggers the conditional print expression in the report.
.
I had no problems in achieving the objective using a families database as described by the original poster but many families are not perfect and do not share the same surname, unmarried parents sometimes with children from previous relationships, etc. therefore I have uploaded a different database.
.
the attachment uses countries, cities and populations to demonstrate the fix.
there are 2 identical queries, 1 saved using direct mode so that it can be easily read by humans the other saved in design view is base friendly and the data-source for the report.
.
a sub-query selects a single record which consists of 2 fields “CountryID” and MIN(“tCountry” “tCity”.“Name”) from the table “tCity” which is then left joined to the table “tCity” (“c3”).
.
in the report grouping and sorting are important.
the Detail pane text boxes [Continent] and [Country] use the Conditional Print Expression [mn_name]>"", it really is that simple.
Populations.odb (21.5 KB)
Dear @cpb
Thank you for this workaround! It works perfectly! I had been wracking my brain trying to figure out how to differentiate similar records in a query. Your trick is perfect. The only issue that I had, which is a weird one, but we are dealing with LibreOffice, is that I had to format the field, that I had the conditional print on, as “Text” rather than “Number”. I had it as number, since it is an integer. It was still printing even when the conditional print should have said “No”. Switching the formatting to text fixed that. The field is now printed only when the conditional print is true.
Again, thanks for the tip! Now I don’t really care when or whether bug tdf#103387 gets fixed…
same here T_T
I did report this bug again
https://bugs.documentfoundation.org/show_bug.cgi?id=136815
Duplicate bug reports will get closed. Commenting on original bug provides more support that others are looking for a solution.