Ask Your Question

LO 5.3.1Base report conditional formatting [closed]

asked 2017-04-04 16:10:57 +0200

FAL gravatar image

updated 2017-04-06 08:45:59 +0200

I created a simple report from an Invoices table, where each row shows one invoice with its data. There is also a currency formatted field showing the balance, and I would like that field to be written in three different colors based on its value: black and bold if it is more than one cent, red if it's less than -1 cent, or italic and grey if between -0.01 and 0.01. I used conditional formatting on the Balance field, and at first (I only gave one condition) my report worked as expected. Later I added the other two conditions, and suddenly the conditional formatting stopped working: all the rows showed the Balance in the default Currency formatting instead of the one I chose. I tried putting back one single condition in the Conditional Formatting for the Balance field, but it took no effect. Can somebody help me? Francesco esempio.odb

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by FAL
close date 2017-04-09 18:10:06.841163

1 Answer

Sort by » oldest newest most voted

answered 2017-04-04 17:16:01 +0200

updated 2017-04-06 10:11:59 +0200

Ciao, can you attach a sample of your database? (no sensitive data).

Edit: You must use the decimal point, not a comma.

If my answer helped you, vote it with ✔ (here on the left)

image description

image description

edit flag offensive delete link more


Ciao! I don't know if I can add an attachment... I'll try to.

FAL gravatar imageFAL ( 2017-04-06 08:42:35 +0200 )edit

Ok. Added esempio.odb.

FAL gravatar imageFAL ( 2017-04-06 08:47:11 +0200 )edit

Perfect! Thank you!

FAL gravatar imageFAL ( 2017-04-09 18:09:24 +0200 )edit

Question Tools

1 follower


Asked: 2017-04-04 16:10:57 +0200

Seen: 82 times

Last updated: Apr 06 '17