主页 / dba / 问题 / 197417
Accepted
BoyGeorge
Asked: 2018-02-09 09:07:34 +0800 CST

使开关在 SSRS 中工作

  • 772

我试图让我的报告根据条件显示不同颜色的单元格。这是我当前的代码：

=Switch(Fields!DaysToExpiration.Value > 31, "Green",  
        Fields!User_Certification_Status.Value = 8, "Firebrick”,
        Fields!User_Certification_Status.Value = 13, “Orange”,
        Fields!User_Certification_Status.Value = 11, “Orange”,
        Fields!User_Certification_Status.Value = 10, “Orange”,
        Fields!User_Certification_Status.Value = 12, “Orange”,
        Fields!DaysToExpiration.Value <= 30, "Yellow", 
        1=1, "Gray")

所以，我的问题在于代码的最后一部分。我使用的是矩阵视图，这意味着有些单元格没有数据。SSRS 将它们视为具有价值（我假设为 0）。这意味着所有空白的都会自动变成黄色，而不是灰色。我该如何解决这个问题？谢谢你。

ssrs ssrs-2008-r2

1 个回答

  1. Best Answer

    是的，SSRS 在处理空值/空值时可能有点麻烦。尝试在黄色选项之前添加一个明确的 isnothing() ：

    =Switch(Fields!DaysToExpiration.Value > 31, "Green",  
    Fields!User_Certification_Status.Value = 8, "Firebrick”,
    Fields!User_Certification_Status.Value = 13, “Orange”,
    Fields!User_Certification_Status.Value = 11, “Orange”,
    Fields!User_Certification_Status.Value = 10, “Orange”,
    Fields!User_Certification_Status.Value = 12, “Orange”,
    IsNothing(Fields!DaysToExpiration.Value), "Gray",
    Fields!DaysToExpiration.Value <= 30, "Yellow", 
    1=1, "Gray")
    • 1

相关问题