Data.SqlClient.SqlClient
Hi,
I created a custom dll to be used in reporting services.
In this custom dll I have a method that will querying a database and return values that I will use as parameters for my report, something like,
My report is expecting a division as parameter and as default value I set this expression
"= CustomDLL.ClassName.GetDivision(User!UserID)",
Inside the function I have something like this
"Select division from UserDivisions where UserID = @functionParameter"
I tried the dll and everything works fine but when I use it either in Report Builder or Report Designer (BI) it fire me with this error.
System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Some people suggest to make some changes in rspolicy.config file to pass this error, I have try all that without result,
One more thing I have Form Authentication in my SSRS.
Thanks in advance.
May 22nd, 2012 2:46pm


