Note: Please note that this post will be updated as I get more information on the issues. The idea’s present in this post have not all been tried. I’m trying to gather a list of possibly solutions and will apply them and clean this post up as I go. This post if NOT complete… or not considered complete enough :o)
I’ve been dealing with the following issue when you press the print button on the web based ReportViewer control:
There are a variety of possibly causes and solutions and I’m going to try and detail all the possibly options below in easiest to hardest solution: (Please note that this is incomplete and probably a bit messy at the moment)
You don’t have Permissions on the computer to install the ActiveX control
IE is set to dissalow installation of ActiveX controls
Internet Explorer\Tools\Internet Options\Security\Custom Level. Find the options to allow downloading of ActiveX controls.
Try Deleting the ActiveX control from Addons in IE
Note that I’m not 100% sure whether these symptoms are correct at the moment! Check!
Browser seems to install the ActiveX control.
You get the “Unable to load client print control” error
Solution for IE 7
- Tools | Manage Add-ons | Enable of Disable Add-ons.
- Find RSClientPrint items. Select them and Click the “Delete” button the the “Delete ActiveX” group box down the bottom right of the dialog. Note: I’ve come across places where this doesn’t work in a company i have dealt with. The Delete button was grayed out. I suspect there is either a permissions or group policy issues that may beed addressing before the
- Run the report
- Press the print button and re-install the report.
Try Deleting the physical ActiveX control
Someone suggested deleting them at the following location: “C:\WINDOWS\Downloaded Program Files”. Not sure whether this will work? Apparently moving form 2000 to 2005 will required this it seems from the comment found here. Also the new RSClientPrint is supposed to remove issues between 2000 and 2005 (so latest versions should allow side by side use)… I’m only going from memory on this though!
Try manually installing the print client
To manually install the .CAB file:
- Get the .cab file from the server Download the .cab file and save it on your desktop. On a test computer it was in the following location. C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\RSClientPrint.cab
- Open the cab file or extract the contents (Vista seems to allow double clicking as if it is a zip file. Not sure about XP etc.)
- Right-click the RSClientPrint.inf file.
- Click Install
I tried this on Vista and it didn’t work, but this process may work for you?!?! Some people have found that it works
ActiveX Killbits (KB956391) causes issues
Some say to uninstall the patch. Some say it is a bad idea as it fixes a security issues and that you should just install the fix!
ReportViewer needs updating
On IE 7 (Not tested on IE6) you run a report and press the print button.
You get the “Unable to load client print control”.
You don’t have the RSClientPrint 2005 Class add on installed in IE (Note that this may be irrelevant. It was the case in my instance)
Install the latest version of the Report Viewer control on your server. This will currently mean that you need Report Viewer Control SP 1.
- Install SP1 from the link here. You should have Report Viewer installed anyway otherwise you would probably not see this error ;o)
- Restart the Reporting Services application pool in IIS. Please note: If this doesn’t work, try restarting the reporting service obviously restart your application app pool also
- Microsoft Report Viewer Redistributable 2005 SP1 (Full Installation)
- Microsoft Report Viewer Redistributable 2005 Service Pack 1
- Microsoft Report Viewer Redistributable 2005 SP1 (Upgrade)
- TODO: Big post 2nd from bottom has some interesting information – Read this carefully