Report not running due to too large or too small value for decimal. RRS feed

  • Question

  • I have a need to run two reports on reasons for lost proposals -- one based on dollars and another based on number of proposals. I created a pretty pie chart and table using the Report Wizard for the dollar-based report. But, the number-based report offered some challenges. I could not seem to get the Wizard to do a pie chart based on number of proposals sent and lost in each category... and so I added a "dummy" field that defaults to "1" on the custom proposal entity, and then added that to my columns in the report. It then allows me to select pie chart and finish the report. BUT, when I run the report, I get the following error: "Value was either too large or too small for a Decimal."

    Any ideas on what the situation might be? All proposal records in the database contain a "1" in my dummy proposal count field.


    Thursday, February 17, 2011 5:31 PM


All replies