Format Chart data labels

[Former Member]

I am using CR 2008 and I am getting my data from a stored procedure in SQL Server 2008. In my result set I have two scores from which I create a variance. 97.1, 91.2 gives me a variance of 6.47 betwenn the two. I need to chart this with the variance as the value. The datatype for the Variance field in the SP is decimal(10,2).

Everything is fine but I need to show the data label in the chart as a percentage. So 6.47 should show as 6.47%. When I right click on the data label and format the data label as Percent with two decimal places I get 646.93%. Which I understand because CR is multiplying my label by 100. So I changed the data from my SP to not multiply by 100 so my label would come out correct. It does but then my bar chart actual valu is only .0647 so the bar in the graph is not correct.

One thing I did notice is that when I add my variance field as my value for the chart it comes back as "Sum of spCSSVarComp;1.Variance" and the "Don't summarize" checkbox is not enabled. So I am wondering if this has anything to do with it.

Thanks in advance for any help.

[Former Member]

I fixed this on my own. I left the value coming from the database as .0647 and then set the datalabel to show as a percentage which gives me the 6.47% label. What I had to do then was go to Chart Expert and change the Min and Max Data Values on the Axes tab to -0.10 and 0.10 respectively.

Edited by: Ron Conway on Nov 3, 2010 6:04 PM