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
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
Hi,
Thank you very much ... It worked ... :)