Calculated Field for Cross-Tab 1

[tcgoth]

Crystal 8.0
SQL


I am trying to get the following calculated field working as part of a Cross-Tab Report. Everything seems to work OK except for 'C208' and 'C218'...is it not permissible to use an "AND" statement nested in the "If"? If not, how else could I configure to get the same results?

I'm also getting a "Memory Full" error - I've read the other posts on this, but could this error also be impacting the results that I am seeing returned??

Thanks!

if {rpt_service.serv_type} = 'C201' then "Marketing Assist." Else
if {rpt_service.serv_type} = 'C202' then "HHG" Else
if {rpt_service.serv_type} = 'C203' then "Home Finding" Else
if {rpt_service.serv_type} = 'C204' then "Rental Assist." Else
if {rpt_service.serv_type} = 'C205' then "Temp. Living" Else
if {rpt_service.serv_type} = 'C208' AND {service.workflow_name} like ("%Travel Coordination%") then "Travel Assist." Else
if {rpt_service.serv_type} = 'C208' AND {service.workflow_name} like ("%Mort%") then "Mortgage Assist." Else
if {rpt_service.serv_type} = 'C209' then "BVO" Else
if {rpt_service.serv_type} = 'C210' then "Program Admin." Else
if {rpt_service.serv_type} = 'C212' then "Appraised Buyout" Else
if {rpt_service.serv_type} = 'C216' then "Expense Admin." Else
if {rpt_service.serv_type} = 'C218' AND {service.workflow_name} like ("%Guar%") Then "GBO" Else
if {rpt_service.serv_type} = 'C218' AND {service.workflow_name} like ("%GBO%") Then "GBO" Else
if {rpt_service.serv_type} = 'C218' AND {service.workflow_name} like ("%Closing%") THEN "Closing Assistance" Else
if {rpt_service.serv_type} = 'C222' then "IHG Notify"

 

[lbass]

In your "like" clauses, I think you should be using "*" instead of "%".

-LB

 

[tcgoth]

Doh! Thanks!