Crystal Report多条件If公式报错：提示缺少THEN，请求排查

错误原因 #

原公式第一个逻辑判断中，and后面冗余添加了if关键字，违反了Crystal Reports的If-Then-Else语法规则，导致系统无法正确解析条件结构，从而触发“缺少THEN”的报错。

修正后的公式 #

if {vehinv_rec.master_class_2} = "RCV" and {vehinv_rec.chassis_model} in 
["DF01", "DF02", "DF03", "DF04", "DF05", "DF06", "DF07", "DF08", "DF09", "DF10",
 "DF11", "DF12", "DF13", "DF14", "DF15", "DF16", "DF17", "DF18", "DF19", "DF20",
 "FAD2", "AN1", "AN2", "ANT", "ME4"] 
then "Uncompliant" 
else if {vehinv_rec.master_class_2} = "RCV" and {vehinv_rec.gvw_kg} > 18000 
then "Compliant" 
else "Out of Scope"

说明 #

• 移除了第一个and后的多余if，让条件逻辑符合if (条件1 and 条件2) then ...的正确结构
• 调整了换行格式，让公式的层级和逻辑更易读

内容的提问来源于stack exchange，提问作者Lizzi McCarthy