SSRS里面的函数问题

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.