Formatting

[papakula]

Hi,
I want to change the border color of a field depending on the data in it. Like I have field with some 50 values in it, I want to have a different border color for first 16 values or 20 values.
Many Thanks in Advance

 

[fun]

Hello All,
I am also in need of this solution. Please help .

 

[rune]

I guess it depends on what kind off data you are working with; her is how I have done it
IF {@snitt kø dag} in [0 to 19,99] then crGreen Else
IF {@snitt kø dag} in [20 to 59,99] then crYellow Else
IF {@snitt kø dag} > 60 then crRed

Rune

 

[papakula]

Rune,
Thanks, What I want is to have different colors for different values Ex: Assuming that there are 4 departments
selected by parameter then the records fetechd by first parameter should should be green
second parameter should be red
third parameter should be yellow
so on..

 

[rune]

If I anderstand you correctely this shoud work; schose "Format Field"-> "Font"-> press the "formula button" and write:
IF {parameter} = "deparment1"
Then crgreen
Else
IF {parameter} = "deparment2"
Then crred
Else etc.

Rune

 

[papakula]

Hi Rune!
Its not like that. Its not sure that first he may select
department 1, or 2.
if he selects depart 1,2,3
department 1 should be green
2 red
3 yellow

even if he select depart 3,2,1
department 3 should be green
2 red
1 yellow