Crystal Designer is not recognizing CLR based Stored Procedures

[Former Member]

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

[former_member11696 · Accepted solution]

Correct, CR doesn't support those.

[Former Member]

My workaround for the time being is to create a normal Transact SQL stored procedure which calls the CLR based stored procedure.