Using CLR Integration in SQL Server 2005
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.
Also, if I create a standard sql stored procedure, but include a CLR SQLFunction, it also fails in Crystal Reports.
Considering CLR Intergration ha sbeen around since 2004/5, I would have expected CR 2008 to ba 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.