Excel output

[gshilpa24]

Hi,
Can the report title text which is around 40 characters long , say Arial 16 Bold Italic in the report title area ( Header ) in report studio be displyed in a single line when run in Excel format - Single sheet.
The text displayed in excel format should appear as heading in a single line. 40 characters text appears in a single column where the text is split, where as i want the text to appear in a single line at the center without spliting. Please let me knw if this is possible through any properties in Cognos report studio.

Please help me.

Thanks in Advance

[MDXpressor]

The secret here is to drop a table in the header above your data container.  I like to use 10 columns.  It should have one row that is unpopulated (this means 2 rows if you only want a title).

Merge all of the cells of the top row, and change it's class (through the properties pane) to Report Title Area.  Drop a text item into the newly merged row, and voila!  You now have a cell that will appear merged in an Excel delivery.

Cheers

[gshilpa24]

Hi,

Thank you very much ... It worked ...  :)