On a computer that has Microsoft SQL Server 2005 Reporting Services installed, you install the cumulative security update for ActiveX that is described in the following knowledge base article:
956391
(http://support.microsoft.com/kb/956391/
)
Microsoft Security Advisory: Update Rollup for ActiveX Kill Bits
When you try to print a SQL Server 2005 Reporting Services report on a client computer, you receive the following error message:
Unable to load client print control
Additionally, this problem may affect any other application that uses the Report Viewer control, such as Microsoft Customer Relationship Manager (CRM) or a custom application developed in Microsoft Visual Studio.
This problem may also affect Report Viewer add-in (Web part) that is used for integration between Reporting Services and SharePoint.
For the printing functionality to work correctly, all relevant components must be updated. Most issues can be resolved by using the following procedure:
- Update the report server.
- Update the report viewer redistributable.
- Update the client that uses the ReportViewer control.
Therefore, to resolve this issue, follow these steps:
- Update the report server.
Make sure that the version of the report server is 9.00.3073 or 9.00.3282, or later versions. If the version is earlier than 9.00.3073, you must update the report server first.
To update report server, install Cumulative Update package 9 for SQL Server 2005 Service Pack 2 or later versions.
For more information about Cumulative Update package 9 for SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
953752
(http://support.microsoft.com/kb/953752/
)
Cumulative update package 9 for SQL Server 2005 Service Pack 2
- Update the report viewer redistributable
Check the version of the ReportViewer control. To do this, follow these steps:- On a client computer, open a report in Internet Explorer.
- Right-click the report, and then click View Source.
- Locate the line that resembles the following text:
<script src="/TestRSClientPrintReportViewer/Reserved.ReportViewerWebxxxx.axd?OpType=Resource&Version=x.y.zzzz
Note The placeholder xxxx represents the control type. - If the control type is Reserved.ReportViewerWebPart.axd, this is an issue in SharePoint. Therefore, you must install SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies from the following link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-b331-132274ae8c84&displaylang=en
(http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-b331-132274ae8c84&displaylang=en)
- If the control type is Reserved.ReportViewerWebControl.axd, you will find one of the following major versions:
If the version is 8.00.50727, you are browsing the report from CRM or by using the ReportViewer control in a custom SQL Server 2005-based Web application. If you see version 8.00.50727 and the version is earlier than 8.00.50727.1843, you should install Microsoft Report Viewer Redistributable 2005 Service Pack 1 from the following link on the report server or on the CRM server:
http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D&displaylang=en
(http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D&displaylang=en)
If the version is 9.00.XXXX or 9.0.XXXX, you are browsing the report from Report Manager, Report Server, or a custom Web application that was built by using Visual Studio 2008. In this case, you should install Microsoft Report Viewer 2008 SP1 Redistributable from the following link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&DisplayLang=en
(http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&DisplayLang=en)
After you install Microsoft Report Viewer 2008 SP1 Redistributable, the version of the ReportViewer control will be 9.0.30729.1.
After you update the ReportViewer control, you must run the iisreset command to reset the Internet Information Services service so that the updated controls will take effect. - Update the client that uses the report viewer control
- On the client computer, unregister the RSClientPrint.dll file that is located in the following folder:
C:\Windows\system32 - Delete the RSClientPrint.dll file and the RSClientPrint*.rll files from the folder.
- Open the C:\Windows\Downloaded Program Files folder, and then delete the RSClientPrint 2005 Class.
- Open the report, and then try to print the report.
- If you receive the following error message when you print the report, you must restart the computer.
An error occurred during printing (0x80070006)
- If you still receive this error message after you restart the computer, please perform these additional steps:
- Delete the RSClient 2005 Class in the C:\Windows\Downloaded Program Files folder.
- Open the following link:
http://www.microsoft.com/technet/security/bulletin/ms08-052.mspx
(http://www.microsoft.com/technet/security/bulletin/ms08-052.mspx)
- Click GDI+ BMP Integer Overflow Vulnerability - CVE-2008-3015.
- Click Workarounds for GDI+ BMP Integer Overflow Vulnerability - CVE-2008-3015.
- Follow the procedure that is described in the "How to undo the workaround" subsection.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
For more information, visit the following Web site:
http://blogs.msdn.com/brianhartman/archive/2008/11/05/client-print-fails-to-load-after-microsoft-update-956391.aspx
(http://blogs.msdn.com/brianhartman/archive/2008/11/05/client-print-fails-to-load-after-microsoft-update-956391.aspx)