Crystal Reports - User Function Libraries

Home Products Services Download Resources Purchases Help


User Function Libraries


Disk Output UFL

File Management UFL

Grid UFL

International UFL

Registry UFL

Share UFL

SendMail UFL

Text Lookup UFL

XML UFL


Knowledgebase

 

 

Export structured data from your report  with our Grid User Function Library (also export to csv format with cViewSERVER scheduler)

Manipulate files from within your report with our File Management UFL

Save data in one report and retrieve it in a subsequent report with our Share UFL

Stop your report / raise an alert / read your Registry values with  Registry User Function Library

Send emails from your report with our SendMail User Function Library

Save and retrieve data between reports with our Share User Function Library

 Write one report but have the headings and labels print in different languages with our International User Function library

Output multiple disk files with our Disk Output User Function library

Conditionally output disk files with our Disk Output User Function library

Use a text file and search for values with Text Lookup User Function Library

Output XML at the same time as your report with XML User Function library


User Function Libraries

User Function Libraries (UFL) are extensions to Crystal Reports formula functions.  You can install these on your machine, and extend the features of your report.

The UFLs below will give you extra functionality within Crystal Reports or reduce the report development time.

When you install a User Function Library (UFL) into your copy of Crystal Reports, it allows you to perform specific tasks via the Formula Editor. You can use UFLs like any other function in Crystal Reports. The appear inside the Formula Editor under "Additional Functions".  Any version after Crystal reports 5 can install and use these useful tools.

FAQs


Use UFLs to reduce report development time or to give you extra functionality


Read your Registry values

Our Registry User Function Library allows you to retrieve user related Registry entries. It does not change them.

We've included a collection of useful registry utilities including the ability to extract a value from the Windows Registry, identify the Windows\Crystal function directory, and an Alert function to stop the report and raise a warning message, and then continue the report. A complete list of functions is available here.

For example, you may retrieve the name of the folder you are exporting to from HKEY_CURRENT_USER by writing a formula

WhilePrintingRecords;
GetRegCurrentUser ("Software\Crystal Decisions\10.0\Crystal Reports\Export","ExportDirectory")

We do not currently have a free download for you to try but the full version is only $49.97 (US) and you can purchase it here.

FAQs


XML output

XML User Function Library (New version December 2009)

XML is an industry standard for data interchange.  The beauty of XML is that both the structure and the content of the data are in the XML document.  We have a Crystal Reports User Function Library that allows you to create a XML document at the same time as you create your report. The XML functions work with multiple groups, and any data from your database that you need to view as XML.  There is a sample xml file included in the zip file from our download page.

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

This will work with Crystal Reports versions 6,7, 8, 8.5, 9.0, 10, XI and 2008.  It will also work with Seagate Info. You can download a trial here

A full version is available from our Purchases page for US$49.97


Multiple languages - just one report

International User Function Library 

This UFL gives report headings in different languages, depending on the country you select.

The theory behind this function is that you can write one report, and then use some functions to select the appropriate report title, column heading and font for each country. A free trial is available with a demo report in three languages, and a 5 word dictionary.  

Let us know if you'd like to add some more countries to the list.

The full version supports 1000 words and is available from our Purchases page.  This includes a fully functional dictionary editor to manage and maintain the lists of words in each language.

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

Cost: US$497.99


Send emails from your report

Our SendMail User Function Library will let you send multiple email messages from one report. It builds up a message within the formula in your report and send that at the end of the report.  It can also include formatted HTML and images in the email message.

This product includes support for SMTP mail servers that require authentication.

Version 2.0 released in June 2008 includes improved diagnostics.

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

Cost: US$115.97

Our Outlook User Function Library is no longer available as Microsoft security updates now discourage third party vendors from sending email via the developer links built into Outlook.  Use the SendMail User Function Library instead which does not have this limitation


Save and retrieve data between reports (New version June 2010)

Our Share Mail Function Library will let you save and retrieve data between reports. How often have you wanted to take a value from one report and use it in a second report?  Now you can.  Use the ShareTagSave function in one report to save the data in a "Share File".  Then in another report use the ShareTagFetch to use that value in your new report.  A session file is a simple xml file and you can use this document format with other applications including InfoPath, SQL server or even a text editor.  We will be using this format in our other cViewPARTY applications.

The trial version has a limit of 20 values per share file.  The full version currently has a limit of 8000 values but this can be increased if you want more.

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

Cost: US$99.97


Export multiple disk files

Our Disk Output User Function Library lets you create multiple disk files and output them to different folders on your network or local drive while processing a Crystal Report. You can also create one or no disk file. You can purchase it from our E-Commerce Site.

An extra feature of this function is that you can conditionally output the disk file(s) - see below.

 If you need to email the multiple disks to a remote folder, see our Send Mail Function Library above. 

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

Cost: US$99.97

 

Output a disk file conditionally

Our Disk Output User Function Library lets you create a disk file conditionally while processing a Crystal Report. 

This function will let you write a single, short file or you can build up a series of fields into a larger file.  Because this process is controlled inside a function in your report, the export can select the lines to go in the file.  Full documentation is here, and you can purchase it from our E-Commerce Site.

 An extra feature of this function is that you can create multiple disk files - see above.

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

Cost: US$99.97


Export structured data from your report

Our Grid User Function Library will let you export data during the processing of your report. Create a Grid work area with the GridCellClear function.  Then load values into the grid with GridCellLoadRawValue or GridCellLoadDelimitedValue.  Then save the grid to a disk file with GridCellSave.

Another advantage of the Grid UFL is that it enables you to export to csv format when scheduling your reports with cViewSERVER scheduler.

The trial version has a limit of 20 columns and 20 rows values per export file.  The full version currently has no limit.

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

Cost: US$99.97


Disk File Manipulation

File Management User Function Library  (New Version - August 2009)

Our File Management User Function Library allows you to manipulate files and folders on your machine.

For example,  in your database table you have a field that includes a file name.  You can use the FielManagementFileExists function to confirm the file name is valid and exists on your machine.  You can then copy, delete or rename the file.

But also remember that Crystal Reports can treat your hard drive as a database.  So write a report to select all the files in a folder with a last modified date, and use the FileManagementFileCopy function to make a copy of those in a date specific folder on your backup drive.

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

Cost: US$99.97


 Lookup text 

Text Lookup User Function Library

Our Text Lookup User Function Library allows you to search text documents and return individual lines or columns. 

For example,  you may not have a database table with descriptions of your codes. By creating a text file with those codes and descriptions, this UFL will read the text file like a table. This avoids you needing to have repeated if..then ..else in multiple formulas.

This set of seven functions enables you to search through a text file and extract lines and columns to display in your report.  A full list of functions and documentation is available here.  A trial version is available from our download page, and you can purchase it from our E-Commerce site. 

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

Cost: US$107.97

Other Products

cView

cViewSERVER

cViewMANAGER

cViewREMOTE

cViewIMAGE

cViewTEXT

cViewLOG

cViewBATCH

cViewMAIL

cViewPICK

cViewSQL

 

 


Bruce Ferguson & Mo Naughton
Copyright © 2010 Chelsea Chelsea Technologies Ltd. All rights reserved.
Revised: June 17, 2010.