时间戳

首页 > 解决方案 > SSRS 表达式帮助多个条件

c# - SSRS 表达式帮助多个条件

问题描述

=IIF((Fields!len.Value<=27) AND (Fields!oLastRegRetail.Value>0) then Fields!Retail.Value/Fields!oLastRegRetail.Value) second if
=IIF(Fields!len.Value>27) AND (Fields!Regular.Value>0) then Fields!Retail.Value/Fields!Regular.Value if both false-"N/A"))

标签： c#sql-serverreporting-services

解决方案

看来你的IIF条件坏了。这是固定版本。

=IIF(Fields!len.Value <= 27 AND Fields!len.Value > 27 AND Fields!Regular.Value > 0
    ,Fields!Retail.Value/Fields!oLastRegRetail.Value
    ,"N/A")

或者如果你试图做嵌套IIF

=IIF(Fields!len.Value <= 27  and Fields!Regular.Value > 0
    ,Fields!Retail.Value/Fields!oLastRegRetail.Value
    ,IIF(Fields!len.Value > 27 and Fields!Regular.Value > 0
        ,Fields!Retail.Value/Fields!Regular.Value, "N/A")
)

推荐阅读