A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life.

Find ramblings

Friday, October 24, 2008

Unable to load client print control

Updated resolution at unable to load client print control (redux)

Wednesday, we started evaluating the upcoming patches from MS.  I say we but it's part of our DQA group that are the guinea pig^H^H^H^H testers for patches.  They opened a ticket on a project indicating the the printing from within SSRS was broken.  It generated a popup error
Windows Internet Explorer

Unable to load client print control.


Off to google I go and there are plenty of people suffering with the same issue after the patch. e.g. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=4006172&SiteID=1

That patch enables a killbit on the ActiveX control that handles printing from within SSRS. Even with patching SQL Servers, we were unable to get the thing to work. We'd end up with lots of entries in C:\Windows\Downloaded Program Files\ and CONFLICT folders within it but if you clicked Tools, Internet Options, Program tab, Advanced options (or something like that) you could see all the objects IE could load or currently had loaded. It just couldn't get the code to load into itself. We verified it was downloading from the server as expected but to no avail.

Best summary I can make is that the CU9 only touches the SQL Server stuff. The Report Viewer is something that doesn't count as part of that fix. You can test this by looking at the version in the GAC for Microsoft.ReportViewer.Webforms

Our eventual resolution boils down to
1) Install the .NET 3.5 runtime on the IIS servers

2) Download the Microsoft Report Viewer Redistributable 2008 and run the ReportViewer.exe on the server http://www.microsoft.com/downloads/details.aspx?familyid=CC96C246-61E5-4D9E-BB5F-416D75A1B9EF&displaylang=en

3) Update our web pages to use the version of the Microsoft.ReportViewer.WebForms

As a side note, they have an updated version of the 2005 track of the control ( but that does not appear to correct the issue. Microsoft Report Viewer Redistributable 2005 Service Pack 1, published 9/9/2008 http://www.microsoft.com/downloads/details.aspx?FamilyID=82833f27-081d-4b72-83ef-2836360a904d&DisplayLang=en

Hope this helps anyone who stumbles on this post.

Since this post seems to get plenty of hits, I thought I should update with the steps we finally went with (ran into this today with some unpatched servers)

1) Install hotfix 3282 for SQL Server Reporting Services 2005 KB953752 (Cumulative Update 9)
2) Install MS08-052 SQL Server GDI+ Update
3) Un-install ReportViewer 2005
4) Reboot---this is the key, must reboot before installing the new version
5) Install ReportViewer SP1 version 2.0.50727.1843

No comments: