January 5, 2011 at 6:43 am
Hi,
I am looking for a solution to implement Bar graph (Bar with colors based on provided data) and use it in SQL Server Reports. The sample data is as follows and the required bar graph is attached:
11
11
30
10
19
27
18
18
27
45
36
27
27
18
9
9
9
9
9
9
9
9
9
9
9
The idea to use bar graph is to use custom report item as given in http://msdn.microsoft.com/en-us/magazine/cc188686.aspx. Please let me know if there is any solution available.
Shamshad Ali.
January 12, 2011 at 1:29 pm
The quickest way I know of is to go to the series properties of the graph, and create an expression for the fill property like this:
=IIf(Fields!val.Value < .2, "Blue",
IIf(Fields!val.Value < .4, "Green",
IIf(Fields!val.Value < .6, "Gold",
IIf(Fields!val.Value < .8, "Orange",
IIf(Fields!val.Value >= .8, "Red", "Black")))))
That'll set the color of each bar in the graph based on its value. Is that what you're looking for?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply