ochness
asked on
Error in SSRS report "Value was either too large or too small for a Decimal"
I am writing a report in SQL Report Services and am getting an error that says "The Value expression for the textbox textbox9 contains an error: Value was either too large or too small for a Decimal." I only get this error when the value in textbox9 is 0. I have formated the field to a "P2" in the properties as I need to have the values show as a percentage with two decimal places. Any suggestions as to how to format this and get rid of the error would be great.
Thanks.
Thanks.
ASKER
Thank you for your response. I am pretty new to SSRS so i'm not really understanding what I need to do with the information you provided. If you could provide me with a little more direction that would be great.
Thanks.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The woraround to avoid the error message is to remove from the original rdl (2005 rdl) the Min value of the value axis:
<ValueAxis>
<Axis>
&&
<Min>0</Min> should be removed
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=368223