reporting-services
I try to change the value color of my report.
Green if the value is greater than 85
Red if the value is less than 70
yellow if the value is greater than 70
I tried it with the Switch statement:
=SWITCH(Fields!System.Value < 70, "Red", Fields!System.Value > 70, "Yellow", Fields!System.Value >= 85, "Green")
But it shows not the changing of color but it shows me this here:
how can I change the color of the values?
No reason this shouldn't be working.
You can set the Color property for a Text Box and it should be fine.
=Switch(Fields!My_column.Value > 6, "Red"
, Fields!My_column.Value < 5, "Black"
, true , "Yellow")
Gives:
How does your underlying data look? Is 6% "6" or is it actually "0.06"?
Nearly everything in SSRS is an expression, so you can use VBA code to conditionally set the property value.
To set the background colour, set the BackgroundColor property of the table cell to be:
=IIF(Fields!Mark.Value < 80, "Yellow", "White")
To set the font to bold, set the Font-FontWeight property of the table cell to be:
=IIF(Fields!Mark.Value < 80, "Bold", "Normal")
To make the text red, set the Color property of the table cell to be:
=IIF(Fields!Mark.Value < 80, "Red", "Black")
Best Answer
You defined an expression for the value of the TextBox, which isn't what you want. Simply display the value in the TextBox like you would for any other cell.
You should define an expression in the TextBox
FillorFontproperties. Depending on what exactly you wish to color.As an example I'll show you how to change the background color.
You can navigate to the above menu by rightclicking the cell and selecting "Text Box Properties...". Then simply define the same expression for Fill color