Unable to load Print Control in Reporting Services

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:

Unable To Load Client Print Control

Unable To Load Client Print 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

Incomplete

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.

Incomplete

Try Deleting the ActiveX control from Addons in IE

Symptoms:

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

  1. Tools | Manage Add-ons | Enable of Disable Add-ons.
  2. 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
  3. Run the report
  4. Press the print button and re-install the report.

Incomplete

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!

Incomplete

Try manually installing the print client

To manually install the .CAB file:

  1. 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
  2. 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.)
  3. Right-click the RSClientPrint.inf file.
  4. 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

An Apparent Fix: http://www.microsoft.com/downloads/details.aspx?familyid=4603C722-2468-4ADB-B945-2ED0458B8F47&displaylang=en

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!

Incomplete

ReportViewer needs updating

The symptoms:

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)

Solution:

Install the latest version of the Report Viewer control on your server. This will currently mean that you need Report Viewer Control SP 1.

  1. Install SP1 from the link here.  You should have Report Viewer installed anyway otherwise you would probably not see this error ;o)
  2. 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

Other Resources:

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: