报告查看器 - 将任何0值转换为显示空白或空值

时间:2022-07-29 11:48:19

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))