Crystal Reorts and 'BLOB' CR/LF Formatting as Datasource

[misuser]

I have an issue trying to set up a proof of concept.

I want to load letter text into an SQL Server DB with CR/LF formatting. I want this formatting to be preserved in the DB. Can Crystal Reports Recognise this formatting when the field is placed on the Crystal Report (ie the paragraph formatting and line spaces etc?) Also, anyone know how can I create this type of data file and load it to the SQL 2000 DB?

Any help most appreciated?

Tom

 

[synapsevampire]

Crystal recognizes and preserves formatting, though when requesting technical information you should at the bare minimum state your version, at least you did so for the database.

I think that the data type you seek for just text in SQL Server is Text.

You can also store documents themselves in an image field, but I wouldn't suggest it.

-k

 

[misuser]

Thanks that great to know and good advise!