Memo Field Issue

[Bennie47250]

Using Crystal Version 7.0 and MS SQL 7.0

I have encountered the issue with using a memo field on a report where the text is truncated after 254 characters. How can I display the additional characters?

Looked thru old postings and did not find one. Most of the ones I looked at suggested putting the field in a formula. When I try this, I get an error message indicating “Blob field or memo field cannot be used in a formula”

Looking at the SQL table, it shows the field to be Data Type of varchar with a length of 1000

Thanks
Bennie

 

[IanWaterman]

CR 7 will not handle fields bigger than 254 characters.
You will need to create a view and split field into 4 chunks and the display each new field in the same text box to reassemble.

Ian

 

[lbass]

If you have the ability to write SQL expressions (in the field explorer), you can do this by using a substring. One to the following should work (I'm unsure of the punctuation for MySQL though). Note that you will have to type in the memo field, as it won't appear in the field list.

[1st 254 characters]
(substr(table.`memo`, 1, 254))

Or, possibly (it depends upon your datasource):

{fn substring(table.`memo`,1,254)}

[2nd 254 characters]
(substr(table.`memo`,255,254))

Or, possibly:

[2nd 254 characters]
{fn substring(table.`memo`,255,254)}

//etc., where the first number is the position of the starting character in the string and the second is the length of the substring.

You can then drop the SQL expressions into a text box, nested up against each other so that the text flows correctly.

-LB

 

[kernal]

I can't remember which older version this worked on but try

Adding a text field then inserting the memo field into it and make sure the "Can Grow" option is checked.