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.
- From the Windows Start menu, click Run.
- In the Open box, type Regedit, and then click OK.
In the Registry Editor, go to the Registry branch:
- In the topic area, right-click the OPEN entry, and then click Modify.
In the Value Data box, type
- Click OK, and then close the Registry Editor.