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 ?
what is your current report format?
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
I meant whether your current report is Cross-tab or List ?
sorry, its a list
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