Tuesday, February 21, 2012

Reporting Services Custom Code

I created a class library which uses a web reference My SSRS report uses the class through its custom code I copied the dll & dll.config of the class library to the VS2005 private assembllies and the report works I copied the dll & dd.config to the reportserver bin and gave the assembly full trust by adding the necessary code group I even added a code group the give the dll.config file full trust as well Yet on Repost server, the report does not work Any ideas I suspect it is a permission problemThere are alot of problems with the custom code in visual studio. I suggest if possible coding directly in the properties of the report, the commands are slightly different but you can find them by going to <view expression> in the drop down and typing things like System.etc|||My problem stems from using an ODBC dsn The connection works in an ASP.NET environment however it does not work in the class library "connection is disabled" error returned from the Informix driver This why I created the Web Service, just to make use of the DSN connection in the ASP.NET environment|||

[System.Security.Permissions.PermissionSet(System.Security.Permissions.SecurityAction.Assert, Unrestricted = true)]

need this at method headers

No comments:

Post a Comment