Crystal Reports

Crystal Formula Examples

Analyst (Example for Contacts)

  if IsNull ({ca_contact.last_name})
  then "UNASSIGNED"
  else
     if IsNull ({ca_contact.first_name})
     then Uppercase ({ca_contact.last_name})
     else Uppercase ({ca_contact.last_name} + ", " + {ca_contact.first_name})

CloseDate (Example for Requests)

Note: Be sure the u2lpdmtime.dll is avaible for such calls

  PDMTimeToDateTime ({call_req.close_date})

OpenDate (Example for Requests)

Note: Be sure the u2lpdmtime.dll is avaible for such calls

  PDMTimeToDateTime ({call_req.open_date})

TimeOpen (Example for Requests which Utilizes 'CloseDate' formula)

Note: Be sure the u2lpdmtime.dll is avaible for such calls

  if isnull ({@CloseDate}) 
  then ((DateTimeToPDMTime (CurrentDateTime) - {call_req.open_date})/60/60/24)
  else ((DateTimeToPDMTime ({@CloseDate}) - {call_req.open_date})/60/60/24)

Category (Example for Request Area)

  if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = ""
  then "Currently no category specified"
  else {prob_ctg.sym}