Symptom
- MS SQL Server Database Fields are defined as VARCHAR(MAX) or NVARCHAR(MAX)
-
When creating a report based on an ODBC connection to MS SQL Server, and trying to link the tables in Crystal Reports, the Database Linking option of any VARCHAR(MAX) and NVARCHAR(MAX) fields are grayed out or not available.
- How to link MS SQL Server Tables on fields defined as VARCHAR(MAX) or NVARCHAR(MAX) in Crystal Reports?
Read more...
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
- MS SQL Server 2014
- MS SQL Server 2016
- MS SQL Server 2019
- MS SQL Server 2022
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020
Keywords
CR, VARCHAR(MAX), NVARCHAR(MAX), linking , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.