One of the chart options for the gauge chart is to provide a beginning and ending value for a quality band.
You can set up to 5 quality bands with different colors.
I have done this using the report designer, but this requires me to set the values at design time. I want to be able to set the values at runtime based on data values that are coming from a database.
e.g if I have a gauge chart and stored procedure sends me upper value% , lower value% and success value %
so I have to show
Band 1 0 - Lower value % color=RED
Band 2 Lower value- upper value % color = Green
Band 3 Upper value to 100% color =BLUE
The needle will show the success Value %
How can I set the values of band and color at runtime from Stored procedure
Any help is appreciated
Thanks