I'm using Crystal Reports XI and MSSQL 2000.
Working with three fields 1-Type, 2-Subtype, 3-Condition. My formula lables each record based on the various conditions of these fields. If one of the conditions isn't met I want the label to be "Other". My problem is when one of these three fields is null my formula doesn't return a result. I'm expecting it to return "Other". Your help is greatly appreciated.
Here is the formula:
___________________________________________________________
If {kennel.intake_subtype} = "FIELD" and
{kennel.intake_cond} = "DEAD" then "DEAD"
else
If {kennel.intake_type} in ["STRAY", "WILD", "DEAD"] and
{kennel.intake_subtype} = "FIELD" and
{kennel.intake_cond} <> "DEAD" then "STRAY AT LARGE"
else
If {kennel.intake_type} in ["EUTH REQ", "OWN SUR"] and
{kennel.intake_subtype} = "FIELD" then "OWNER SURRENDER"
else
If {kennel.intake_type} = "CONFISCATE" and
{kennel.intake_subtype} = "BITE" then "CONFISCATE BITE"
else
If {kennel.intake_type} = "CONFISCATE" and
{kennel.intake_subtype} in ["EVICTION", "HOSPITAL", "OWNER DIED", "POLICE"] then "CONFISCATE AGENCY ASSIST"
else
If {kennel.intake_type} = "CONFISCATE" and
{kennel.intake_subtype} = "CRUELTY" then "CONFISCATE CRUELTY"
else
If {kennel.intake_type} = "DISASTER" and
{kennel.intake_subtype} in ["FIELD", "LIVESTOCK"] then "DISASTER"
else "OTHER
Working with three fields 1-Type, 2-Subtype, 3-Condition. My formula lables each record based on the various conditions of these fields. If one of the conditions isn't met I want the label to be "Other". My problem is when one of these three fields is null my formula doesn't return a result. I'm expecting it to return "Other". Your help is greatly appreciated.
Here is the formula:
___________________________________________________________
If {kennel.intake_subtype} = "FIELD" and
{kennel.intake_cond} = "DEAD" then "DEAD"
else
If {kennel.intake_type} in ["STRAY", "WILD", "DEAD"] and
{kennel.intake_subtype} = "FIELD" and
{kennel.intake_cond} <> "DEAD" then "STRAY AT LARGE"
else
If {kennel.intake_type} in ["EUTH REQ", "OWN SUR"] and
{kennel.intake_subtype} = "FIELD" then "OWNER SURRENDER"
else
If {kennel.intake_type} = "CONFISCATE" and
{kennel.intake_subtype} = "BITE" then "CONFISCATE BITE"
else
If {kennel.intake_type} = "CONFISCATE" and
{kennel.intake_subtype} in ["EVICTION", "HOSPITAL", "OWNER DIED", "POLICE"] then "CONFISCATE AGENCY ASSIST"
else
If {kennel.intake_type} = "CONFISCATE" and
{kennel.intake_subtype} = "CRUELTY" then "CONFISCATE CRUELTY"
else
If {kennel.intake_type} = "DISASTER" and
{kennel.intake_subtype} in ["FIELD", "LIVESTOCK"] then "DISASTER"
else "OTHER