COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: philelmousse on 09 Feb 2011 02:52:31 AM

Title: display long text
Post by: philelmousse on 09 Feb 2011 02:52:31 AM
Hello, I would like display a text column in my report, it could contains lot of words so whats the best solution ? Store it in a list ?
I have to generate my report in excel but that is hugly because the text is display in one row so the report has too big width. How fix that ?
Title: Re: display long text
Post by: PRIT AMRIT on 09 Feb 2011 03:14:05 AM
what is your current report format?
Title: Re: display long text
Post by: philelmousse on 09 Feb 2011 03:17:23 AM
what do you mean ? Thats report studio. Its when I generate the excel file, he display my text in one long row whitout make a return
Title: Re: display long text
Post by: PRIT AMRIT on 09 Feb 2011 03:20:29 AM
I meant whether your current report is Cross-tab or List ?
Title: Re: display long text
Post by: philelmousse on 09 Feb 2011 09:49:05 AM
sorry, its a list
Title: Re: display long text
Post by: Arsenal on 09 Feb 2011 10:05:40 AM
does the report requirement force you to display the entire text in one one, or is it okay with the users to "wrap" the text into a couple of lines?
If so, you could set the width of the text column (properties pane of the list) to something that is not too big that it causes the width of the report to go crazy (you'll have to play around with the width settings a little to find out the optimal setting). text will automatically go into the second line when this limit is reached.

If you do have to display it in one line then you have no other option except to have a big width report. Whether you use a list or crosstab depends upon the reporting requirements.

You could also ask the users if usage of acronyms for the big text item is okay and then you can cast the text items into smaller acronyms within FM or within the DB