I am using Function in Report properties->Code to defined the colors and passing the value to this function.

However if i had to control the colors depending on numeric values ( in decimals) the follwoing function does not allow it. Any idea?

For eg

if i want to control color if status in between -0.5 to +0.5 color = Yellow

it does not allow?

If i change the GetColor(ByVal status as string) as string from string to int or numeric it gives error,

Any idea why ?

Public Function GetColor(ByVal status as string) as string

IF status <0 Then

Return "Red"

End IF

IF status > 0 Then

Return "Green"

End IF

IF status like "0" Then

Return "Yellow"

End IF

End Function