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.

Who is Participating?
ochnessConnect With a Mentor Author Commented:
I have figured this out myself.......
Raja Jegan RSQL Server DBA & ArchitectCommented:
Try out the microsoft approach as given below:

The woraround to avoid the error message is to remove from the original rdl (2005 rdl) the Min value of the value axis:

    <Min>0</Min> should be removed
ochnessAuthor Commented:
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.