Skip to Content
0

Link Table on Memo Field

Nov 28, 2017 at 08:50 PM

24

avatar image
Former Member

I need to link two tables based on a field. The field is listed in CR as a "memo" field type. I can't see any memo fields in the database expert.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Nov 28, 2017 at 11:13 PM
0

Crystal Reports read them as a 'memo' type, but the fields types are actually nvarchar(max). Is this an issue relating to the field size? Why does Crystal Reports read these as a memo?

Thanks!

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Nov 28, 2017 at 10:01 PM
0

Hi Melissa,

You cannot Join on memo fields in Crystal Reports.

You could try using a SQL query as the datasource (with the SQL containing all the joins).

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded