Crystal Reports - Revision history

Gityerfix: Reverted edits by Agegeleruvy (Talk); changed back to last version by FrankTR

2010-11-30T05:28:11Z

Reverted edits by Agegeleruvy (Talk); changed back to last version by FrankTR

Agegeleruvy at 03:19, 24 November 2010

2010-11-24T03:19:19Z

FrankTR: reverting vandalism

2010-11-18T12:49:40Z

reverting vandalism

Agegeleruvy at 00:37, 18 November 2010

2010-11-18T00:37:53Z

Agegeleruvy at 00:36, 18 November 2010

2010-11-18T00:36:30Z

Gityerfix at 00:59, 27 July 2008

2008-07-27T00:59:52Z

Gityerfix at 05:51, 26 July 2008

2008-07-26T05:51:45Z

Gityerfix: /* Crystal Formula Examples */

2008-07-18T14:21:59Z

‎Crystal Formula Examples

Gityerfix at 13:11, 5 July 2008

2008-07-05T13:11:20Z

Gityerfix: /* Crystal Formula Examples */

2008-06-30T17:59:12Z

‎Crystal Formula Examples

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Reporting]]
@@ Line 16: / Line 8: @@
     if IsNull ({ca_contact.last_name})
-    then &quot;UNASSIGNED&quot;
+    then "UNASSIGNED"
     else
        if IsNull ({ca_contact.first_name})
        then Uppercase ({ca_contact.last_name})
-       else Uppercase ({ca_contact.last_name} + &quot;, &quot; + {ca_contact.first_name})
+       else Uppercase ({ca_contact.last_name} + ", " + {ca_contact.first_name})
 '''CloseDate''' (Example for Requests)
@@ Line 44: / Line 36: @@
 '''Category''' (Example for Request Area)
-    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = &quot;&quot;
+    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = ""
-    then &quot;Currently no category specified&quot;
+    then "Currently no category specified"
     else {prob_ctg.sym}

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Reporting]]
@@ Line 8: / Line 16: @@
     if IsNull ({ca_contact.last_name})
-    then "UNASSIGNED"
+    then &quot;UNASSIGNED&quot;
     else
        if IsNull ({ca_contact.first_name})
        then Uppercase ({ca_contact.last_name})
-       else Uppercase ({ca_contact.last_name} + ", " + {ca_contact.first_name})
+       else Uppercase ({ca_contact.last_name} + &quot;, &quot; + {ca_contact.first_name})
 '''CloseDate''' (Example for Requests)
@@ Line 36: / Line 44: @@
 '''Category''' (Example for Request Area)
-    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = ""
+    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = &quot;&quot;
-    then "Currently no category specified"
+    then &quot;Currently no category specified&quot;
     else {prob_ctg.sym}

@@ Line 1: / Line 1: @@
->&gt;__NOTOC__
+__NOTOC__
 [[Category:Reporting]]
 {{Global Header}}
@@ Line 8: / Line 8: @@
     if IsNull ({ca_contact.last_name})
-    then &amp;quot;UNASSIGNED&amp;quot;
+    then "UNASSIGNED"
     else
        if IsNull ({ca_contact.first_name})
        then Uppercase ({ca_contact.last_name})
-       else Uppercase ({ca_contact.last_name} + &amp;quot;, &amp;quot; + {ca_contact.first_name})
+       else Uppercase ({ca_contact.last_name} + ", " + {ca_contact.first_name})
 '''CloseDate''' (Example for Requests)
@@ Line 36: / Line 36: @@
 '''Category''' (Example for Request Area)
-    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = &amp;quot;&amp;quot;
+    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = ""
-    then &amp;quot;Currently no category specified&amp;quot;
+    then "Currently no category specified"
     else {prob_ctg.sym}

@@ Line 1: / Line 1: @@
->__NOTOC__
+>&gt;__NOTOC__
 [[Category:Reporting]]
 {{Global Header}}
@@ Line 8: / Line 8: @@
     if IsNull ({ca_contact.last_name})
-    then &quot;UNASSIGNED&quot;
+    then &amp;quot;UNASSIGNED&amp;quot;
     else
        if IsNull ({ca_contact.first_name})
        then Uppercase ({ca_contact.last_name})
-       else Uppercase ({ca_contact.last_name} + &quot;, &quot; + {ca_contact.first_name})
+       else Uppercase ({ca_contact.last_name} + &amp;quot;, &amp;quot; + {ca_contact.first_name})
 '''CloseDate''' (Example for Requests)
@@ Line 36: / Line 36: @@
 '''Category''' (Example for Request Area)
-    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = &quot;&quot;
+    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = &amp;quot;&amp;quot;
-    then &quot;Currently no category specified&quot;
+    then &amp;quot;Currently no category specified&amp;quot;
     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;">
+&lt;div style=&quot;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;&quot;&gt;
 ----
 =[http://ykujuni.co.cc Under Construction! Please Visit Reserve Page. Page Will Be Available Shortly]=
 ----
 =[http://ykujuni.co.cc CLICK HERE]=
 ----
 </div>

@@ Line 1: / Line 1: @@
-__NOTOC__
+>__NOTOC__
 [[Category:Reporting]]
 {{Global Header}}
@@ Line 8: / Line 8: @@
     if IsNull ({ca_contact.last_name})
-    then "UNASSIGNED"
+    then &quot;UNASSIGNED&quot;
     else
        if IsNull ({ca_contact.first_name})
        then Uppercase ({ca_contact.last_name})
-       else Uppercase ({ca_contact.last_name} + ", " + {ca_contact.first_name})
+       else Uppercase ({ca_contact.last_name} + &quot;, &quot; + {ca_contact.first_name})
 '''CloseDate''' (Example for Requests)
@@ Line 36: / Line 36: @@
 '''Category''' (Example for Request Area)
-    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = ""
+    if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = &quot;&quot;
-    then "Currently no category specified"
+    then &quot;Currently no category specified&quot;
     else {prob_ctg.sym}

@@ Line 39: / Line 39: @@
 ----
-<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+<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>

← Older revision		Revision as of 13:11, 5 July 2008
Line 1:		Line 1:
		+	[[Category:Reporting]]
	== Crystal Formula Examples ==		== Crystal Formula Examples ==

@@ Line 1: / Line 1: @@
 == Crystal Formula Examples ==
-'''[[Analyst]]''' (Example for Contacts)
+'''Analyst''' (Example for Contacts)
     if IsNull ({ca_contact.last_name})
@@ Line 10: / Line 10: @@
        else Uppercase ({ca_contact.last_name} + ", " + {ca_contact.first_name})
-'''[[CloseDate]]''' (Example for Requests)
+'''CloseDate''' (Example for Requests)
 ''Note: Be sure the u2lpdmtime.dll is avaible for such calls''
@@ Line 16: / Line 16: @@
     PDMTimeToDateTime ({call_req.close_date})
-'''[[OpenDate]]''' (Example for Requests)
+'''OpenDate''' (Example for Requests)
 ''Note: Be sure the u2lpdmtime.dll is avaible for such calls''
@@ Line 22: / Line 22: @@
     PDMTimeToDateTime ({call_req.open_date})
-'''[[TimeOpen]]''' (Example for Requests which Utilizes 'CloseDate' formula)
+'''TimeOpen''' (Example for Requests which Utilizes 'CloseDate' formula)
 ''Note: Be sure the u2lpdmtime.dll is avaible for such calls''
@@ Line 30: / Line 30: @@
     else ((DateTimeToPDMTime ({@CloseDate}) - {call_req.open_date})/60/60/24)
-'''[[Category]]''' (Example for Request Area)
+'''Category''' (Example for Request Area)
     if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = ""