reporting-services - 一行上有多个 SSRS IIF 语句

Question

我有一份报告，我需要在一个查询中完成 3 项任务。

=IIF (Fields!Name.Value = " "," ", & vbcrlf & Name)

=IIF (Fields!Lastname.Value="" ," ", & vbcrlf & lastname)

=IIF(Fields!Middle.Value = " "," ", & vbcrlf & Middle)

所以我正在尝试做的是在一行上运行这些查询并在不同的行上输出名称、姓氏和中间名

=IIF(Fields!Name.Value is nothing," ", & vbcrlf & Name, IIF(Fields!Lastname.Value is nothing," ", & vbcrlf & lastname), IIF(Fields!Middle.Value is nothing," ", & vbcrlf & Middle))

它似乎没有运行，它只是打印 False。

有人可以帮忙吗？谢谢

标签： reporting-services

Answer 1

这应该工作...

=IIF(LEN(Fields!FirstName.Value) = 0 , "", Fields!FirstName.Value + vbcrlf )
+ IIF(LEN(Fields!MiddleName.Value) = 0 , "", Fields!MiddleName.Value + vbcrlf )
+ IIF(LEN(Fields!LastName.Value) = 0 , "", Fields!LastName.Value )

这是一些带有结果的示例数据。它包括名称NULL和空字符串，并通过测试字段的长度来处理两者。

如果你想要空行，所以它总是返回 3 行，然后将 移到+ vbcrlf每行的右括号之外。