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

Export to Excel (Long Column Headers not Wrapping)

Started by aerick911, 28 Apr 2014 12:16:39 PM

Previous topic - Next topic

aerick911

In report studio(Cognos 10.1.1), I am attempting to create a report where the columns are quite long and would like to word wrap them.

Despite  setting RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL to TRUE in the advanced paramets in batch report and reporting services in the configs(and restarting the service).  I cannot for the life of me get the column headers to word wrap.

I have tried forcing the "Word Wrap" function, forcing the height and width of the fields, and despite whatever I attempt, exporting to excel will keep the columns in one row.  When exporting to PDF or HTML, I get the desired results.

Has anyone gotten this to work properly?

Thanks in advance!