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

IE “Unable To Load Client Print Control”

When running system reports in MarketingPilot and using IE7 or IE8 and you click on the print icon we were receiving an error saying “Unable to Load Client Print Control”.  If this happens to you, here’s how to solve the issue.  The issue is happening because of the  Microsoft Report Viewer 2008 that is installed on the Web Server.  To resolve the issue you will need to install the Microsoft Report Viewer 2008 SP1 Redistributable on the Web Server (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6).

Once the redistributable is loaded on the server, the user will need to reinstall the SQL Server driver.  To do this they will need to:

  • Go into MarketingPilot
  • Click Reports on the left navigation bar
  • Open a system report
  • Click the print icon
  • Install the ‘Microsoft SQL Server’ add-on (this will be in a yellow bar at the top of your browser window just below the address bar)  See Image 1 below
  • Go back into reports and open a system report
  • Click the print icon
  • Install the ‘Microsoft SQL Server’

Now you should be able to print custom reports.

Image 1

Image 2

 

Reporting Services 2008 – Troubleshooting Insufficient Permissions Granted

Description of issue:  When deploying a report, the deploy fails with the error: “The permissions granted to user <mydomain\myuser> are insufficient for performing this operation.”

Check the following

Check your report project’s properties window

  • TargetDataSourceFolder, TargetReportFolder and TargetServerURL must be filled.

You must have the proper permissions in the Report Manager

  • Run Internet Explorer (As an Administrator)
  • Add Report Manager base url (http://localhost/) to Trusted Sites Security, if necessary
  • Select the Properties tab
  • Select the New Role Assignment link
  • Enter your username
  • Select CONTENT MANAGER, then click OK
  • Click on Site Settings (in the upper right-hand corner)
  • Select Security (in the left border)
  • Select the New Role Assignment link
  • Enter your username
  • Select SYSTEM ADMINISTRATOR, then click OK

Reporting Services – Troubleshooting Report Viewer Rendering Issues in IIS7

Description of issue:  Report is not rendering in the application, or is rendering but the image buttons appear as a Red ‘X’ when viewing the report (see below): 

Internet Information Services (IIS) Handler Mappings does not contain Reserved.ReportViewerWebContro.axdhttpHandler and is unable to render the report viewer elements.

Check the following:

Open IIS7 and select your MarketingPilot WebServer application.

 1. Under IIS area, double-click on the Handler Mappings icon.

2.  At the Actions pane on the right, click on Add Managed Handler

3.  Enter the following information into the Add Managed Handler fields:

  • Request Path: Reserved.ReportViewerWebControl.axd
  • Type: Microsoft.Reporting.WebForms.HttpHandler
  • Name: Reserved-ReportViewerWebControl-axd

4.  Click OK.  Reserved-ReportViewerWebControl-axd handler is now added to your Handler Mappings list.  Run your report again.

Reporting Services – Troubleshooting NT Authority\Network Service access denied

Description: If the following message is received in MarketingPilot when running the report:

The permissions granted to user ‘NT AUTHORITY\NETWORK SERVICE’ are insufficient for performing this operation. (rsAccessDenied)

Or in Reporting Services:

screenshot

Check the following:

On the report server open the report manager:  http://localhost/reports

Once you open the report manager you need to add browser rights to the Users group:

  • Click on the Properties tab
  • Click New Role Assignment
  • Type in “Users” to the Group or user name field
  • Select Browser under Roles
  • Click OK

RS Role Assignment

You should end up with at least the following two Security Roles and you should be able to run the report successfully.

RS Role View