Display a field longer than 255 Characters

[carlingac]

Display a field longer than 255 Characters

Hi I am using crystal reports v8.5.

On a report I have fields from a lotus notes database, and the problem is one of the fields data exceeds 255 characters. Crystal Reports seem to only show unto 255 characters of the data.

All I would like to do is display the field, I don’t need any sorting or formulas on the field and am hoping someone knows a easy work around.

I have read about memo fields in crystal reports that can store over 255 characters which would be great for me, but I cant find out how to create one.

When I browse the field data, crystal reports show’s it as a string, can it be converted to a memo?

Any help would be greatly appreciated, I am a novice with crystal reports and haven’t used any formulas in a report before, I only use it to display.

Many thanks

 

[Madawc]

Sorry, there is no neat solution in Crystal 8.5. It has been fixed in later versions. You will need to write formula fields with commands like:
Left({your.field}, 255)
Mid ({your.field}, 256, 255)
etc. till the maximum possible is allowed for.

You will then need to drop the formula fields in to a text box. You can't combine them into another formula field, because that too would hit the 255 limit.

Madawc Williams (East Anglia, UK)