{"id":2514,"date":"2013-11-17T15:24:18","date_gmt":"2013-11-17T19:24:18","guid":{"rendered":"http:\/\/kenhamady.com\/cru\/?p=2514"},"modified":"2017-04-02T09:57:28","modified_gmt":"2017-04-02T13:57:28","slug":"crystal-reports-formula-function-libraries-2013-update","status":"publish","type":"post","link":"https:\/\/kenhamady.com\/cru\/archives\/2514","title":{"rendered":"Crystal Reports formula function libraries (2013 update)"},"content":{"rendered":"<p>It is time for my annual <a title=\"UFL Comparison\" href=\"http:\/\/kenhamady.com\/cru\/comparisons\/crystal-reports-ufl\" target=\"_blank\">comparison of formula function libraries<\/a>. If you aren\u2019t familiar with User Function Libraries (or UFLs) they are DLL files that add new formula functions to your Crystal Reports formula editor. With these functions your formulas can do some pretty amazing things like:<\/p>\n<p>1) Carry values from today\u2019s report to tomorrow\u2019s report<br \/>\n2) Carry values from one report to another.<br \/>\n3) Append lines of text to an external text file.<br \/>\n4) Automatically copy a value to the clipboard.<br \/>\n5) Check the user name of the user running the report.<br \/>\n6) See if a file or folder exists (on your network or on the internet).<br \/>\n7) Rename\/copy\/delete a file on your hard drive or network drive.<br \/>\n8) Launch an application or run a batch file.<br \/>\n9) Execute a SQL statement (Select\/Insert\/Delete).<br \/>\n10) Send an Email using information in the report.<br \/>\n11) Create a table of contents or an index for your report.<br \/>\n12) Calculate distances between zip codes or long.\/lat. coordinates.<\/p>\n<p>If this sounds interesting you can read my <a title=\"UFL Comparison\" 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. The five UFL providers are:<\/p>\n<p>Bjarke Viksoe (U2lwin32)<br \/>\nMaginus Software (CRUFLMAG)<br \/>\nMillet Software (CUT Light)<br \/>\nChelsea Tech (File Mgt, Text, Share and others)<br \/>\nCrystalKiwi (Export, Table of Contents)<\/p>\n<p>The only vendor that has reported changes since last year is Millet Software. Ido Millet has added a handful of new functions to CUT Light. You will find these highlighted in the matrix. If you need help deploying one of these functions in a project let me know.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It is time for my annual comparison of formula function libraries. If you aren\u2019t familiar with User Function Libraries (or UFLs) they are DLL files that add new formula functions to your Crystal Reports formula editor. With these functions your formulas can do some pretty amazing things like: 1) Carry values from today\u2019s report to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,9],"tags":[],"class_list":["post-2514","post","type-post","status-publish","format-standard","hentry","category-formulas","category-news","category-products"],"_links":{"self":[{"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/posts\/2514","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=2514"}],"version-history":[{"count":0,"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/posts\/2514\/revisions"}],"wp:attachment":[{"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/media?parent=2514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/categories?post=2514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kenhamady.com\/cru\/wp-json\/wp\/v2\/tags?post=2514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}