IsNothing 不适用于报告生成器中的空值 [英] IsNothing not working on empty value in report builder

问题描述

我在表中有一个表达式，用于检查是否有返回值.

I have an expression in a table that checks if there was a return value.

如果查询返回空或 null 我想将该值设置为 0.

If the query returns empty or null I want to set the value to 0.

=IIF(IsNothing(Fields!DndCount.Value),0,Fields!DndCount.Value)

但如果查询返回空 IsNothing() 不起作用.

But if the query returns empty IsNothing() does not work.

推荐答案

我已经尝试过这段代码，它对我有用.

I have tried this code and it worked for me.

IIF(Sum(Fields!DndCount.Value)Is Nothing, "0", Sum(Fields!DndCount.Value))

这篇关于IsNothing 不适用于报告生成器中的空值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！