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

Report Output to Excel with No Wrap But fixed width columns

Started by hike22, 02 Apr 2021 10:41:56 AM

Previous topic - Next topic

hike22

I want to be able to output to excel where there is no wrap in the data text, but the column width is fixed to a smaller size.  Essentially the rest of text in the cell will be hidden until a user manually adjusts it.  However no matter how I set the Size & Overflow settings in Properties, the column size always expands to fit the entire line of text.  Or it will merge multiple columns together in Excel to fit it all.

Any help is appreciated!

I am using IBM Cognos Analytics 11.0.13 (LTS).


Thanks!