Skip to Content
0
Former Member
Feb 12, 2009 at 05:21 PM

Gauge Chart Design

213 Views

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?