If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report formatting in excel!

Started by actcognosuser, 25 Feb 2010 10:12:15 AM

Previous topic - Next topic

actcognosuser

Hi All,
          I set the width of columns in my list report.When the run is executed in excel format,the formatting is not applied.The column width is too big.It makes the user scroll horizontally to view all the data.Is there any way to control the formatting of the report when it is rendered in excel?

I have two list reports.I am not applying any other special formatting.

jriley

found this in report studio user guide for cognos 8.3....

under Appendix F: Producing Reports in Microsoft Excel
Format...Table and Column Width

Microsoft Excel does not support using percentages to determine the width of tables. If the report contains only one table, the value of the width attribute for the Table element in the report specification determines the width of the table in the Excel worksheet. If the report contains more than one table, Excel determines the width of all the tables in the worksheet. If the tables are nested, the width specified for the outer table is used and, if necessary, the width is adjusted to accommodate data in the nested tables. The columns and rows around the table are merged to preserve the appearance of the nested table. When the workbook is saved, only a single table is saved per
worksheet.

hth,
joe

actcognosuser

Thank u jriley.

I will try to set the width of the table to adjust my column width.I did see the user guide.Thanks for the info.