Reporting Services – Custom report error (Error while loading code module: MarketingPilot.Framework.dll)

When uploading a custom report (mainly financial reports such as invoices and PO’s) that uses currency, you may find yourself facing an issue trying to deploy your reports. You may see the following error message:
The resolution to this issue is explained below, but please note, you will need to get a copy of the correct MarketingPilot.Framework.dll file from MarketingPilot Support because it must be a version that doesn’t use .NET 4.0.

Procedure to Deploy Report Dependencies to Reporting Service

Fixing Visual Studio Compilation errors
Locate the a version of the MarketingPilot.Framework.dll that IS NOT using .NET 4.0 (example: MarketingPilot\Web Server\bin)

To fix Visual Studio 2005, copy this DLL to C:\Program Files\Microsoft Visual Studio 8.0\Common7\IDE\PrivateAssemblies **(C:\Program Files (x86) if you are using a 64 bit machine)

To fix Visual Studio 2008, copy this DLL to C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies **(C:\Program Files (x86) if you are using a 64 bit machine)

Fixing Reporting Services dependency errors
Copy that the same MarketingPilot.Framework.dll in step one to your Reporting Services’ ReportServer bin folder (example: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin)
Note: The MSSQL.3 part may be different depending on your Reporting Services installation. **(For SQL Express: MSRS10.SQLEXPRESS, for SQL 2008 R2: MSRS10_50.MSSQLSERVER)

**NOTE: Be sure to use the same version of the MarketingPilot.Framework.dll in both locations.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s