Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Invalid Numeric Error

Hello,

My Crystal Reports XI report is getting error message: "Failed to retrieve data from database." I know that something happened with my data source, however I cannot what exactly changed. Here is the error message:

"Failed to retrieve data from database. Details: S1000:[Knowledge Based Systems, Inc.] [Server API][V4.3]SQLExecute: Invalid NUMERIC(2,4) value [18], maximum of [-3] digits left of the decimal [Database Vendor Code: 852]

How do I read this message? Does it specify which value is having an issue? (i.e. invalid numeric(2, 4), value [18]). Any help is greatly appreciated!

Thanks.

Former Member
Not what you were looking for? View more on this topic or Ask a question