<div>
<div class="content wysiwyg-content">
Good afternoon all,<br />
<br />
I have a simple question. &nbsp;I am trying to use a gauge on my report. &nbsp;The report is a detail item report for a patient with all the cost associated with the case. &nbsp;I think would like to see what the cost ration is so I take my total cost and divided them against the total charges, &nbsp;I have created a Formula Field for this and I am getting the data as expected of 0.17 for this one case. &nbsp;I want to place that value on the gauge to show how it falls in line. &nbsp;I want to show that value on the gauge, but when I try and add the data field I created it wants to summarize it using Sum, Count, Average. &nbsp;I do not need any of those as I have the value I want. &nbsp;How can I get that value on the gauge? &nbsp;I would also like to start the gauge color with green from 0 to 20 then change it to orange from 20 to 70 and then red for 70 to 100.<br />
<br />
Thanks,<br />
Rodger
</div>
</div>


Good afternoon all,

I have a simple question.  I am trying to use a gauge on my report.  The report is a detail item report for a patient with all the cost associated with the case.  I think would like to see what the cost ration is so I take my total cost and divided them against the total charges,  I have created a Formula Field for this and I am getting the data as expected of 0.17 for this one case.  I want to place that value on the gauge to show how it falls in line.  I want to show that value on the gauge, but when I try and add the data field I created it wants to summarize it using Sum, Count, Average.  I do not need any of those as I have the value I want.  How can I get that value on the gauge?  I would also like to start the gauge color with green from 0 to 20 then change it to orange from 20 to 70 and then red for 70 to 100.

Thanks,
Rodger

Crystal Report Gauge

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.