Reports are highly customizable. One can customize each field in the way he wants to.
Select the field you want to modify, in the Structure tab, in the Style window, set the parameter you want to the value you want.
The + button on the side, gives you the availability to do conditional customization based on a parameters using OpenFormula.
For example : According to note parameter, I’d like the text to be red if note < 50, else green. I would hit the + button next to text-color and specify the following OpenFormula =IF([note] < 50;”#ff0000″;#00ff00″)
How can I define a specific pattern for my field?
Select the field you want to modify, go to the Structure tab, in the Attributes window.
In the format parameter, inside the pattern you want your value to have. Here are some examples :
- Date : yyyy/MM/dd | dd/MM/yyyy
- Percent : #% | 0% | 0.00%
- Amount : $#,###.00 | $# | $#.##