Color switch due to value of output SSRS

Question

Okay im trying to show the value of the clients report and indicate if the value is bad or good with color. But instead of showing the value in color it shows the name of the color like Green instead of 33%

=SWITCH(SUM(Fields!AnserValue.Value, "qWHR") <= 33, "Green", 
SUM(Fields!AnserValue.Value, "qWHR") <= 66, "Orange",
SUM(Fields!AnserValue.Value, "qWHR") >= 65, "Red")

your displaying the name of the color itself fro your swtiches... i think it should be the rgb equivalent but not entirely sure... or could be the code for greem — RoMEoMusTDiE, Jun 02 '17 at 09:06
check this [case](https://stackoverflow.com/questions/19350144/ssrs-switch-function-to-fill-background-colour) — RoMEoMusTDiE, Jun 02 '17 at 09:35

score 2 · Accepted Answer · answered Jun 02 '17 at 09:38

2

It looks like you are setting the value of the text box and not the background colour property?

Your switch expression doesn't look like it has any problems, just make sure you are setting the appropriate property of your text box and not just the text held within it.

answered Jun 02 '17 at 09:38

iamdave

12,023
3
24
53

Any idea on how to do it otherwise? – Renier Sabre van Rooyen Jun 02 '17 at 11:16
@RenierSabrevanRooyen I have literally just told you how to do it. Go into the properties of your text box and put your `switch` expression into the `Background Color` property expression. – iamdave Jun 02 '17 at 11:17
@RenierSabrevanRooyen Here is an answer that shows you how to set the fill colour: https://stackoverflow.com/a/4993425/1350987 – iamdave Jun 02 '17 at 11:19
Sorry im very new to this xD – Renier Sabre van Rooyen Jun 02 '17 at 11:19
@RenierSabrevanRooyen If my answer turns out to be the right one, for the benefit of other Stack Overflow users please mark it as the answer. – iamdave Jun 02 '17 at 11:21
@RenierSabrevanRooyen Didn't work how? Add screenshots of what you did and the effect it had to your question. – iamdave Jun 02 '17 at 13:28
Sorry i miss understood you this was the answer for it thank you so much – Renier Sabre van Rooyen Jun 05 '17 at 12:33

Color switch due to value of output SSRS

1 Answers1