Unable to load client print control
When you display a SQL Reporting Services report to the screen in the header there is a Printer Icon displayed. When we click this icon we get an error message "Unable to load client print control ".
Does anyone know what we need to load or what we need to do to resolve this so that we can print the report directly to teh printer, rather than having ot prinnt the web page, which also prints all the Web headre information
April 4th, 2006 10:40am
The Client Print Control is an Active X object. You need to be able to download and install the control. In Internet Explorer\Tools\Internet Options\Security\Custom Level you can find the settings to allow downloading of Active X controls.
Free Windows Admin Tool Kit Click here and download it now
April 4th, 2006 6:59pm
We are facing the same problem. Advising the clients who use our web application to weaken thesecurity of their Internet Explorer is not really an option. Can the ActiveX control be downloaded separately?
Kind regards,
Martijn Bakker
April 18th, 2006 11:43am
I'm having the same problem as described above. What is the solution?
Free Windows Admin Tool Kit Click here and download it now
May 5th, 2006 7:32pm
I would like to throw one other issue we have found with the print control. If a user has previously installed the RS 2000 print control, and tries to print a report in 2005 it will error out. You have to manually remove the old activeX control from the users PC (C:\WINDOWS\Downloaded Program Files) and rerun the report to get the new control. Also, the 2005 from our experience doesn't seem to work with 2000 either.
May 5th, 2006 7:40pm
The SQL 2005 SP1 version of the control has been updated to better handle the versioning of the print control so that you will not have to uninstall and install the control between SQL2000\SQL2005 RTM\SQL2005 SP1
In regards to Active X controls, my understanding is you can install the control via SMS using the RSClientPrint.cab file that comes with the RS installation. The user will stillrequire the permission to run Active X controls.
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2006 12:23am
What is the process to install the ActiveX if we don't have SMS?
September 12th, 2006 10:37pm
It is automatically installed when you click the print button when viewing a report.
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2006 9:16pm
Of course we know it's supposed to but we also know that things don't always work as they're supposed to. In my case, I have at least one system where it doesn't download automatically.I've seen postings where others mention installing the AcitiveX manually. I'm looking for details on how that is done. I can see the .cab file on the report server but need to know what to do to get it installed on the client.Any help is of course appreciated.Jon
September 15th, 2006 5:20am
I get the same message and it does not install. I tried setting IE to prompt for signed or unsigned ActiveX controls but it still doesn't work. But this machine is weird - it won't take Windows Updates either, I have to install them while shutting the machine down. Still, I'd like a way to install that control manually.
Free Windows Admin Tool Kit Click here and download it now
September 20th, 2006 6:37pm
To manually install the .CAB file:
1. Download the .cab file and save it on your desktop. 2. After the file is saved on your desktop, right-click the Iuctl.cab file, and then click Open 3. Select all the files that are listed. To do this, point to the file list, and then press CTRL+A. 4. Right-click the files that you selected, and then click Extract. 5. Select a known location, and then click OK. For example, select the desktop. 6. Locate the file where you extracted it. For example, locate the file on the desktop. 7. Right-click the RSClientPrint.inf file, and then click Install.
October 11th, 2006 2:19am
I just tried that. I found the cab somewhere under programs/Microsoft sql server. But when I extracted it and tried Install, it just blinked. In trying to print from RS I got the usual Unable to load Client Print Control.
But, as I know, this machine is a bit weird about activex controls so I'm not taking it personally.
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2006 7:01pm
In a perfect world yes the ActiveX Print Control for Reporting Services will be installed on the client's machine. However in an environment such as the one I manage our Desktop Users DO NOT have Local Administrator rights and the ActiveX Installation fails and "Unable to load client print control" is displayed on their screens.
Besides SMS is there any other option to silently install the the ActiveX Print Control on the PCs for users without admin rights?
October 16th, 2006 11:26pm
The SSRS activeX control is no different then any other web AX control. You will always need admin rights to install it.
If you are in a controlled environment (like a Gov't one), then there is usually a method whereby the admins push out updates to the users.
You could always use the cab file and create an install program in .Net and have them push it out.
Other then that, you are kinda s.o.l.
If your computer won't take MS updates then installing an AX control is the least of your worries, and once you fix the first problem, the second should fix itself.
Daryl
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2006 11:39pm
I am still operating under SQL Server 2000. I couldn't find RSClientPrint.cab in the Microsoft SQL Server folder.
Will I be able to print this report without upgrading to 2005? I need this report before the time it would take to implement an upgrade.
Thanks.
February 7th, 2007 10:59pm
Hi
Regarding the load client print control
How to programatically set the securtiy option with out manually setting the option for downloading the Active X controls.
Because i cannot see whether the option is set or not.If the option is not set then i will get the error..
thanks in advance
Free Windows Admin Tool Kit Click here and download it now
August 17th, 2007 2:35pm
I work in an environment where the users don't have Admin Rights so they can't install the required Active X control. Here is a great article on pushing it out to the users.
http://www.kodyaz.com/articles/client-side-printing-silent-deployment-of-rsclientPrint.aspx
September 27th, 2007 4:59am
Run IE as an administrator and go to the link the user is attempting to print from. It then should prompt for an active X install and just right click and following the directions. I actually just performed this on a workstation and it worked.
Free Windows Admin Tool Kit Click here and download it now
September 9th, 2008 12:37am
Is there any other way Instead of running .Cab and Admin rights.
I am planning to execute at the End User.
Thanks,
Prabu
October 9th, 2008 5:52pm
A lot of our users just now started complaining of this issue...it appears it may be related to a windows update of some sort. Earlier today I was prompted to install the activex control, but after installing the latest windows updates I don't get the prompt anymore, only the message box stating "Unable to load client print controls". Anyone else noticing this problem?
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2008 1:43am
You may want to check out this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=4006172&SiteID=1
Alex.
October 16th, 2008 2:13am
Just now got off the call with Microsoft personnel. we tried several combinations but the one that finally worked is just installing the Cumulative Update 9 for SQL Server 2005 on the server machine. Once this is done all the clients that try to print will be prompted to install the new Active X control and then print is working fine.
While uninstalling the patch KB956390 also works the above solution is better as it has to be done only at the server.
Hope this helps all who are facing this issue.
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2008 9:52pm
We have the problem as well, only it just started happening. The same users/computers/browsers that could print last week now can't all of a sudden. The report we're trying to print is only a single page.
Regards,
Joel
October 17th, 2008 8:54pm
I am using SQL Server 2005 SP1/ Windows 2003 Server Ent.
Is there anyway to get the print button to work? For people who are local admin and for those who are not?
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2008 6:41pm
You canremove the two new updates Microsoft released yesterday.Go to Control Panel, Add/Remove Programs. Check the Show Updates box. Locate the Security Updates KB956803 and KB956391, and remove one at a time. After the removal you will have to restart the computer. You should be able to print.
Windows XP
Security Update for Windows XP (KB956803)
Thursday, October 16, 2008
Automatic Updates
Windows XP
Cumulative Security Update for ActiveX Killbits for Windows XP (KB956391)
Thursday, October 16, 2008
Automatic Updates
October 20th, 2008 7:46pm
Hi Ryan,
You can install the server GDR patch for Reporting Services SP1. If you run Microsoft Update(not Windows Update) on your server, the patch should be in the list of patches to install. Once you have that patch installed, your clients should be able to print again. If not, please ping me at bradsy@removememicrosoft.com.
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2008 9:26pm
Hi Brad,
Do you have a link for that patch? I'm having problems locating it.
Thanks,
Joe
October 20th, 2008 10:22pm
Brad, I am having the same problem as of last week this broke for my custom asp.net web app. I have tried the updates on the server along with all the other sugestions without luck.
I am using the 2008 Report viewer running in local report mode only.
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2008 4:32am
I take back my last post, the server update did fix the problem, I had to manually restart the SQL server service. I couldnt do it right away as this was a production box. thanks.
October 21st, 2008 5:55am
I work with Ryan and I'll add to his post. Our installation has been up and running for several months in production, but people have only recently needed to try to print any of the reports and they are getting errors because they cannot because they are being prompted to install an AX control. Based on everything I have read in this thread so far, our issue is not with the server, but is related to security policies within the user's browser.Without going in to the layers of our organization and the multiple security policies in our environment, let me sum up and say that handing out Local Admin isn't an acceptable option. We may be able to distribute the .cab file for local installation, although it is not clear from this thread if that will solve the problem. Alternatively, we may be able to add the site to a trusted zone that is configured to execute AX controls.Are there any other options for being able to use this feature?Thanks,David Modlin
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2008 12:50am
So I applied all updates available today and then rebooted both the SQL and Terminal Server.
On the Terminal Server (2003 Server) that I'm getting the Error.
I've Logged in as a Domain & Local Admin and tried to view the report and I also get the Error.
If I do it on my local machine (Vista x64), I get Prompted to install the Active-X Control and all is good in the World
I've made sure that the all the Active-X Related Security settings were enabled. (IE Complained I was 'at risk')
Its a Production system, so I can't just install/remove patches on the two servers and reboot them.
I've also copied the RSClientPrint.cab file to the Terminal Server, then extracted it to a folder and right clicked on the .inf and did the Install. Nothing changed.
I removed the update KB956390, though have not been able to reboot yet.
Any other Suggestions?
October 22nd, 2008 7:49pm
thank you so much...this actually worked for me as those updates were part of XP SP3 which I happened to install...you are the man!!
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2008 9:37pm
Yes, I am getting the same problem, I am not getting the prompt anymore for "install active X control". Please help if any body knows the solution. I am unable to print from Report Manager. getting the same error "unable to load client print control"
Thanks in advance
bsembhi@gmail.com
October 24th, 2008 5:52pm
All I did was apply all outstanding Hotfixes for my SQL server box, that resolved the issue. You do need to restart the services if you dont reboot. I didnt have much faith that it would resolve the problem but it did fix it.
Free Windows Admin Tool Kit Click here and download it now
October 24th, 2008 5:58pm
While we had applied CU9 to our servers, it still didn't help. What finally worked for us was to 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 and then update our web pages to use the 9.0.0.0 version of the webform. Users are then either prompted or not based on the security settings but we were just happy to get it to "take" the updated version of the print control. http://billfellows.blogspot.com/2008/10/unable-to-load-client-print-control.html
October 25th, 2008 7:08am
I faced this same issue which coincided with the Automatic Update installation of Security Update KB956351 for Windows XP.I opened a case with Microsoft Support and this is the solution provided that worked for me-You can either uninstall this update, which should fix this issue, or apply a few patches for SSRS 2005 SP2.You may need to delete the RSClient Print Control which is typically in C:\WINDOWS\Downloaded Program Files\.I installed Cumulative Update 10 for SQL Server 2005 SP2 as well as the GDR fixed version of the ReportViewer control. After that you may need to restart services or reboot. You can get the fix for the version of the control being used from the links below.
ReportViewer 2005 SP1:
http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D
Free Windows Admin Tool Kit Click here and download it now
October 25th, 2008 10:22pm
We have released an updated SharePoint add-in that addresses the client print problem for English customers. We are providing English immediately and are working to release all localizations of the SharePoint Add-in as soon as possible.
Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies Download Page:
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-b331-132274ae8c84&displaylang=en
To use this version of the Reporting Services Add-in, the SQL Server Reporting Services server deployment used in conjunction with the Reporting Services Add-in must be patched with the updates listed under Microsoft SQL Server in Microsoft Security Bulletin MS08-052.
Thanks,
-Lukasz
lukaszp@removemeMicrosoft.com
October 27th, 2008 8:16am
Do I do this on the server or each client machine?
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2008 6:32pm
My clients are able to use the print icon now by removing the updates you have suggested to remove. Thank you.
October 28th, 2008 11:43pm
stevejonesforrent wrote:
I faced this same issue which coincided with the Automatic Update installation of Security Update KB956351 for Windows XP.I opened a case with Microsoft Support and this is the solution provided that worked for me-You can either uninstall this update, which should fix this issue, or apply a few patches for SSRS 2005 SP2.You may need to delete the RSClient Print Control which is typically in C:\WINDOWS\Downloaded Program Files\.I installed Cumulative Update 10 for SQL Server 2005 SP2 as well as the GDR fixed version of the ReportViewer control. After that you may need to restart services or reboot. You can get the fix for the version of the control being used from the links below.
ReportViewer 2005 SP1:
http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D
Was this installed on the Report Server or the local machine having the problem?
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2008 1:37am
stevejonesforrent wrote:
I faced this same issue which coincided with the Automatic Update installation of Security Update KB956351 for Windows XP.I opened a case with Microsoft Support and this is the solution provided that worked for me-You can either uninstall this update, which should fix this issue, or apply a few patches for SSRS 2005 SP2.You may need to delete the RSClient Print Control which is typically in C:\WINDOWS\Downloaded Program Files\.I installed Cumulative Update 10 for SQL Server 2005 SP2 as well as the GDR fixed version of the ReportViewer control. After that you may need to restart services or reboot. You can get the fix for the version of the control being used from the links below.
ReportViewer 2005 SP1:
http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D
Was this installed on the Report Server or the local machine having the problem?
October 29th, 2008 1:37am
Web Server is patchedup to date Client machine is patchedup to date Sql server is patched up to date. Sql server 2005 is patched up to date. ReportingServicesWebUserInterface.dll is version 9.0.3073.0 Microsoft.ReportingServices.Diagnostics.dll is version 9.0.3073.0 On web control, register of viewer is <%@ Register TagPrefix="rsweb" Namespace="Microsoft.Reporting.WebForms" Assembly="ReportingServicesWebUserInterface" %> In web.config httphandler is <add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/> webapp compiles without error but when I try to set parameters like rvPrintRequestClientReport.LocalReport.ReportPath "mypath\myReport.rdlc" app fails with "The method or operation is not implemented"
I would like to use this viewer in the future without the following hacks to fix issue:
Registry hack - If you change the "Compatibility Flags" value to 0, the error goes away. [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{FA91DF8D-53AB-455D-AB20-F2F023E498D3}] "Compatibility Flags"=dword:0x00000000 (0) "AlternateCLSID"="{41861299-EAB2-4DCC-986C-802AE12AC499}"
Removal of two security updates that cause the issue KB956391, KB954593
How do I update my dev box/reference the new control?
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2008 4:12pm
Hi,
I tried the fix.I installed the (KB954765) and Reome the RSClient Print Control from C:\WINDOWS\Downloaded Program Files\.
Still it is not working andf I have the User who is not having rights in C:.My End user is unable to save/run any programwhich affect C:.
How can I resolve this.
Thanks,
Prabu
October 29th, 2008 5:09pm
Removing the update KB956803 solved the issue for us, thanks!!
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2008 8:00pm
I need to update my blog with how we finally corrected it using the 8.0.0.0 version of the report view control but it boiled down to performing the following steps on the IIS/reporting server box
1) Install CU 9
2)Uninstall the existing ReportViewer.exe
3) REBOOT (missed this one)
4) Install the service packed, hotfixed version of the ReportViewer 2005 (http://www.microsoft.com/downloads/details.aspx?FamilyID=82833f27-081d-4b72-83ef-2836360a904d&DisplayLang=en)
Doing the above steps has allowed our users to have the infamous killbit KB applied and still print from embeded reports.
October 30th, 2008 4:59pm
Removing update KB956391 fixed the problem here.
Thx a lot
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2008 12:21pm
Hi All,I came across this error in our network last week and managed to sort it out by uninstalling the following two updates from Microsoft.
KB954606
KB956391Hope this helps.Thanks,Aash.
November 3rd, 2008 2:23pm
We were also experiencing this issue with our users. In a test box, I removed the following registry key (backed it up first of course):
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{FA91DF8D-53AB-455D-AB20-F2F023E498D3}] "Compatibility Flags"=dword:0x00000000 (0)
The problem is that this would have to be done on the client PCs. Our temporary fix is have the LAN team manually install the ReportViewer.exe when users call in.
Thanks,
Nuno
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2008 7:27pm
Anyone has any progress on this case? So far the temporary solution is uninstalling the specified KB...
November 7th, 2008 12:23am
We have managed to keep the KB and have the print control work.
We applied the following steps on our reporting server
1) Install CU 9
2)Uninstall the existing ReportViewer.exe
3) REBOOT (missed this one)
4) Install the service packed, hotfixed version of the ReportViewer 2005 (http://www.microsoft.com/downloads/details.aspx?FamilyID=82833f27-081d-4b72-83ef-2836360a904d&DisplayLang=en)
Free Windows Admin Tool Kit Click here and download it now
November 7th, 2008 12:30am
Charles Talleyrand wrote:
4) Install the service packed, hotfixed version of the ReportViewer 2005 (http://www.microsoft.com/downloads/details.aspx?FamilyID=82833f27-081d-4b72-83ef-2836360a904d&DisplayLang=en)
Noteto Step 4, you may need the ReportViewer 2005 SP1 and/or ReportViewer 2008 SP1hotfix depending .Iapplied the Microsoft Report Viewer Redistributable 2005 Service Pack 1 yesterday and today discoveredan "Unable to load client print control" error on a recently deplyed 2008/.net 3.5 site while an older .Net 2.0 report viewer running correctly.Applying both patches fixed all print popup issues.
4a) Microsoft Report Viewer Redistributable 2005 Service Pack 1
verify version by checking the source html of a test report andsee if it contains
"/Reserved.ReportViewerWebControl.axd" and "Version=8.0.XXXXX"
http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D&displaylang=en
4b) Microsoft Report Viewer 2008 SP1 Redistributable
verify version by checking the source html of a test report andsee if it contains
"Reserved.ReportViewerWebControl.axd?"and "Version=9.0.XXXXX"
http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&DisplayLang=en
5) restart IIS (iisreset) or server
As Charles mentions, this fixes the "Unable to load client print control" issue without removing the KB patch ormodifying the client registry.
Additional info gathered here, Rahul's comment:
http://www.technologystudio.net/blog/post/Microsoft-Update-KB956391-breaks-Reporting-Services-ReportViewer.aspx
November 7th, 2008 10:19am
Hi everything worked great on mydevelopment box(32 bit(, now I am able to use print button, but when I try to update the 64 bit production servers, I still see this problem, is there anything that I am missing?
Erinc
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2008 1:18am
Thank you, it worked just fine!
December 17th, 2008 12:14am
Charles Talleyrand said:We have managed to keep the KB and have the print control work.
We applied the following steps on our reporting server
1) Install CU 9
2)Uninstall the existing ReportViewer.exe
3) REBOOT (missed this one)
4) Install the service packed, hotfixed version of the ReportViewer 2005 (http://www.microsoft.com/downloads/details.aspx?FamilyID=82833f27-081d-4b72-83ef-2836360a904d&DisplayLang=en)Panod Klongtruatroke said:
Charles Talleyrand wrote:
4) Install the service packed, hotfixed version of the ReportViewer 2005 (http://www.microsoft.com/downloads/details.aspx?FamilyID=82833f27-081d-4b72-83ef-2836360a904d&DisplayLang=en)
Noteto Step 4, you may need the ReportViewer 2005 SP1 and/or ReportViewer 2008 SP1hotfix depending .Iapplied the Microsoft Report Viewer Redistributable 2005 Service Pack 1 yesterday and today discoveredan "Unable to load client print control" error on a recently deplyed 2008/.net 3.5 site while an older .Net 2.0 report viewer running correctly.Applying both patches fixed all print popup issues.
4a) Microsoft Report Viewer Redistributable 2005 Service Pack 1
verify version by checking the source html of a test report andsee if it contains
"/Reserved.ReportViewerWebControl.axd" and "Version=8.0.XXXXX"
http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D&displaylang=en
4b) Microsoft Report Viewer 2008 SP1 Redistributable
verify version by checking the source html of a test report andsee if it contains
"Reserved.ReportViewerWebControl.axd?"and "Version=9.0.XXXXX"
http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&DisplayLang=en
5) restart IIS (iisreset) or server
As Charles mentions, this fixes the "Unable to load client print control" issue without removing the KB patch ormodifying the client registry.
Additional info gathered here, Rahul's comment:
http://www.technologystudio.net/blog/post/Microsoft-Update-KB956391-breaks-Reporting-Services-ReportViewer.aspx
Thank you both for your posts!! I was having a LOT of trouble with this problem of users receiving the error "Unable to load client print control" and originally fixed by uninstalling windows update KB956391. I was able to use this solution because only a few users used the report server. Then the error came back, and I solved it on a few computers by uninstalling KB960715, but it did not fix it on all workstations. Then, we needed to release a new report to ALL of our users, so I needed to find a solution fast! It would have been an extremely tedious task to try and find the windows updates that were causing the problem on every user's computer, uninstall them, and then hide them from automatically installing again.Well thanks to you guys, I got it working by installing a couple patches ONLY on the Report Server! I followed Charles' instructions of installing SQL 2005 Cumulative Update 9 from here . Then I downloaded the 2008 Report Viewer Redistributable. After uninstalling the 2005 Report Viewer Redist. from the Report Server, installing the Cumulative Update 9 on the Report Server, and installing Report Viewer 2008 Redist. on the Report Server, it is working on all workstations, even after I reinstalled KB956391 AND KB960715!Thanks a lot for the help!
Free Windows Admin Tool Kit Click here and download it now
February 20th, 2009 6:19pm
Thanks. by removing those two updates and having rebooted now it prompts for installing AX controll.then once i clilck on print icon it comes up with Unable to load client print controlnext i will be checking log to find if AX installed properly.cheers
March 16th, 2009 3:33am
I have had the same problem (on several different servers). Applying SP3 and Report Viewer SP1 has helped on some of the servers, allowing the client machines to connect and download the control with no problem.However, I have had one server that, even after applying the updates, when accessing the report viewer using a client machine, it was still giving me the error.On looking into the exact URL GET request that is being sent, I discovered that it is possible to force the client machine to connect directly to the Report Server to download the control.The user would need to enter the following url:http://reportservername/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=51bjqv45xydgos2wghu5ceza&ControlID=7617dedbf0234f89b80cad8e64431014&Culture=2057&UICulture=9&ReportStack=1&OpType=PrintHtmlThis should then pop up the required download/install prompt.Please can people let me know if this works on their systems as well
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2009 11:50am
Did You get a message warning you that other programs might not work if you remove that hotfix? I got this looooong message about all the stuff that could break if I uninstalled the hotfix.DJ Baby Anne's Biggest Fan................
April 29th, 2009 6:49pm
I tried to follow Paul_IRET's steps. But for step 2, how to uninstall the existing reportviewer.exe ?
Free Windows Admin Tool Kit Click here and download it now
May 7th, 2009 12:29pm
You can extract the cab file and save it to a network share then run a .bat file on all workstations (via startup script) to copy extracted files to system32 and regiter rsclient print with registryhere is an example startup script@echo off
rem #############################################################rem Intall ActiveX to print from reporting service - rem Copy active x files to target machine's system32rem register with registryrem ##############################################################
xcopy "\\replacewithservershare\gdiplus.dll" "C:\WINDOWS\system32\*.*" /yxcopy "\\replacewithservershare\RSClientPrint.dll" "C:\WINDOWS\system32\*.*" /yxcopy "\\replacewithservershare\RSClientPrint.inf" "C:\WINDOWS\system32\*.*" /yrem you get the picture - rest of the extracted filesrem register with osregsvr32.exe /s c:\windows\system32\rsclientprint.dll
this methode install and regiter rsclient print even before user log on hence doesnt matter who logs in. catch is you will have to run it for a week or so and stop the startup script
May 14th, 2009 8:27am
Good 'ol login script.......I've been doing database and application stuff too long.............Thx Emil..DJ Baby Anne's Biggest Fan................
Free Windows Admin Tool Kit Click here and download it now
May 14th, 2009 10:50pm
We arehaving the same issue about loading the print control on user machines andwe would like apply CU9 on the server where SSRS is installed. Butwe are little confused. Do we need to run all the 5 files in the CU 9 download or just first 4.SQLNCLI SQLServer2005_ADOMD SQLServer2005_ASOLEDB9 SQLServer2005_XMO Yukon_SP2_CU9Please help.Thank you.madduri
June 29th, 2009 7:54pm
I work in an environment where the users don't have Admin Rights so they can't install the required Active X control. Here is a great article on pushing it out to the users.
http://www.kodyaz.com/articles/client-side-printing-silent-deployment-of-rsclientPrint.aspx
This is a right answer for me.support and search
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2009 12:18am
Very useful forum. -Bob http://www.crossloop.com/BobHartung
August 15th, 2009 6:42am
Question:I have the same problem as everyone else, but I am a local admin on my machine and even if I put all activeX to promt I don't get a promt before the error message "Unable to load client print control" fires.The other part of my problem is that I do this on my developer machine where I have app-server, sql-server and web-server locally.I start IE and start my local application.Then it works fine, I can print without problems.THEN, when I use my developer machine against the test server where the application- and web-server resides, the sql server is a separate server in this case. Then it fires the error message "Unable to load client print control". I find this a bit strange.I use the IE on my local machine and use the url of my test server.Should not the activeX have been installed when I run locally ?? If it is the ActiveX why does it try to install it again, unless it is another version which I'm pretty sure it isn't.I can't figure out why I get this problem. Can anyone offer some help or advice here ?
Free Windows Admin Tool Kit Click here and download it now
August 19th, 2009 4:55pm
Question:I have the same problem as everyone else, but I am a local admin on my machine and even if I put all activeX to promt I don't get a promt before the error message "Unable to load client print control" fires.The other part of my problem is that I do this on my developer machine where I have app-server, sql-server and web-server locally.I start IE and start my local application.Then it works fine, I can print without problems.THEN, when I use my developer machine against the test server where the application- and web-server resides, the sql server is a separate server in this case. Then it fires the error message "Unable to load client print control". I find this a bit strange.I use the IE on my local machine and use the url of my test server.Should not the activeX have been installed when I run locally ?? If it is the ActiveX why does it try to install it again, unless it is another version which I'm pretty sure it isn't.I can't figure out why I get this problem. Can anyone offer some help or advice here ?
We are experiencing the very same problem. We can print the report from the web page where the SSRS report viewer control lives, fine, ifI'm running it againstmy local IIS. However, if I then copy the websiteto our Windows Server 2003 R2 environment, run the ASP.NET app from the server, view the report (just fine, thank you) but then try to print the report I get this "Unable to load clinet print control" error. The only difference is where I'm running the ASP.NET app from, because it is the same app, since I just copied it from my development machine to the server. Because I'm running it on my machine, and I've got administrative privileges on my machine and on our network, I don't believe that is the issue.I'm using VS 2008.Rod
August 27th, 2009 10:54pm
Hi Aash2,
Hi All,
I came across this error in our network last week and managed to sort it out by uninstalling the following two updates from Microsoft.
KB954606
KB956391
Hope this helps
Do we need remove these updates from the server where Reporting services has installed or each individual user's machine?? We have SQL Server 2005 x64 with SP3 thanks
Free Windows Admin Tool Kit Click here and download it now
September 24th, 2009 2:51am
Any help plz..
October 2nd, 2009 1:48am
Got this silly problem again on a newly built server. Unfortunately removing mentioned two updates didnt fix this time, What I followed this time was 1) removed both updates 2)removed report viewer(i have app and db on seperate servers and i removed it from both servers) 3)reboot - important (first attempt without reboot did not work) 4)installed Microsoft Report Viewer 2008 SP1 Redistribution on both servers follow above steps to figure out the version of RV you are serving to clients. once tested report viewer and print dialogue box prompt, installed updates removed previously. Print control continue to work. thanks Emil
Free Windows Admin Tool Kit Click here and download it now
October 30th, 2009 11:32am
All,There seems to be various solutions and it seems issue is still prevalent. In my case, we followed RSClientPrint.dll installation on users system. We have a distributed set-up and have a seperate Reporting server. Can anyone confirm if removing the updates and installing Microsoft Report Viewer 2008 SP1 Redistribution on Reporting server will work? It is URGENT and need your support.ThanksThanks
November 10th, 2009 9:02am
Yes, can confirm below steps did resolve the issue this time...funny enoughI have had three times the same problem and three diffrent solutions, all in this thread, that isproven to be working .1) removed both updates2)removed report viewer(i have app and db on seperate servers and i removed it from both servers)3)reboot - important (first attempt without reboot did not work)4)installed Microsoft Report Viewer 2008 SP1 Redistribution on both servers
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2009 9:16am
Dear Emil, Thanks for quick response. I didn't have the following patches on the system:
KB954606KB956391
So, I jumped to http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D&displaylang=enand installed Microsoft Report Viewer 2008 SP1 Redistribution.Now I can see a small change. It is now prompting to install ActiveX. When I click on Install nothing happens and after 2-3 sec, I get the same message "Unable to load client Print control"Please helpThanks
November 10th, 2009 12:05pm
Do not remove any kill bits.Just install the Microsoft Report Viewer 2008 SP1 Redistribution on your application server (NOT the report server or NOT the SQL Server) and make sure you have SQL Server 2005 SP3 applied.
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2009 3:07am
Do not remove any kill bits.Just install the Microsoft Report Viewer 2008 SP1 Redistribution on your application server (NOT the report server or NOT the SQL Server) and make sure you have SQL Server 2005 SP3 applied.
Samnalla, after you installed Microsoft Reportviewer 2008 SP1 redistribution on the application server....did your clients still get prompted to install the Active X Control? or does the Active X control get installed automatically? even if the users are not local admin to their computers?I need a solution that doesn't require the users to install anything (as they are not administrators).... or my techs to push any file to the client machines and register dlls.... or my techs to change any registry keys or unistall anything...Anybody else has solved this problem just at the server level? maybe modifying the applications? My apps are Framework 2.0... My sql server is 2005 SP3. My Report viewer has the 2005 SP1 redistributable patch.anyone?
November 20th, 2009 12:16am
Charles Talleyrand,Perfect, but are your users till being prompted to Install the Active X? or they don't have to install anything? are your users local admins?Thanks
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2009 9:37pm
Awesome. Thanks Panod....but are your users being prompted to install the Active X control? or they don't have to install anything anymore? are they local admins?Thanks
November 20th, 2009 9:40pm
Awesome. Thanks Paul_Iret....but are your users being prompted to install the Active X control? or they don't have to install anything anymore? are they local admins?Thanks
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2009 9:45pm
Samnalla is right, it's not a good idea to remove any killbits patches.For those of you that only have SQL Server 2005 SP2 applied on your report server, make sure you apply KB970895 or KB970896 (see http://www.microsoft.com/technet/security/bulletin/MS09-062.mspxfor appropriate version.)Then install Microsoft Report Viewer 2008or ReportViewer 2008 SP1on your application server.
December 14th, 2009 5:13pm
hi HandyManny, In our organization, the users are Administrators to their workstations. So they did not prompt to install the Active X control? or they don't have to install anything anymore. It's just opens the print thanks
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2009 2:08am
Hi all, we are having similar problem receiving the 'unable to load client print controls' msg.
we upgraded ie from version 6 to version 8 and now receive the above msg when trying to report from reporting services. Uninstalling IE 8 and re installing IE 6 and we still get the unable to print msg when tring to print from reporting services.
workstation os is xp
server is win 2003 running iis and sqlserver 2005 sp2 we do not have the hotfix XP (KB956391)
installed. IE is configure to allow active x and to prompt for install.
Any help appreciated.
February 22nd, 2010 1:43am
Hi All
sorry,my English is not that good!!
i`m problem with Reporting service!!!(wonderfull!!)
i`m work with windows server2003 sp2,sql server2005 sp2,and work with reports with client and server.
but:
1.i can not print:unable to load client print control
i know this is ActiveX control,but not install in some clients(and sometimes in server,too!)
so,remove KB97...(that 2numbers)
security>custom level is medium
Rsclientprint (inf file vervion is 2007) is ok
but in c:/Window>downloaded program files ,version of clientprint is 2005 while i registered that file with SrvReg32.exe!!!
after the publishes report in server and test print some report is ok but i have dynamic report that with click in field go to another reports ,so that new report not print!!
2.i want deploy reports on servers but no in localhost
my question :only deploy on http://....? but or www....?
3.so for pass print , my report exported in pdf
now,i see pdf ,this is OK(font ,style,...) but when print from pdf ,config fonts!!!
i`m sad,and depress!!!
can i help me anyone?
no idea?
: (
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2010 2:47pm
Thanks Panod , ya it is really a bug with Reporting Service 2005 /2008 dlls , Yes but using 2008 Redistributable i
got the success to print smoothly .
I think it is also needed to restart the IIS also .
But one issue still left : "I am not able to see the print logo(option) in FF and Chrome browsers" .
July 2nd, 2010 12:41pm
Here is a solution that worked for me: just remove a registry entry (client side!)
http://vettekerry.wordpress.com/2009/05/04/unable-to-load-client-print-control-in-reporting-services-2005/
Hope it helps!
Free Windows Admin Tool Kit Click here and download it now
September 17th, 2010 3:02pm
Thanks Ruud007, I removed the registry entry, worked instantly.
[-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{FA91DF8D-53AB-455D-AB20-F2F023E498D3}]
October 7th, 2010 5:42pm
Our Server environment : SQL2008 x64 SP2 Reporting Services on Windows Server 2008 x64,
Client PC environment: Windows XP SP2 with IE6 or higher, all users are login to Active Directory, users are not members of local Administrator or power user group.
Error: When a user printing a report getting an error as "Unable to load client print control"
Solution that work for us: replace following files in sql 2008 with SQL 2008 R2
Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin
RSClientPrint-x86.cab
RSClientPrint-x64.cab
RSClientPrint-ia64.cab
Once you replace the files one server users wont get above error and they do not required local power user or admin right to download Active X. Recommending to add report server URL as a trusted site (add to Trusted sites) via Active Directory GP.
Hope this will help for somebody to sort out this "hectic" problem. We had very tough time to find out a proper solution for this "bug".
Nishan Perera
Free Windows Admin Tool Kit Click here and download it now
March 24th, 2011 12:03pm