How do I make any 0 value display blank or null? Can I do a condition expression in report viewer perhaps
如何将任何0值显示为空或为空?我是否可以在报表查看器中执行条件表达式
Update: here is what I have tried
更新:这是我尝试过的
=IIf(FormatNumber(Fields!totalnetamaount.Value, 2) is 0, "", FormatNumber(Fields!totalnetamaount.Value, 2))
It threw the exception
它抛出了异常
Error 1 The Value expression for the textrun ‘totalnetamaount.Paragraphs[0].TextRuns[0]’ contains an error: [BC30020] 'Is' operator does not accept operands of type 'Integer'. Operands must be reference or nullable types.
错误1 textrun'totalnetamaount.Paragraphs [0] .TextRuns [0]'的值表达式包含错误:[BC30020]'Is'运算符不接受'Integer'类型的操作数。操作数必须是引用或可空类型。
1 个解决方案
#1
1
Replace your "is" with "=". Modify your condition as follows,
将“是”替换为“=”。修改您的条件如下,
=IIf(FormatNumber(Fields!totalnetamaount.Value, 2)=0, "", FormatNumber(Fields!totalnetamaount.Value, 2))
#1
1
Replace your "is" with "=". Modify your condition as follows,
将“是”替换为“=”。修改您的条件如下,
=IIf(FormatNumber(Fields!totalnetamaount.Value, 2)=0, "", FormatNumber(Fields!totalnetamaount.Value, 2))