fixed width in Excel

[tupac_rd]

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

[PRIT AMRIT]

hi,

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

Thanks
P

[PRIT AMRIT]

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

[cognostechie]

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.