Set Microsoft Reporting as Trusted

How to make an assembly trusted for your report code

Because Local Reports like SQL Server Reporting Services reports are written using open format (Report Definition Language (RDL)). Any user can add any code or reference any assembly from your rdl file at the production environment which would cause a BIG security hole. You need to mark these assemblies as trusted inside your Windows Application code. Or you would get an error like this

The report references the code Module 'System.Data, Version=2.0.0.0, Culture=neutral, Publickey Token=b77a5XXXXXXXX', which is not a trusted assembly

You need to use the AddTrustedCodeModuleInCurrentAppDomain method of the LocalReport class. You can add the following line at the Form_load event handler of your windows application.

this.reportViewer1.LocalReport.AddTrustedCodeModuleInCurrentAppDomain("System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089");

Source:

http://blogs.msdn.com/b/mosharaf/archive/2005/12/20/localreportcustomcode.aspx

References:

http://msdn.microsoft.com/en-us/library/ms252093(VS.80).aspx

http://msdn.microsoft.com/en-us/library/ms159677.aspx

http://www.bigresource.com/MS_SQL-Databound-image-in-report-header-kJaJ0NnT.html

http://www.bigresource.com/Tracker/Track-ms_sql-kJaJ0NnT/