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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics