Cognos for Microsoft Office - Issue importing large crosstab and list in Microsoft Word

Technote (troubleshooting)


Problem(Abstract)

Cognos 10.1.1 Cognos for Microsoft Office report containing large crosstab or list takes long time to open or fails to open in Microsoft Word, this same cognos report opens in Microsoft Excel without issue

Cognos 10.1.1 Cognos for Microsoft Office importing large crosstab or large list object from cognos report in to Microsoft Word takes long time to open or fails to open

Symptom

Opening of the cognos report containing large crosstab or list takes very long time to open or fails to open in Microsoft Word, no particular errors associated wit this issue.


Cause

Report design not suitable for Microsoft Word API

Resolving the problem

This is due Microsoft Word ability to handle and render complex report design , for example if cognos reports are designed following the flow-based model used in Microsoft Word then those reports are going to translate well when imported into Microsoft Word, more complex design options available in cognos report studio such us large lists, tables and crosstabs and objects that are embedded within a list or crosstab in general cause issues when imported in Word ( this in general is not the case when this same reports are imported in Microsoft Excel ( Microsoft Excel is designed to handle large tables, lists and crosstabs). Following cognos documentation provides guidelines and recommendations when designing cognos reports for Cognos for Microsoft Office:

Cognos for Microsoft Office user guide (refer to chapter 6):

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.1.1/ug_cxc.pdf

Cognos online documentation:


http://pic.dhe.ibm.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc%2Fc_cr_rptstd_intrd_recommendation_creating_go_office_reports.html


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos for Microsoft Office

Software version:

10.1, 10.1.1

Operating system(s):

Windows

Reference #:

1619374

Modified date:

2013-07-17

Translate my page

Machine Translation

Content navigation