"Unable to load client print control" error in Reporting Services 2005 after installing KB 956391
You might receive the following error when trying to print a report in Reporting Services after the installation of KB 956391 on the client machines:
Microsoft Security Advisory: Cumulative security update for ActiveX
http://support.microsoft.com/?id=956391
Unable to load client print control
This update “killbits” an older version of the RSClientPrint, due a vulnerability in it. But, for this update to work the report server must have been patched as well and perhaps also the ReportViewer control has to be updated. You should leave KB956391 installed on the client machines and then check for scenarios listed below.
RESOLUTION:
In order to solve the problem in the Report Manager (http://machinename/repors) you would have to install the latest Cumulative Update (for example Cumulative Update 10) of SQL Server. You can get it from the following link:
Cumulative update package 10 for SQL Server 2005 Service Pack 2
http://support.microsoft.com/kb/956854/en-us
If you use the report viewer control from a web application, CRM or Sharepoint, you should follow the steps bellow:
Check the version of the ReportViewer control.
1. Open a report for viewing on a client machine
2. Then right click on the report and select “View Source”.
Locate the line that looks like this:
<script src="http://blogs.msdn.com/TestRSClientPrintReportViewer/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=X.Y.ZZZZ
Now, if the control type is “Reserved.ReportViewerWebPart.axd” then this is an issue with SharePoint.
The “Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies” has been updated to work with the new rsclientprint.dll.
Download center link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-b331-132274ae8c84&displaylang=en
If the control type is “Reserved.ReportViewerWebControl.axd” we should check the following:
We have 2 different major versions here: 8.00.50727 and 9.00.XXXX.
If you see version 8.00.50727 this means you are browsing reports from within CRM or using the ReportViewer control in a custom 2005 web application.
If you see version 8.00.50727 and the version is earlier than 8.00.50727.1843 then you should install Report Viewer Redistributable 2005 Service Pack 1 on the ReportServer or on the CRM server or machine where the web application is running:
Microsoft Report Viewer Redistributable 2005 Service Pack 1
http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D&displaylang=en
If you see version 9.00.XXXX or 9.0.XXXX then you are browsing through Report Manager, Report Server or perhaps a custom web application built with VS 2008.
Then you should install the below on the report server and in the machine where the web application is running:
Microsoft Report Viewer 2008 SP1 Redistributable
http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&DisplayLang=en
This will bring you up to version 9.0.30729.1 for the ReportViewer control.
After having updated the ReportViewer control you must issue an iisreset command so that the updated controls will take effect.
For Reporting Services 2000
You should install the following security update in the server
Security Update for SQL Server Reporting Services 2000 Service Pack 2
http://www.microsoft.com/downloads/details.aspx?familyid=5F9E7F78-7439-414B-A9DC-A779B89427DB&displaylang=en
And the following versión of the Report Viewer redistributable in the Web application machine (or CRM machine):
Microsoft Report Viewer Redistributable 2005 Service Pack 1
http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D
Make sure that the following security update installed in all machines:
Microsoft Security Advisory: Update Rollup for ActiveX Kill Bits
http://support.microsoft.com/kb/956391
I still get the error even if I performed all the steps above
If you have followed the steps above and you still get the error when printing the report from your application, it could be possible that the version of the rsClientPrint control in your client machine is different to the version in the server.
A good test would be to delete the rsClientPrint control from the client machine and allow it to download it again from the server. This happens automatically when you print a report for the first time. Note: The users will need to have permissions to download ActiveX controls though IE.
Steps:
1. Unregister RSClientPrint.dll in c:\windows\system32 folder.
2. Delete all RSClientPrint.dll and RSClientPrint*.rll files from
c:\windows\system32 folder.
3. Go to Windows\Downloaded Program Files and delete the RSClientPrint 2005
Class
4. Set the IE Intranet setting to prompt for ActiveX downloads
5. Run the Report.
6. Install the SQL Server ActiveX plugging when prompted.
7. Check the Downloaded Program Files through explorer and command prompt.
8. It should say RSClient 2005 Class.
You can check the version of the rsClientPrint control in the following way:
· Open command prompt
· Navigate to c:\windows\downloaded program files
· Copy rsclientprint.dll in your temp folder e.g. c:\temp
· Open Windows Explorer
· Navigate to your temp folder
· In the context menu check the version, should be 2000.80.1038.0
· Delete RSClientPrint.dll in the temp folder
· Switch back to the command prompt
· Navigate to 'CONFLICT.1'
· Copy RSClientPrint.dll in the temp folder
· Switch to the Windows Explorer
· Check the version in the context menu, should be 2005.90.3282.0
Maria Esteban
Reporting Services Support Engineer
