How do I convert a calculated field in crystal reports into an SSRS expression?

Question

I have a calculated field in crystal reports, which I need to convert it to an SSRS expression. Any help would be appreciated.

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"

`=IIF(condition, true, false)` in SSRS. You would need to convert your fields to SSRS dataset fields too. You should give a better formatted question as well. — SS_DBA, Nov 22 '16 at 15:56

score 0 · Answer 1 · answered Nov 22 '16 at 16:06

Try this. You'll need to replace the fields with the dataset fields.

=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"))

How do I convert a calculated field in crystal reports into an SSRS expression?

1 Answers1