COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Gyana on 06 Jun 2012 01:07:56 AM

Title: Wrap Data in Excel
Post by: Gyana on 06 Jun 2012 01:07:56 AM
Hi All,
     I have a list report with 4 data items.I have a Department Column with long value.
i give the data item "WRAP". Its working in HTML fine But when i run it in Excel it comes in one line.

Can anybody help me how to wrap in EXCEL...


Thanks In Advance.
Title: Re: Wrap Data in Excel
Post by: cognosun on 06 Jun 2012 01:49:23 AM
You need to add Wrap related 'Advanced parameter' in Cognos server portal
Title: Re: Wrap Data in Excel
Post by: Gyana on 06 Jun 2012 01:54:44 AM
Hi cognosun,
    Can you please elaborate it, how it ll be done.


Thanks
Title: Re: Wrap Data in Excel
Post by: sbjmSoules on 10 Jul 2012 06:09:02 PM
How do to wrap excel data rows in Cognos 10? Has anyone found the answer?

How is the following accomplished?

You need to add Wrap related 'Advanced parameter' in Cognos server portal"
Title: Re: Wrap Data in Excel
Post by: bi4u2 on 19 Jul 2012 09:54:33 AM
The 10.1 documentation lists this as unsupported formatting.

IBM Cognos Business Intelligence does not support some formatting.
The following formatting functions that are available in the Microsoft Excel
spreadsheet software are not supported by IBM Cognos BI:
v background images in table cells
v Excel-specific headers and footers
v text flow and justification
v floating text objects
v white space, normal, and wrap text formatting
v maximum characters