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.
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
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.