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.