How to use CLR Stored Procedures in Reporting Services?

Hi there.

As subject metioned,I got a problem.

I have a CLR Stored Procedures it works fine in Sql Server Management Studio,but when excuting the stored procedure in Reporting Services Query Builder window(Visual Studio Reporting Services Project),I got a error message "The stored procedure <stored_procedure_name> doesn't exist".

so how to resolve this problem?

my env : SQL Server 2005 , Visual Studio 2005

many thanks.

The CLR stored procedure is attached to a specific database. Make sure that you are connecting to the correct database when you initialize the data source you are using. I have gotten CLR stored procedures to work so I know they will work in Reporting Services.|||

Maybe i got something wrong,i'll check it.

Now i use a T-SQL Stored Procedure as a wrapper to call the CLR one,and it works fine.

thanks and best regards :D

|||

Hi,

I have the same problem.

I also tried with the t-sql stored procedure as wrapper, but when executing it, I get the error

"The transaction context is already in use in another session".

This time the error appears executing the stored procedure from Sql Server Management Studio too.

So I'm giving up. Unless somebody has some suggestions.

Bye.