IBM Support

Word and Excel report options are missing from Report Export

Troubleshooting


Problem

This technote explains why the Microsoft® Word and Microsoft Excel report options are missing from IBM® Rational® ClearQuest® Report Export options.

Cause

After creating a ClearQuest report using Crystal Reports and trying to export (the envelope icon), Microsoft Word and Excel are not listed as a choices in the Format dropdown list.

Resolving The Problem

Using the following to troubleshoot this issue:

  1. Were the export options previously there? If so, what changes have been made since it last worked?
  2. Do the following dll files exist under WINNT\Crystal
    • U2FWORDW.dll (exports for MS Word)
    • U2FXLS.dll (export file for Excel)
  3. Usually de-installing Business Objects Crystal Reports and ClearQuest fixes the problem.
    When de-installing make sure you do the following:
    1. Go to Add/Remove Programs in the Control Panel and remove ClearQuest and Business Objectives Crystal Reports.
    2. In the system registry, delete the keys
      • HKEY_LOCAL_MACHINE\Software\Rational Software
      • HKEY_CURRENT_USER\Software\Rational Software
      • HKEY_CURRENT_USER\Software\Rational Extended Help
    3. In Windows Explorer delete the directory where the products (TeamTest and Crystal Reports) had been installed.
    4. Reboot the system.
    5. Reinstall ClearQuest
    6. Reinstall Crystal Reports



[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Reporting","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.00","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Historical Number

10466

Document Information

Modified date:
16 June 2018

UID

swg21123227