crystal reports viewers, crystal reports schedulers, view crystal reports, report analyzers, burst reporting, report scheduler
 
view crystal reports, rpt viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler
desktop viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler

Crystal Reports Tools: Improve Performance While Saving Time and Money
  Resources  
Best sellers:
cView
Report Analyzer
cViewSERVER
 ReCrystallize
 


Articles:
 Administration
Advanced
Basic
 Crystal eNL
Database
Financial
Problems Solved

 Books:
CR Books
Database Books
Developer Books
 
Tools:
Analyzers
Bestsellers
CR Schedulers
CR UFLs
CR Viewers
DataBase Tools
Graphics
International
Mail UFLs
ReCrystallizePro


Add'l:
About us
Contact Us
cViewSUITE Ppt
Support
 

CrystalReports
on Steroids

Crystal Reports: Working Days User Function Library

Seagate Info developed a UFL (User Function Library) that can be used to see if a day is a local working day.

It uses a text file which you manually load with the local holidays for the date range you report on. It supports multiple text files, so you could use it to handle local holidays – e.g., Auckland Anniversary day (which, for some reason, the rest of New Zealand doesn’t celebrate).

This UFL appears with all the other "Additional Functions" in the formula editor.

All the additional functions in the formula editor are based on UFLs. Go to http://support.businessobjects.net and search for "WorkingDays" and download a free copy.

 

What if you need other UFLs? You could consider writing your own.

What does it take to write a good UFL? Here are some of the requirements:

  • A solid knowledge of a programming language such as Visual Basic.

  • A solid understanding of how to write DLLs.

  • A solid understanding of how to write DLLs that "play nice" with other programs.

  • An understanding of the Crystal Reports Equations Editor and Function Tree.

  • Knowledge of the file-naming conventions that allow UFLs to work properly and to cohabitate with other coding.

  • Knowledge of how to declare and create items inside the class  modules.

  • Understanding of, and adherence to, Crystal Reports' UFL deployment requirements.

  • The ability to test UFLs on various machines and across various test situations--both simulated and real.

  • The ability to update the UFL when updating Crystal Reports.

  • The time and patience to develop the UFL methodically, streamline its code, and test it properly.

Now, don't worry if you don't have all of requisite skills and resources. We have all of these and more, and thus they can fill the void for you (see below).

But where does a UFL go?

User Function Libraries are used inside a formula to add calculations that are not otherwise available. They show up as Functions in your Formula Editor and extra functions are usually displayed under Additional Functions.

We have developed some interesting functions, and there are some others available from Business Objects and other 3rd party developers.

User Function Libraries first appeared in Crystal Reports 5, and were a DLL that was installed in the Windows\Crystal folder. This folder continues to work for all subsequent versions of Crystal Reports.

You can also install them in the Crystal Program folder. This varies from version to version since version 9.0. Crystal Reports 2008 installs into

C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86

Some great UFLs

Below is a listing of some great UFLs. Click the link or associated image for pricing and information on each one.

 

 

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.