SAP Knowledge Base Article - Public

1915515 - Additional Functions is blank in Crystal Reports designer.

Symptom

  • Additional Functions is missing or blank in Crystal Reports designer.
  • In Crystal Reports, when opening or refreshing a report, get the error: UFL 'u2l2dts.dll' that implement this function is missing.

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011

Reproducing the Issue

  1. Open Formula Workshop in Crystal Reports designer.
  2. Expand Functions -> Additional Functions.
  3. It is blank.

Cause

Crystal Reports loads the incorrect version of u2l2dts.dll if an older version of Crystal Reports is installed on the same machine. In certain cases it might be possible that a random older version of .dll is loaded.

Resolution

Workaround 1

  1. If the older versions of Crystal Reports is installed on the same machine, uninstall the older versions and the latest version of Crystal Reports.
  2. Do a clean uninstall of all the versions of Crystal Reports.
  3. See SAP Knowledge Base Article 1876618 to manually uninstall Crystal Reports 2011 and for Crystal Reports 2008 refer 1197923.
  4. Perform a fresh installation of Crystal Reports.

Workaround 2

Add the dll into the same location as Crystal Reports executable. The steps to add is as follows:

  1. Right-click on the shortcut that starts Crystal, click properties and then click 'Open File Location'
  2. This will open the location of 'crw32.exe'. (make sure crystal is closed)
  3. Copy the dll from the machine where the report is working into this folder.
  4. Restart Crystal Reports.

 

Keywords

Additional Functions missing , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011