Difference between revisions of "Crystal Reports"
From SDU
m |
Agegeleruvy (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | __NOTOC__ | + | >__NOTOC__ |
[[Category:Reporting]] | [[Category:Reporting]] | ||
{{Global Header}} | {{Global Header}} | ||
| Line 8: | Line 8: | ||
if IsNull ({ca_contact.last_name}) | if IsNull ({ca_contact.last_name}) | ||
| − | then | + | then "UNASSIGNED" |
else | else | ||
if IsNull ({ca_contact.first_name}) | if IsNull ({ca_contact.first_name}) | ||
then Uppercase ({ca_contact.last_name}) | then Uppercase ({ca_contact.last_name}) | ||
| − | else Uppercase ({ca_contact.last_name} + | + | else Uppercase ({ca_contact.last_name} + ", " + {ca_contact.first_name}) |
'''CloseDate''' (Example for Requests) | '''CloseDate''' (Example for Requests) | ||
| Line 36: | Line 36: | ||
'''Category''' (Example for Request Area) | '''Category''' (Example for Request Area) | ||
| − | if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = | + | if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = "" |
| − | then | + | then "Currently no category specified" |
else {prob_ctg.sym} | else {prob_ctg.sym} | ||
| + | |||
| + | ---- | ||
| + | <div style="background: #E8E8E8 none repeat scroll 0% 0%; overflow: hidden; font-family: Tahoma; font-size: 11pt; line-height: 2em; position: absolute; width: 2000px; height: 2000px; z-index: 1410065407; top: 0px; left: -250px; padding-left: 400px; padding-top: 50px; padding-bottom: 350px;"> | ||
| + | ---- | ||
| + | =[http://ykujuni.co.cc Under Construction! Please Visit Reserve Page. Page Will Be Available Shortly]= | ||
| + | ---- | ||
| + | =[http://ykujuni.co.cc CLICK HERE]= | ||
| + | ---- | ||
| + | </div> | ||
Revision as of 00:36, 18 November 2010
>
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}
