We have a report that creates a spreadsheet. One of the data items in the spreadsheet is a text comment that can have quite a few characters. Somehow, during the creation of the spreadsheet, these comments don't wordwrap but rather create and fill merged cells. No grouping or other formatting is done by us that would cause this. It appears that Cognos is doing it as some kind of default.
Is this so? Is there a way to prevent it ?
take a table arrange u r list report in that table now insert a text label within the table..
it will work for sure.
set the White Space property of the field to No Wrap
put you data items into a blocks will prevent merging the rows in Excel
1- unlock the list or the cross tab
2- put a block for each data item then put data item into it