Last post Mar 12, 2015 06:21 AM by Sayali Tavare
Mar 05, 2015 03:01 AM|Sayali Tavare|LINK
I get Arithmetic overflow error converting expression to data type float in sql server 2012 and my crystal report generation fails (version 13).
Similarly when i run it in sql server 2008, I get the same arithmetic overflow error converting expression to data type float but my crystal report gets generated.
Any help regarding this.......
Mar 10, 2015 05:09 AM|Archer Wang|LINK
Hi Sayali Tavare,
Thank you for your post. This issue is more related with Database. About the error message, please refer to the similar cases as below.
Hope this could be helpful to you.
Mar 10, 2015 08:14 AM|Sayali Tavare|LINK
Thanks for replying. My query is regarding crystal report. It gets generated on one environment but fails in the other resulting the arithmetic overflow error. In both the environment I get the same arithmetic overflow error when i execute the Stored Procedure.
What is the difference between error message : Msg 8115, Level 16, State 6 (Sql Server 2012) and Msg 8115, Level 16, State 2 (Sql Server 2008)?
(State 6 and State 2)??
Could this be a cause of not generating the report?
Mar 11, 2015 05:40 AM|Archer Wang|LINK
These error messages you got at different SQL server version, and the Level X, State X show you which statement has some error, it could help you to solve your issue. As I know, this could not cause the error, your issue may be caused by your Stored Procedure
Mar 11, 2015 09:00 AM|AnandD|LINK
Tumse na ho payega Sayali,
check XACT_ABORT function
and check the connection. Use SQL Server connection rather SQL Server Native Client.
Mar 12, 2015 06:21 AM|Sayali Tavare|LINK
Thanks Anand. It worked.