question

WillFaulkner-2982 avatar image
0 Votes"
WillFaulkner-2982 asked Joyzhao-MSFT answered

Background color

Hello

I am using the current expression in SSRS:

 =IIF(Fields!.Value >="100", "red", "no color")  

to get a background colour of red if the value is >=100.

However in addition I would also like the cell to go red if the value is <=10


I have tried to nest the expression and add OR but have failed dismally so far


Please can anyone advise how the above expression could be amended so the cell turns red when the field value is >=100 or <=10 ?


Thank you





sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Rbie-6115 avatar image
1 Vote"
Rbie-6115 answered WillFaulkner-2982 commented

=IIF(Fields!.Value >="100" or Fields!.Value <="10", "red", "no color")

This works when I test it, this didn't work for you ?
If the fields is numeric omit the "

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thanks for the speedy and helpful response, which worked perfectly. have a very nice day.

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @WillFaulkner-2982 ,
I am glad to hear that your issue has been resolved. If you have any questions,please feel free to let me know.
Best Regards,
Joy

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.