具有空值的CrystalReports公式

本文介绍了具有空值的CrystalReports公式的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如果BATCHNO为NULL，则以下代码无效，在VarINAME中获取空值。 请帮助解决此问题。 非常感谢， Sunil

Hi, Following code is not working if BATCHNO is NULL, get empty value in VarINAME. Please help to solve this. Thanks n regards, Sunil

//--- Code ---- Global StringVar VarINAME:=""; if not ISNULL({invoice01.INAME}) then VarINAME := {invoice01.INAME}; if not ISNULL({invoice01.BATCHNO}) then if {invoice01.BATCHNO} <> "" then VarINAME := VarINAME + ' Batch:' + {invoice01.BATCHNO}; if not ISNULL({invoice01.EXPDATE}) then if year({invoice01.EXPDATE})>1970 then VarINAME := VarINAME + ' Exp:' + totext({invoice01.EXPDATE},"MMM yy");

推荐答案

尝试使用带有多行部分的括号将有所帮助： Try if using parenthesis with multiline parts would help: if not ISNULL({invoice01.INAME}) then VarINAME := {invoice01.INAME}; if not ISNULL({invoice01.BATCHNO}) then ( if {invoice01.BATCHNO} <> "" then VarINAME := VarINAME + ' Batch:' + {invoice01.BATCHNO}; ); if not ISNULL({invoice01.EXPDATE}) then if year({invoice01.EXPDATE})>1970 then VarINAME := VarINAME + ' Exp:' + totext({invoice01.EXPDATE},"MMM yy");

我找到了问题的解决方案。通过添加else子句，令人惊讶的是它有效。 I got solution for the problem. By adding an else clause, surprisingly it works. Global StringVar VarINAME:=""; if not(ISNULL({invoice01.INAME})) then VarINAME := {invoice01.INAME} else VarINAME := ""; if not (ISNULL({invoice01.BATCHNO})) then ( if {invoice01.BATCHNO} <> "" then VarINAME := VarINAME + ' Batch:' + {invoice01.BATCHNO} else VarINAME := VarINAME + ""; ) else VarINAME := VarINAME + ""; if not (ISNULL({invoice01.EXPDATE})) then ( if year({invoice01.EXPDATE})>1970 then VarINAME := VarINAME + ' Exp:' + totext({invoice01.EXPDATE},"MMM yy") else VarINAME := VarINAME + ""; ) else VarINAME := VarINAME + "";