SSRS Colour Expression Not Updating Colour

Question

SSRS Colour Expression Not Updating Colour

ashley 87893

Valued Member

Points: 67
More actions
February 14, 2019 at 8:24 am

#381417
Hi all,
I've added a colour expression to a dashboard but the colours are not updating. It's already using colour expressions on multiple values so I wonder if this could be the cause? The value is set at 0 and should be green, however, it's showing red still.
Tried deploying and deleting RDL cache file with no joy.
My expression:
```
=Iif((Sum(Microsoft.VisualBasic.Interaction.IIF(Fields!STATUS_TYPE_ID.Value = 1 AND IsNothing(Fields!ASSIGNED_TECH_ID.Value), 1, 0), "CallDetails")) <= 2, "SeaGreen", Iif((Sum(Microsoft.VisualBasic.Interaction.IIF(Fields!STATUS_TYPE_ID.Value = 1 AND IsNothing(Fields!ASSIGNED_TECH_ID.Value), 1, 0), "CallDetails")) > 6, "Red", "DarkOrange"))
```
Expected result is for it to be green currently as the value is 0, however, the colour is currently a solid red.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110639 More actions · Answer 1

ashley 87893 - Thursday, February 14, 2019 8:24 AM
Hi all,
I've added a colour expression to a dashboard but the colours are not updating. It's already using colour expressions on multiple values so I wonder if this could be the cause? The value is set at 0 and should be green, however, it's showing red still.
Tried deploying and deleting RDL cache file with no joy.
My expression:
=Iif((Sum(Microsoft.VisualBasic.Interaction.IIF(Fields!STATUS_TYPE_ID.Value = 1 AND IsNothing(Fields!ASSIGNED_TECH_ID.Value), 1, 0), "CallDetails")) <= 2, "SeaGreen", Iif((Sum(Microsoft.VisualBasic.Interaction.IIF(Fields!STATUS_TYPE_ID.Value = 1 AND IsNothing(Fields!ASSIGNED_TECH_ID.Value), 1, 0), "CallDetails")) > 6, "Red", "DarkOrange"))
Expected result is for it to be green currently as the value is 0, however, the colour is currently a solid red.

Try using that expression in a text box you place in the same region of the report as the existing text box that has the problem, and see what value it displays.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

ashley 87893 Valued Member Points: 67 More actions · Answer 2

sgmunson - Friday, February 15, 2019 8:41 AM
ashley 87893 - Thursday, February 14, 2019 8:24 AM
Hi all,
I've added a colour expression to a dashboard but the colours are not updating. It's already using colour expressions on multiple values so I wonder if this could be the cause? The value is set at 0 and should be green, however, it's showing red still.
Tried deploying and deleting RDL cache file with no joy.
My expression:
=Iif((Sum(Microsoft.VisualBasic.Interaction.IIF(Fields!STATUS_TYPE_ID.Value = 1 AND IsNothing(Fields!ASSIGNED_TECH_ID.Value), 1, 0), "CallDetails")) <= 2, "SeaGreen", Iif((Sum(Microsoft.VisualBasic.Interaction.IIF(Fields!STATUS_TYPE_ID.Value = 1 AND IsNothing(Fields!ASSIGNED_TECH_ID.Value), 1, 0), "CallDetails")) > 6, "Red", "DarkOrange"))
Expected result is for it to be green currently as the value is 0, however, the colour is currently a solid red.
Try using that expression in a text box you place in the same region of the report as the existing text box that has the problem, and see what value it displays.

Thanks for the reply. I've added this to the text box and it's showing the value as Red. When again... it should be green, can't quite work out what could be going on here.