如何将Crystal报告中计算出的字段转换为SSRS表达式

Question

i在Crystal Reports中有一个计算的字段，我需要将其转换为SSRS表达式。任何帮助将不胜感激。

If ({VISIT_TYPE.DESCRIPTION} = "New" or {VISIT_TYPE.DESCRIPTION} = "Walk-In New") then
    if {ATTEND_STATUS.DESCRIPTION} = "Did Not Attend" then
        "c.New DNA"
    else
        "a.New"
else if ({VISIT_TYPE.DESCRIPTION} = "Return" or {VISIT_TYPE.DESCRIPTION} = "Follow Up" 
or {VISIT_TYPE.DESCRIPTION} = "Walk-In Follow Up" or {VISIT_TYPE.DESCRIPTION} = "Walk-In Returns") then
    if {ATTEND_STATUS.DESCRIPTION} = "Did Not Attend" then
        "d.Return DNA"
    else
        "b.Return"

Answer 1

尝试一下。您需要用数据集字段替换字段。

=IIF ({VISIT_TYPE.DESCRIPTION} = "New" or {VISIT_TYPE.DESCRIPTION} = "Walk-In New", IIF ({ATTEND_STATUS.DESCRIPTION} = "Did Not Attend" ,
        "c.New DNA","a.New")
,IIF ({VISIT_TYPE.DESCRIPTION} = "Return" or {VISIT_TYPE.DESCRIPTION} = "Follow Up" 
or {VISIT_TYPE.DESCRIPTION} = "Walk-In Follow Up" or {VISIT_TYPE.DESCRIPTION} = "Walk-In Returns",IIF({ATTEND_STATUS.DESCRIPTION} = "Did Not Attend","d.Return DNA","b.Return"))