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

 

[Reebo99]

I don't know if this is a restriction in CR8, but I'm using CR9 and it works fine. Reebo
Scotland (Raining)

 

[Naith]

All Crystal versions prior to 9 have a display limit of 255 characters. v9's display limit runs into thousands.

Use a SQL query to display the full field, if you need it. Or display the output split over more than one formula.

Naith

 

[Reebo99]

Naith,

Using formulas, do you mean create:
Formula1
left({memo_field},255)
Formula2
mid({memo_field},256,255)
etc.?

Also Naith,(sorry mark929 for posting this here) could you take a look at thread782-479507 as I reckon this is right up your street mate. Reebo
Scotland (Raining)

 

[Naith]

You can't do that to a memo field. But I was thinking along those lines for a varchar2 field - though I haven't tested it at all.

Naith

 

[mark929]

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

Mark