Cognos: How to get the title of the report in Center in Excel output

Hi All,

Working with Cognos,I figure it out that Cognos is not good when the things come to excel.Recently working on the report, I found a way to get the title of the report in center of the report.

1. Create a table in the report header with no. of rows 1 and no. of columns will be the number of the columns in the list report ( we assume 5).
2. Start merging(do not delete or cut) the each of the column cell one by one and make it look like 1x1.
3. Then enter the title and make it center align.
4. Run the report in Excel O/P.

Thanks,

Nimesh Patel