Configuring ClearQuest to work with the RATL_LocalDateTime function of Crystal Reports

Technote (troubleshooting)


Problem(Abstract)

This technote explains how to configure IBM® Rational® ClearQuest® to use the RATL_LocalDateTime function of Crystal Reports Enterprise Embedded Edition (EEE). This function displays dates and times in local time rather than Greenwich Mean Time (GMT).

Symptom

When attempting to run a report, you get the following error:



    UFL 'u2lcrratl' that implements this function is missing. Error in formula.'RATL_LocalDateTime ({ClearQuest.date_time1})' UFL 'u2lcrratl' that implements this function is missing.


Cause

The Files required to report local dates and times section of the ClearQuest Information Center states:

    A report format created with the Crystal Reports Designer can include calls to user defined functions which are defined in certain DLL files. Rational ClearQuest installs the u2lcrratl.dll file which implements the user defined function RATL_LocalDateTime. This function displays dates and times in local time rather than Greenwich Mean Time (GMT).

Resolving the problem

ClearQuest needs additional configuration to be able to use the RATL_LocalDateTime function in Crystal Reports. This issue affects both the ClearQuest Native Windows clients and the ClearQuest Web server. The Copying the u2lcrratl.dll section of the ClearQuest Information Center contains the following steps:

  1. Verify that the following directories are in your system path:
    • C:\Program Files\Rational\ClearQuest
    • C:\Program Files\Rational\Common
      Note: This assumes that C:\Program Files\Rational represents your default installation directory.
  2. Add the C:\WINDOWS\Crystal directory to your system PATH environment variable.
    (Control Panel > System > Advanced tab > Environment Variables > Under System variables > PATH).
  3. Copy u2lcrratl.dll from the C:\WINDOWS\Crystal on your system running Rational ClearQuest to the following folder:

    C:\WINDOWS\system32
  4. Restart the target machine where the Rational ClearQuest Server and Crystal Reports Server XI is running.

Note: These steps are also valid for the Crystal Reports 10 Enterprise Embedded Edition (CEEE) that was included with earlier versions of ClearQuest 2003.06.13 through 2003.06.16. These steps where not documented in the earlier releases.

This issue was a reported as defect, APAR IC44167, in ClearQuest, and was resolved in the documentation for the 7.0.0 version.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational ClearQuest
Reporting

Software version:

7.0, 7.0.0.1, 7.0.0.2, 7.0.0.3, 7.0.1, 7.0.1.1, 7.0.1.2, 2003.06.00, 2003.06.13, 2003.06.14, 2003.06.15, 2003.06.16

Operating system(s):

Windows

Reference #:

1214381

Modified date:

2007-04-10

Translate my page

Machine Translation

Content navigation