If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Exporting to excel

Started by chris2001dc, 27 Mar 2009 05:55:16 PM

Previous topic - Next topic

chris2001dc

Hi,

I am working with Cognos 8.3, trying to export to Excel 2002
Please your help with this, I have 2 questions about a report that I am trying to export to excel.
1) The column width of a crosstab column is not the same when I open the report with Excel 2002 and Excel 2007.
Although the white space is no wrap, the text in Excel 2007 is not wrapped, but in Excel 2002 it is wrapped.
I want the text wrapped.
2) The borders of a crosstab are not painted in Excel 2002, Is it any way to paint the borders.

Thanks for your help

I attach a picture for better understanding.


Rutulian

Hi Chris,

I found this when searching for my own purposes for similar questions.  Hopefully you've found a fix, but this might help someone else down the line!

The edges of the crosstab can be given borders as follows:

1) Click on a cell in the crosstab
2) Use the 'ancestors' arrow in the properties pane to select the actual crosstab, rather than selecting all the cells in it (I did this many times before finding the trick)
3) Now you can apply borders using the standard item in the menu bar