- Crystal Reports 2008
- Microsoft SQL Server
VARCHAR(MAX) and NVARCHAR(MAX) fields are mapped to Memo field type, which can't be used for joins or links.
***WARNING***: The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems. Use the Registry Editor at your own risk. Refer to Note 1323322 for more information.
There is a registry key named MapMaxTypeToString (DWORD) which must be created and set at the following location:
Browse to HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\Database\ODBC
Create a new DWORD value with the name MapMaxTypeToString
Set the value data to a number between 0 and 65534 (decimal). This specifies the string size of the VARCHAR(MAX) and NVARCHAR(MAX) fields.
If the key is not set or set to 0, the ODBC driver will map VARCHAR(MAX) and NVARCHAR(MAX) fields to Memo type, which can not be used to join/link.
VARCHAR(MAX), NVARCHAR(MAX), linking , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To