SSRS 2005 - Dynamic bar chart yaxis does not update
I am working with SSRS 2005 and have a chart that uses a min and max to set the yaxis. They are set as: =First(Fields!Min.Value) on the yaxis properties. The scale is not using these fields. What can be wrong? (it's never happened before) Example: my data values range from 3.97 to 11.2 the min field is 3.93 and the max is 11.3 but the scale is showing max of 9.9
September 15th, 2010 1:28pm

Apparently this is fixed in a hot fix and also included in SP2. I have those installed, but if i set the Y axis to use margins, the min and max are correct.
Free Windows Admin Tool Kit Click here and download it now
September 29th, 2010 2:52pm

Instead of using "They are set as: =First(Fields!Min.Value) " try to set expression as "=min(Fields!value.Value)" . this worked for me :) you can also set "=max(Fields!value.Value)" for max value of Y axis and ""=(min(Fields!value.Value)-min(Fields!value.Value))/n" where n is no. of intervals and "Fields!value.Value" is data field you are plotting. Also check which version of BI suit you are using as this is not supported in 2005 but 2008 :)
August 28th, 2012 1:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics