{"id":2266,"date":"2011-11-13T23:50:14","date_gmt":"2011-11-14T03:50:14","guid":{"rendered":"http:\/\/kenhamady.com\/cru\/?p=2266"},"modified":"2017-04-02T09:57:51","modified_gmt":"2017-04-02T13:57:51","slug":"crystal-reports-formula-function-libraries-annual-update","status":"publish","type":"post","link":"https:\/\/kenhamady.com\/cru\/archives\/2266","title":{"rendered":"Crystal Reports formula function libraries (annual update)"},"content":{"rendered":"<p>It has been one year since I did my first comparison of <a title=\"Formula Function Libraries\" href=\"http:\/\/kenhamady.com\/cru\/comparisons\/crystal-reports-ufl\" target=\"_blank\">formula function libraries<\/a>, so it is time for an update.\u00a0 If you aren&#8217;t familiar with the term, User Function Libraries (or UFLs) are DLL files that add new formula functions to your Crystal Reports formula editor.\u00a0 With these functions your formulas can do some pretty amazing things like:<\/p>\n<p>1) Carry values from today&#8217;s report to tomorrow&#8217;s report, or from one report to another.<br \/>\n2) Append lines to an external text file.<br \/>\n3) Automatically copy a value to the clipboard.<br \/>\n4) Check the user name of the user running the report.<br \/>\n5) See if a file or folder exists \u2013 either on your network or on the internet (http).<br \/>\n6) Rename\/copy\/delete a file on your hard drive or network drive.<br \/>\n7) Launch an application or run a batch file.<br \/>\n8) Execute a SQL statement (Select\/Insert\/Delete).<br \/>\n9) Send an Email using information in the report.<br \/>\n10) Create a table of contents or an index for your report.<br \/>\n11) Calculate distances between zip codes or long.\/lat. coordinates.<\/p>\n<p>If this sounds interesting you can read my <a title=\"User Function Libraries\" href=\"http:\/\/kenhamady.com\/cru\/comparisons\/crystal-reports-ufl\" target=\"_blank\">complete comparison<\/a> including a list of all the functions provided by each DLL. \u00a0 The four primary sources are:<\/p>\n<p>Bjarke Viksoe (U2lwin32)<br \/>\nMillet Software (CUT Light)<br \/>\nChelsea Tech (File Mgt, Text, Share and others)<br \/>\nCrystalKiwi (Export, Table of Contents)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It has been one year since I did my first comparison of formula function libraries, so it is time for an update.\u00a0 If you aren&#8217;t familiar with the term, User Function Libraries (or UFLs) are DLL files that add new formula functions to your Crystal Reports formula editor.\u00a0 With these functions your formulas can do [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2266","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/posts\/2266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/comments?post=2266"}],"version-history":[{"count":0,"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/posts\/2266\/revisions"}],"wp:attachment":[{"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/media?parent=2266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/categories?post=2266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/tags?post=2266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}