如何修复错误“字符串是非数字的”在水晶报告？ [英] How to fix the error "The string is non -numeric" in crystal report?

问题描述

运行水晶报表时，对于某些值，存在String is non-numeric异常。

我试过代码 -

  If  IsNull（{GL_PayableStatement.RemainingBalance}） OR  {GL_PayableStatement.RemainingBalance} =    OR  {GL_PayableStatement.RemainingBalance} =   0 
 然后 
  0  
  ELse  
 ToNumber（{GL_PayableStatement.RemainingBalance}）

但仍有错误！



请帮助我。

解决方案

你传递的价值是多少？

再添加一个或条件 检查值  numeric 或 不。 
 如果 IsNull（{GL_PayableStatement.RemainingBalance}） OR  {GL_PayableStatement.RemainingBalance} =    OR  {GL_PayableStatement.RemainingBalance} = < span class =code-string>  0  或 不（IsNumeric（{GL_PayableStatement.RemainingBalance}）） 
 然后 
  0  
 否则 
 ToNumber（{GL_PayableStatement.RemainingBalance}）

Hi,

While running the crystal report, for some values there is a "String is non-numeric"exception.
I have tried the code -

If IsNull({GL_PayableStatement.RemainingBalance}) OR {GL_PayableStatement.RemainingBalance}="" OR {GL_PayableStatement.RemainingBalance}="0"
then
0
ELse
ToNumber( {GL_PayableStatement.RemainingBalance})

But still the error is there!

Please help me.

解决方案

What's the value you're passing?

Add one more OR condition to check the value is numeric or not.
If IsNull ({GL_PayableStatement.RemainingBalance}) OR {GL_PayableStatement.RemainingBalance}="" OR {GL_PayableStatement.RemainingBalance}="0" OR Not(IsNumeric({GL_PayableStatement.RemainingBalance}))
 Then
 0
Else
 ToNumber ({GL_PayableStatement.RemainingBalance})

这篇关于如何修复错误“字符串是非数字的”在水晶报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！