Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
trackjunkie
Starting Member
31 Posts |
 Posted - 2009-09-15 : 14:13:31
|
| I am working with crystal reports. One subreport is going to return a whole bunch of text about a given item (there is one row per item, and one unique text per item). This text is best displayed split up into a number of paragraphs with blank lines between paragraphs. Right now I have the entire text in a single nvarchar(max) field for a given item. The problem is all the text is displayed on the report as one long string, as you would expect. Before I go spend hours inserting a bunch of spaces so that the text wraps around to give me blank lines and paragraphs, is there a type a field that will let me include that formating? I'm picturing something like linking a field to an outside text file with all the formatting I want done there. Is that possible? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-16 : 13:26:10
|
| what all formatting you want to apply?can you be more specific? |
 |
|
|
trackjunkie
Starting Member
31 Posts |
Posted - 2009-09-16 : 15:25:39
|
| I just want to be able to break the long string of text into paragraphs with spaces in between. For example:xx xxxxxxxxxxx x yyyyyyy yyyyyyyyyyyyyyyyyyyzzzzzzzzwould be displayed as xx xxxxxxxxxxx xyyyyyyy yyyyyyyyyyyyyyyyyyyzzzzzzzz |
|
|
|
trackjunkie
Starting Member
31 Posts |
Posted - 2009-09-16 : 15:34:33
|
| Clarification:I'm not expecting things to be automatically broken up. Really the only way I could think to do it better than inserting spaces to force the text to wrap would be to have the contents of the cell be a text file which may be displayed. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-17 : 02:36:52
|
| Have you tried setting Autogrow property to true?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Looking for a certain field type