SSRS IIF语句

Question

我这是写在一个水晶报表计算领域如下的表达式：

if {SERVICE_POINTS.CODE} in ["MIDRO", "MID3F", "MID5C", "MIDAC", "MIDBL", "MIDBM", "MIDDA","MIDCO", "MIDSW", "MIDBV", "MIDHV", "MIDNV", "MIDSV", "TEABV", "MIDHB"] then "MIDWIFERY LED" 
else if {SERVICE_POINTS.CODE} in ["RAADP", "MIDAO", "MIDBC", "MIDLB", "MIDLA","MIDNB","CONC1", "CONC2", "TEAAI", "TEBDJ", "TECCI", "TEDBJ", "MIDBF"] then "NURSE LED" 
else if {SERVICE_POINTS.CODE} in ["BOMCB", "THOCA", "THOGY", "THOGT"] then "ANAES" 
ELSE ""Check MDR""Check MDR"" 

现在我试图复制在SSRS相同的公式，并与下面上来代码：

IIF(SERVICE_POINTS_CODE.Value IN ["MIDRO", "MID3F", "MID5C", "MIDAC", "MIDBL", "MIDBM", "MIDDA","MIDCO", "MIDSW", "MIDBV", "MIDHV", "MIDNV", "MIDSV", "TEABV", "MIDHB"] ,"MIDWIFERY LED", 
IIF(SERVICE_POINTS_CODE.Value IN ["RAADP", "MIDAO", "MIDBC", "MIDLB", "MIDLA","MIDNB","CONC1", "CONC2", "TEAAI", "TEBDJ", "TECCI", "TEDBJ", "MIDBF"], "NURSE LED" , 
IIf (SERVICE_POINTS.CODE in ["BOMCB", "THOCA", "THOGY", "THOGT"] ,"ANAES" ,"Check MDR""Check MDR"))) 

但上面的代码给了我错误。我会感谢任何帮助。

Answer 1

尝试使用IndexOf功能：

=Switch(
Array.IndexOf(Split("MIDRO,MID3F,MID5C,MIDAC,MIDBL,MIDBM,MIDDA,MIDCO,MIDSW,MIDBV,MIDHV,MIDNV,MIDSV,TEABV,MIDHB" , ","), Fields!SERVICE_POINTS_CODE.Value)>-1 ,"MIDWIFERY LED", 
Array.IndexOf(Split("RAADP,MIDAO,MIDBC,MIDLB,MIDLA,MIDNB,CONC1,CONC2,TEAAI,TEBDJ,TECCI,TEDBJ,MIDBF" , ","), Fields!SERVICE_POINTS_CODE.Value)>-1 ,"NURSE LED", 
Array.IndexOf(Split("BOMCB,THOCA,THOGY,THOGT" , ","), Fields!SERVICE_POINTS_CODE.Value)>-1,"ANAES", 
true,"Check MDR" 
) 

让我知道，如果这有助于。