|
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 -
why use them?
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
Registry User Function Library
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
US$49.97 (US) and
you can
Buy the Registry UFL with a full refund if it does not do what
you want.
FAQs
You may
Buy the Registry UFL from our secure
e-Commerce merchant site for: US$49.97
XML output
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.
You may
Buy the
XML Output UFL from our secure
e-Commerce merchant site for US$49.97
Multiple languages - just one report
This UFL gives report headings,
column headings and text labels 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.
You populate the dictionary in the
different languages of your choosing.
This does not translate the data from
your database - it displays the Page Headings, lables and column
headings in the different languages you source, all from the same
report. The appropriate font for the language can also be chosen.
A free
trial is available
here 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
You may
Buy the International UFL from our secure
e-Commerce merchant site for 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
You may
Buy the SendMail UFL from our secure e-Commerce merchant site
for US$115.97
Outlook User Function Library
Our Outlook User Function Library is no
longer available because Microsoft security updates now discourage third party
vendors from sending email via the developer links built into Outlook.
Please use the SendMail
User Function Library instead which does not have this limitation.
Save and retrieve data between reports
(June 2010)
Our
Share User 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
Share 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.
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
You may
Buy
the Share UFL from our secure e-Commerce merchant site for
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.
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
You may
email us to
Buy the Disk Output UFL for 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
You may
email us to
Buy the Disk Output UFL for 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.
You have more control
compared to simply exporting your report to Excel.
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
You may
Buy
the Grid UFL from our secure e-Commerce merchant site for US$99.97
Disk File Manipulation
File Management User Function Library
(Latest 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
You may
Buy the
File Management UFL from our secure e-Commerce merchant site for 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.
For frequently asked questions about our
products, please click here for our knowledgebase :
FAQs
You may
Buy the Text Lookup UFL from our secure e-Commerce merchant site
for
US$107.97
|
