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
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.
We are facing the same problem. Advising the clients who use our web application to weaken the security of their Internet Explorer is not really an option. Can the ActiveX control be downloaded separately?
Kind regards,
Martijn Bakker
I'm having the same problem as described above. What is the solution?
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.
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 still require the permission to run Active X controls.
What is the process to install the ActiveX if we don't have SMS?
It is automatically installed when you click the print button when viewing a report.
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
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.
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.
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.
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?
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
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.
