CR8 only seeing 256 characters of SQL DB record 2

[mark929]

I'm pulling text from a SQL DB fed by a web form. The DB field is set "nvarchar" at 1000 charcters. The DB field is getting all the characters, but my CR8 report is only displaying what looks like 256 characters of the record. A physical increase in the report field makes no difference. Is there any way to increase the number of characters that can be displayed in my report field?

Thanks

Mark

 

[jymm]

Had the same problem here a while back --- hence the reason that I am now on Crystal 9 where there is not a limitation like that. The only way I know to get around it with 8 is to display 4 seperate fields --- it is a pain. Switch to 9 it will be alot cheaper than your time making the solution.

 

[synapsevampire]

You can create SQL Expressions to break it into 4 formulas:

substring(table.field,1,250)
substring(table.field,251,250)
substring(table.field,501,250)
substring(table.field,751,250)

Not too much work.

You can then place all 4 of these formulas into a text object and it will appear as a contiguous field.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mark929]

Thanks to all who replied. Looks like I'll be requesting CR9 soon.

Mark