You can probably use a SQL Expression to either perform the search or cast the data type to something Crystal can use to accomplish this, post the data type and the database being used for further assistance.
I don't have Crystal 9 but I do have 10, I believe however that they are similar.
I noticed that in some areas a memo field doesn't display in the list of available fields (however it does in Record Selection formula for 10 but not in the Select Expert list of fields - odd yes?).
Are you using the Select Expert to generate the formula? If so, go to Report/Selection Formulas/Record and put your formula in there.
Another thing to always try is manually typing the field name in (for example, in the SQL Expression Formula Editor memo fields don't display, but can be used by manually typing them in).
I was having a similar problem to Aftab's. The memo field from my Access database was truncating to 255 charcters in my Crystal report.
Reading your post gave me an idea. The SQL Expression you suggested did not work for me, but a SQL Command did!
Like you said in your post Rosemary, the 'memo' field does not appear in the SQL Command field list in the Database Expert area, but does show up in the Field Expert list. Go figure!
Anyway, the memo field from the SQL Command works just fine in the report (it does NOT truncate it). I wouldn't have got there with out your post.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.