December 22, 2015 at 7:35 am
I am using SQL server reporting services. I'm faced with the following situation. I am trying to display data log of a parameter which currently is configured to change color for a large variation in the parameter value. My client requires that this parameter ought to change color not just for a large variation in the parameter value but only when it crosses a certain threshold value. This is depicted in the waveform which I've attached. I would appreciate it if someone could guide me how to achieve this. Thanks in advance.
December 22, 2015 at 10:01 am
You can achieve this by using an expression in the Fill property of the Series.
Right click the Series -> Series Properties -> Fill -> Color.
An expression like =Iif(Fields!yval.Value > 50, "Red", "Lime") will work to change the colour beyond a threshold value.
The only thing is your legend will only show one colour, so you might have to be creative there.
December 22, 2015 at 9:44 pm
i have tried that expression,but my requirement is not full fill.
actually the thing is am having values series1 values :22,25,27,35,25,22,18
my high limit set point is 30 (iif series1.values > 30,"red","green"),it was working but the issue is where as value from 27 to 35 it showing in red ,but my intention is to show the value from 27 to 30 in green color and 30 to 35 in red color
as the like the same from 35 to 25 it is showing in green color,but it have to be shown like 35 to 30 in red color and 30 to 25 in green color
this is what i need to achieve
here i attached image file.
any help would be greatly appreciated
December 23, 2015 at 3:49 am
Ahh. I see what you mean, unfortunately I'm stumped on this one, not sure it is possible with how SSRS line charts work.
Soz, hopefully someone else can help.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply