Displaying Varchar fields wider than 256 char in Crystal Reports

[mohaimen]

Hi,

I am developing an application using SQL Server at the back-end and VB 6 and Crystal Report 8.5 at the front end. Some of my database fields (varchar) are wider than 256 chars. I have no problem in displaying these field values in VB forms. However when I try to display then in Crystal Reports report, only the first 256 characters are displayed.

Can anyone help me in solving the problem?

Mohaimen

 

[synapsevampire]

Fields larger than 254 will display in CR, you just can't use them in formulas.

This is a known size limitation, and if you need to use these in formulas, or your code is treating tham as such, then you'll need to parse them and then concatenate them together using a text object in CR.

-k