Using CLR Integration functionality in SQL Server 2005 in CR 2008
I have several CLR SQLProcedures in my SQL Database for performing performing complex selects with regex etc. These work exceptionally well form with Visual Strudio for retrieving a dataset. However from within Crystal Reports I can not see these stored procedures, so cannot use the to report on, which was the whole idea of creating them.
Considering CLR Intergration has been around since 2004/5, I would have expected CR 2008 to be able to make use of them, but I can find no way to make them work.
I hope some one can assist me in this quest.
Jason Long replied
Hate to say this but I'm baffled. Until you actually do something with it, CR shouldn't even know that there is a difference between a T-SQL SP and a CLR SP.
If nothing else, that's probably a good indication that the problem is either in the Native Client settings or at the server level.
I did some Google searching but didn't find anything relevant.