Difference between revisions of "Crystal Reports"
From SDU
m (→Crystal Formula Examples) |
m |
||
| Line 1: | Line 1: | ||
| + | __NOTOC__ | ||
[[Category:Reporting]] | [[Category:Reporting]] | ||
| − | == | + | <div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br> |
| + | To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div> | ||
| + | == Crystal Formula Examples == | ||
'''Analyst''' (Example for Contacts) | '''Analyst''' (Example for Contacts) | ||
| Line 36: | Line 39: | ||
then "Currently no category specified" | then "Currently no category specified" | ||
else {prob_ctg.sym} | else {prob_ctg.sym} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 05:51, 26 July 2008
To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.
To discuss or ask questions about this article, select the discussion tab above.
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}
