I had this error since I have migrated from FRX.
The error was a general error "An unknown error has occurred"
Went to configuration console the I have found "System.OverflowException: Value was either too large or too small for a Decimal."
Solution:
It was the format. I had a custom format for the percent, at the column level. Change any custom format to their standard, in this case percent. Then like magic everything worked just fine.
I hope this helps because I looked all over the net for a solution and it looks like nobody have had this issue before.
Juan,
ReplyDeleteYou are the Man. We have reports that can run separately but when combined, they error out for some reason. Each report pulls in new data for each month and the previous month's data worked but didn't for April. Both of those results made it really hard to grasp what the underlying issue was.
When it failed, MR would report that "Value was either too large or too small for a Decimal." for a calculation. Calculating it out manually turned out like any other results in the past. Once the formula was removed, the same error but different formula was the culprit this time.
Changing the entire column to a number value was what ran the report successfully. Thanks.
Glad to help.
ReplyDelete