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!