I am running the report on Business object server. So I have a crystal report with datasource as stored procedure.(No NET application)
I get the data from stored procedure and bind it to the gauge chart. Now what I need to know is how do I set the bands from the fields from stored procedure
example I'll get following data in the stored procedure for PERSON 1
band 1 range 0 to 70
band 2 range 70 to 90
band 3 range 90 to 100
Success Value percent 85%
So I want to constuct the gauge chart which will show 3 quality band from the ablove data
band 1 color red
band 2 color green
band 3 color blue
Needle color black pointing to 85% which will fall in the green zone
For the next set of data (PERSON 2) I may get completely diffeerent bands such as 0 to 50, 50 to 70, 70 to 100. So when I generate the report for PERSON 2 I have to show red, green and blue zone according to the values I get for the bands from stored procedure.
Any idea?