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

Headers in a list report

Started by Natali, 21 Oct 2008 10:29:24 AM

Previous topic - Next topic

Natali

I have been researching a question that should be simple.

I am writing a list report and running it in Excel format.  The problem is that the column headings are WAY too wide.  Is there a way in Cognos that I can make the space for column headings bigger and set the column headings to be multiple lines rather than just one huge hunk of crap?

Thanks  John

CVR

I noticed this problem when the headers continuous lines like 'sales_per_month_country_wide' ... instead of this if you give the header like 'sales per month country wide' ... cognos automatically adjusts the header widths to fit the page width...

Try this out .....

Natali

Thanks for your suggestion.  But this does not seem to be true when the report is produced in Excel format.  It seems that Excel is the culprit here to me.  I give it a heading like you suggested (individual words not connected) yet when I get the report the headings are all strung out like: 

"Sales From Recent Months That Have R In Their Names"

It is annoying.

John

Suraj

If you go through user guide, it lists many limitations on using EXCEL and formatting is one of them.
however, you may be able to use end of line and new line commands inside cognos data item to ensure the text is broken into multiple lines.