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.
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.