It has been one year since I did my first comparison of formula function libraries, so it is time for an update.  If you aren’t familiar with the term, User Function Libraries (or UFLs) 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’s report to tomorrow’s report, or from one report to another.
2) Append lines to an external text file.
3) Automatically copy a value to the clipboard.
4) Check the user name of the user running the report.
5) See if a file or folder exists – either on your network or on the internet (http).
6) Rename/copy/delete a file on your hard drive or network drive.
7) Launch an application or run a batch file.
8) Execute a SQL statement (Select/Insert/Delete).
9) Send an Email using information in the report.
10) Create a table of contents or an index for your report.
11) Calculate distances between zip codes or long./lat. coordinates.

If this sounds interesting you can read my complete comparison including a list of all the functions provided by each DLL.   The four primary sources are:

Bjarke Viksoe (U2lwin32)
Millet Software (CUT Light)
Chelsea Tech (File Mgt, Text, Share and others)
CrystalKiwi (Export, Table of Contents)