Hi All,
Whenever some User Defined Fields is created in 2007, the underlying field is always of NVARCHAR(MAX) type. This is posing problem when creating a report on the basis of such fields in Crystal, since it does not allow to use such fields for creating links.
How to avoid this problem? It is ok to change the structure using query directly for user defined tables. Since I don't think it would require any changes in the way B1 stores the udf information.
Regards,
Rahul Jain