gjpollitt
Oct 3rd, 2007, 01:09 PM
Hi
On a report created with the reportviewer I have a field linked to a database
ie Fields!fuelwt.Value
When the report is run the value is displayed correctly from the database
ie 800
Problem I have is when using an expression in the 'color' property of that fields text box.
ie =Iif(Fields!fuelwt.Value >900, "Black", "Red")
Regardless of the value or the colors that I add the color is always black. Obviously if I add a color in the color properties the color is displayed OK but when I have the above entered the expression appears to be ignored
Any ideas please?
thanks
Gray
On a report created with the reportviewer I have a field linked to a database
ie Fields!fuelwt.Value
When the report is run the value is displayed correctly from the database
ie 800
Problem I have is when using an expression in the 'color' property of that fields text box.
ie =Iif(Fields!fuelwt.Value >900, "Black", "Red")
Regardless of the value or the colors that I add the color is always black. Obviously if I add a color in the color properties the color is displayed OK but when I have the above entered the expression appears to be ignored
Any ideas please?
thanks
Gray