COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Mounika_LP on 28 Feb 2015 11:34:56 AM

Title: how to fit column width size when export to excel
Post by: Mounika_LP on 28 Feb 2015 11:34:56 AM
hi all,
i am using 10.2.1 version relation data base


i used list when html format column size fit(expect output)but when export  excel  the few columns size  not fit
client using only excel format how t fit when export to excel



thanks
mounika
Title: Re: how to fit column width size when export to excel
Post by: Robl on 02 Mar 2015 05:08:19 AM

Exporting to excel has always been tricky as Excel reformats the report when it receives it.
Getting report to look nice in excel has always involved quite a lot of trial and error.

Look at things like nesting blocks and sizing the blocks.
Using fixed size tables and columns.
Etc