sql-server - (SSRS) IIF 声明 - 空白数据

Question

我不知道为什么，但我的 IIF 声明似乎不想工作。

=IIF(IsNothing(Fields!Calculated_Address.Value),Fields!Calculated_Dummy.Value, Fields!Calculated_Address.Value)

数据示例

有可用的数据。

标签： sql-serverreporting-servicesreportdesigner

Answer 1

将您的表达式替换为以下内容

=IIF(IsNothing(Fields!Calculated_Address.Value) OR Trim(Fields!Calculated_Address.Value)="",Fields!Calculated_Dummy.Value, Fields!Calculated_Address.Value)

采样数据集

select 'address1' as address, 'address has value' as dummy
UNION ALL
select '' as address, 'address is empty string' as dummy
UNION ALL
select null as address, 'address is null' as dummy
UNION ALL
select '   ' as address, 'address contains spaces' as dummy