Skip to Content
Former Member
Oct 29, 2010 at 10:14 PM

Crystal Designer is not recognizing CLR based Stored Procedures


I am using Cystal Developer XI R2 and connecting to a SQL Database. In that SQL Database I have created a CLR based Stored Procedure. I notice that the Crystal Designer (at least by default) does not recognize stored procedures that are CLR based.

My first guess is the reason for this is that the xtype value (from sysobjects table) on this type of procedure is 'PC' instead of the normal 'P' for procedures. Is it possible the designer is only listing objects where xtype is 'P'?

Is there any way to fix this?

Any help is greatly appreciated.

Edited by: Ratinator on Oct 30, 2010 12:21 AM