Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: tupac_rd on 15 Jul 2010 08:54:51 AM

Title: fixed width in Excel
Post by: tupac_rd on 15 Jul 2010 08:54:51 AM
Hi Gurus,

FOr a simple list report, can we make all the columns of same width (for eg. 75 px) when we run the report in Excel.... HTML & PDF works fine, but I could not get to work in Excel.... Please let me know if there is a way out..

THanks
2pac
Title: Re: fixed width in Excel
Post by: PRIT AMRIT on 11 Jan 2011 08:55:57 PM
hi,

I face the similar issue as well, any work around?

Thanks
P
Title: Re: fixed width in Excel
Post by: PRIT AMRIT on 12 Jan 2011 12:43:09 AM
It's a Cognos Limitation... pls find the below link

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id31455excel_appendx_unsupp_formatting.html

Thanks
P
Title: Re: fixed width in Excel
Post by: cognostechie on 12 Jan 2011 12:50:07 AM
Yes, you can. What's the problem doing it? It will be applied to all outputs, not just Excel.

If you want to do it only for Excel, create a Prompt asking the output type, if Excel is chosen, then use that list which has fixed width applied for 75px otherwise use another list.

By the way, setting width property for columns doesn't always work. If you unlock the object and then set the width, that works perfectly.
Text only | Text with Images