IBM Support

Running reports with prompt pages as Excel may generate the error: "TypeError: Unable to get property 'text' of undefined or null reference"

Product Documentation


Abstract

When running reports with prompt pages to Excel, some users may experience a TypeError.

Content

On some reports with prompt pages, when users run as Excel, a Javscript error may appear in a dialog box: "TypeError: Unable to get property 'text' of undefined or null reference".

Cause

There can be multiple causes for this error, however common ones include:

  • There are default selections assigned to a prompt on a prompt page
  • There are empty cells inside the table on the prompt page
  • Report styles are not upgraded and are still on old styles
  • Old Java/Javascript files are being cached in your browser

 

Resolution

If these reports were migrated from a previous Cognos installation, please make sure the Report Styles (under Report Properties) are updated accordingly. If the reports are using old styles, this may cause Javascript issues.

Also please clear the cache on your browser, which may resolve the issue.

 

Default Selections

Report Styles Page

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"Reporting","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.X","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

More support for:
IBM Cognos Analytics

Software version:
11.0.X

Document number:
733601

Modified date:
17 October 2018

UID

ibm10733601