How to zebra stripe a report in Base

English
#1

Hello. I may be phrasing my question in a way that doesn’t get an answer. So please forgive me if I just didn’t use the correct keyword, and there is already an answer.
I have the most up-to-date version of LibreOffice (updated today, May 4 2025, May the Fourth be with you!). My report is fine, I finally got it looking the way I want it, except for one thing:
I want alternating light grey and blank rows to make the report (a long list of membership) easy to read. I have tried a few formulas that go in the “detail” section. But when I preview, the report is blank except for the Headers and Footers.
I don’t know if this is an update issue, or something I’m doing wrong. Can you advise on how to do this?

Amethyst

#2

Have a look at the attached database.
Only reports, no form.
Open report “Bericht”.
Beispiel_Bericht_Zeilen_Farbwechsel_Spalten_Firebird.odb (31.6 KB)
There is created a counter in the report, called “ZählerBericht”.
There different colors will be created by conditional formatting and the expression
MOD([ZählerBericht];2)>0 for one color and
MOD([ZählerBericht];2)=0 for the other color.
Note: The colors won’t be shown in conditional formatting since LO 7.2, see bug 161250.

#3

Some time ago I did a simulacrum of a bank/credit card statement and was unable to get the zebra layout.
In Bericht (it renderizes ok of course):

#4

Have a look here: Chapter 6 Reports
Nearly all content of Base Guide is a translation of a German Base Handbuch I have written.

#5

Yes, I know your book :+1:
But I can’t see the Conditional Formatting option for the Report :thinking:
And can see nothing in FormatiertesFeld Data tab.
 
LO 24.2.7.2

#6

Click on the field. Then open Format → Conditional Formatting….

#7

Wow!
I was looking only in field Properties :expressionless:
So no use for the [FormatierstesFeld] or Count() function.
What is needed is this somewhat dummy user defined function
+ 1

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.