Error Reporting Services Custom Assembly
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it https://support.microsoft.com/en-us/kb/920769 only takes a minute: Sign up Could not load file or assembly error on adding custom libraries in SSRS reports up vote 1 down vote favorite 1 I have created a custom library(CodeLibrary) which internally references the dlls Microsoft.TeamFoundation.Client and Microsoft.TeamFoundation.WorkItemTracking.Client. I added this custom Dll codelibrary.dll to my SSRS report. and the expression of one of the field as http://stackoverflow.com/questions/32705382/could-not-load-file-or-assembly-error-on-adding-custom-libraries-in-ssrs-reports =codelibrary.codefunction.GetValue(1000) codefunction is the class and GetValue is the method. When I preview the report, I get the error "Error while loading code module: 'CodeLibrary,Version=1.0.0.0,Culture=neutral,PublicKeyToken=null'. Could not load file or assembly 'CodeLibrary,Version1.0.0.0, Culture=neutral,PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified." I am using VS2013, I have placed the custom library DLL in the path C:\Program Files\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies I have tested the custom library with a WPF application and it works fine. I am not able to figure out what is causing this error. reporting-services ssrs-2008-r2 share|improve this question asked Sep 21 '15 at 22:18 perplexedDev 132216 add a comment| 3 Answers 3 active oldest votes up vote 1 down vote accepted You should copy your custom library to the ReportServer\Bin folder ex: C:\Program Files\Microsoft SQL Server\MSRS10_50.R2\Reporting Services\ReportServer\bin Then modify the rssrvpolicy.config in ReportServer folder, find "$CodeGen$" and add the following code
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn http://stackoverflow.com/questions/4329592/reporting-services-custom-assembly more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community https://joyfulcraftsmen.wordpress.com/2015/04/27/setting-security-policy-for-custom-assembly-in-ssrs-2014-sharepoint-integrated-mode/ Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Reporting Services Custom Assembly up vote 0 down vote favorite error reporting I created a custom assembly to convert RTF to plain text and it works nice with the following configuration: SSRS 2008, Win 2003 Server, rssrvpolicy.config changes, an Excecution Account, and IIS 6.0. We created a new server running SSRS 2008R2, Win 2008, and IIS 7. It does not work on this new environment and I do not get any error, but instead the SSRS Service reboots itself. This only error reporting services happens when I reference System.Windows.Forms.RichTextBox(). See code below. Can anyone give me an idea of what I may need to do or test to get this working? I've checked the log files and the Event Viewer, but not seeing any errors. It does call my assembly and works if I just output some text to the report and not call the RichTextControl. It fails when I try to reference System.Windows.Forms.RichTextBox. I also installed to the GAC with no luck, but shouldn't need to(?) and didn't with the old version. I also tried to put a try/catch block around the code to see if I could get the error. If I just throw an error, I get the message. If I call the RichTextBox control, it causes the SSRS service to reboot. My code: using System; using System.Windows.Forms; using System.Diagnostics; namespace ConversionUtility { public class ConversionUtility { [System.Security.Permissions.PermissionSet(System.Security.Permissions.SecurityAction.Assert, Unrestricted = true)] public static string ConvertRTFToText(string richText) { string sText = ""; try { // if I comment out these 3 lines, this will work RichTextBox richTextBox = new System.Windows.Forms.RichTextBox(); richTextBox.Rtf = richText; sText = richTextBox.Text; //throw new Exception("Log this error"); } catch (Exception e) { sText = "Error Caught: " + e.Message; } r
concept for SSRS custom assemblies, custom extensions or other 3rd party components running under SSRS service are connected to the .NET Framework security system. By default all the custom assemblies are running with execute privileges that do not allow any access to specific resources outside of Reporting Services (e. g. files, directories, system variables). Native mode Reporting Services does not support .NET 4 custom assemblies and it can run only assemblies compiled in version 3.5 and older. SharePoint Integrated mode Reporting Services can run .NET 4 assemblies (for details see Microsoft's support page). Our recommendation is to compile assemblies to version 3.5 which can be used in both modes without problems. Figure 1 - Security concept for Custom Assemblies overview Unlike data source access the custom assembly runs always under the account of the Reporting Services. So if this account does not have access to a specific local resource access you will not be able to assign it ad hoc using .NET Framework and configuration files. The security settings for Reporting services are managed via configuration files each of them is being used for different purposes or different types of installations. File name Description Location SharePoint Private Assemblies Folder Place to put your for Custom Assemblies to be used in SP SSRS 2014 in SP mode