我试图压制一个子报告。我想检查一个字符串值是否为null。 如果字符串值为null,则它将被禁止。 我按照以下步骤 -
然后我写了一个类似的公式
如果InStr({EmployeeHist.SpouseName},'')= 0则为'N / A'
但它显示错误公式结果必须是一个布尔人 ..
有人可以帮忙吗?
I am trying to suppress a sub-report.I want to check a string value either it is null or not. If the string value is null then it will suppress. I followed the following steps-
then I wrote a formula like
if InStr ({EmployeeHist.SpouseName},'' ) = 0 then 'N/A'
But its showing a error THE FORMULA RESULT MUST BE A BOOLEAN..
Can anyone please help??
最满意答案
将公式更改为
ISNULL({EmployeeHist.SpouseName})
如果SpouseName为null并且子报表将被抑制,则返回true
change the formula to
ISNULL({EmployeeHist.SpouseName})
this will return true if the SpouseName is null and the subreport will be suppressed
更多推荐
发布评论