The content of the Custom Report shows #NAME?

When building a Custom Report, the content of the cells shows #NAME?

When you drag items from the source tree directly to a cell of a worksheet, you are creating a COGNAME or COGVAL formula that references the item in the database. This functionality is available only when the CognosOfficeUDF.Connect automation add-in is loaded.

If #NAME? appears in the contents of the cell, it means that the add-in was not loaded and the CognosOfficeUDF.Connect check box in the Add-in dialog box (Tools, Add-Ins) is not selected.

To resolve this issue and ensure that the add-in is always properly loaded, you must verify that the value of the OPEN registry key is set to /A "CognosOfficeUDF.Connect". If you use version 7 of Microsoft Windows operating system, you must use Run in XP from the command prompt to reregister file types.

Procedure

  1. From the Windows Start menu, click Run.
  2. In the Open box, type Regedit, and then click OK.
  3. In the Registry Editor, go to the Registry branch:

    HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\version\Excel\Options

  4. In the topic area, right-click the OPEN entry, and then click Modify.
  5. In the Value Data box, type

    /A "CognosOfficeUDF.Connect"

  6. Click OK, and then close the Registry Editor.