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

display long text

Started by philelmousse, 09 Feb 2011 02:52:31 AM

Previous topic - Next topic

philelmousse

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 ?

PRIT AMRIT

what is your current report format?

philelmousse

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

PRIT AMRIT

I meant whether your current report is Cross-tab or List ?

philelmousse


Arsenal

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