Using colours in reports

1

I have a report where we use a colours to categorise and outcome of an intervention we run, (i.e.red, amber, green).

Using the store and formula fields and this code I have managed to change the text colour when RED is the outcome. How do I also do this for the other outcomes (AMBER AND GREEN) in the same formula? Also, how do I make that field text bold?

Code: ({outcome} ==“RED”? “”.{outcome}."" : {outcome})

Also, is it possible to colour code background of the entire record? i.e. When the outcome is green, make the background green?

image
image.png1043×136 7.03 KB

2

Jonnie,
have a look at best pratice example described in
https://spicecrm.gitbooks.io/kreporter-4-x/content/advanced/formula.html
Try a span Tag with style attribute.

Val