有没有一种简单的方法可以执行IN语句或SSRS公式中的类似操作来进行iff语句比较，而不必重复16次开关？
这是我想要完成的工作，而不必Fields!FieldName.Value = "01" OR Fields!FieldName.Value = "02"为每个值编写语句或单独的OR ie（... etc）：
=iif((Fields!FieldName.Value IN
("01","02","03","06","08","09","10","12","15","19"),"TypeA",
iff((Fields!ProdCode.Value IN ("04","07","11","13","14","16"),
"TypeB","TypeC")
或这个：
=switch(
Instr( "," & "01,02,03,06,08,09,10,12,15,19" & ",", "," & Fields!FieldName.Value & ",") > 0 ,"TypeA",
Instr( "," & "04,07,11,13,14,16" & ",", "," & Fields!ProdCode.Value & ",") > 0 ,"TypeB",
True, "TypeC")
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句