I have a crosstab, with the totals, sub totals and rows displayed in a single column.
This gives me correct outputs in HTML and Excel 2002 but not in Excel 2007 and PDF.
I have tried running this on 2 environments
Cognos 10.1 GA - All outputs are correctly formatted
Cognos 10.1.1 - Do not get correct format in Excel 2007 and PDF
I am attaching a sample based on the "GO Sales (Query)" package.
Please help with the issue.
Pinned topic Cognos 10.1.1 - Issue with Excel 2007 and PDF Exports
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-08T05:07:05Z at 2012-05-08T05:07:05Z by SystemAdmin
Re: Cognos 10.1.1 - Issue with Excel 2007 and PDF Exports2012-05-07T08:22:46ZThis is the accepted answer. This is the accepted answer.
- Details of the issue:
When exporting in Excel 2007 or PDF, The subtotal, grand total cells are shifted to the right (as shown in attached file).
This only happens in 10.1.1 and not in 10.1
As the production server has already been upgraded to 10.1.1, this is creating a lot of problems.
Re: Cognos 10.1.1 - Issue with Excel 2007 and PDF Exports2012-05-07T08:25:15ZThis is the accepted answer. This is the accepted answer.
SystemAdmin 110000D4XK1959 Posts
Re: Cognos 10.1.1 - Issue with Excel 2007 and PDF Exports2012-05-08T05:07:05ZThis is the accepted answer. This is the accepted answer.
- Deva_S 270003JN2D
Attached is a modification of your report showing one way to use the box type property to hide the row nodes. Note that an extra crosstab space has been added to the grand total row to ensure that there is a consistent removal of 2 cells from each row of the crosstab output. The consistent removal of the same number of node cells inadvertently results in the proper alignment of the output in your sample report.
On a side note, you might consider contacting IBM support to let them know that the formatting capabilities for hiding crosstab elements should be improved via an enhancement to the product capabilities.