SSRS里面的函数问题

Question

tsql的语法里可以用case when做一个筛选，我想问一下在报表的表格里有简单函数可以做到类似的功能吗？

Answer 1

Hi @Jonny-4280，

可以考虑使用Switch函数，也可以跟iif函数结合起来一起用。

=Switch(Fields!name.Value = "A","red",
        Fields!name.Value = "B","blue",
        Fields!name.Value = "C","black")

你可以参考一下这个，跟excel里面的函数写法有点类似：

https://support.microsoft.com/zh-cn/office/switch-%E5%87%BD%E6%95%B0-47ab33c0-28ce-4530-8a45-d532ec4aa25e#:~:text=The%20SWITCH%20function%20evaluates%20one,to%20the%20first%20matching%20value.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.