Skip to Content
avatar image
Former Member

Link Table on Memo Field

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2017 at 10:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded