ActiveX print control will not install from ReportViewer in web app

Question

ActiveX print control will not install from ReportViewer in web app

Carmen Lipscomb

SSC Veteran

Points: 260
More actions
April 3, 2006 at 9:56 am

#114051

We've created a web app that includes a ReportViewer control. The reports are generated fine, but when the print button is clicked, we get the following error: "Unable to load client print control". It works fine if I manually install the ActiveX control, but from what I've read, the first time you click on the print button the ActiveX control should be installed automatically. I've double-checked the browser settings so they're ok. Note: the ActiveX control does install from Report Manager on the same box.
Anybody have any idea of why it's not working from the ReportViewer in the web app?
April 6, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

srmc Right there with Babe Points: 781 More actions · Answer 1

We ran into this issue when the users trying to install the ActiveX control didn't have appropriate rights on their workstation. We ended up serving reports as pdf or Excel only because we couldn't get the print control to work in a managed workstation environment.

Carmen Lipscomb SSC Veteran Points: 260 More actions · Answer 2

Thanks for the feedback. I am working on this in a development environment where I have full admin rights on my box, so it's not a permission problem. But since I ultimately want external users to be able to use the print button from the web app, it may be a problem for them.

hamishahern SSC-Addicted Points: 498 More actions · Answer 3

We also ran into this problem in a managed environment, it works on the dev machines where the user has full rights, but not on the workstations in a managed environment. Internet Explorer security settings haven't seemed to have made any difference yet.

hamishahern SSC-Addicted Points: 498 More actions · Answer 4

Here is another person with the same problem...

http://www.eggheadcafe.com/forumarchives/sqlserverreportingsvcs/mar2006/post26063054.asp

3/7/2006 2:39:30 AM Unable to load client print control

Hello Help me please to print sample report from browser. I'd like to print test report for Microsoft Reporting Services 2005 based on table Vendors in the AdventureWorks database. So first of all I build report, publish it on the server, make preview in the IE 6.0.3790.1830 and click on "Print" image on the report preview page. Security dialog is displayed: "Do you want to install this software? Name: Microsoft SQL server Publisher: Microsoft Corporation" I select "Install" but got error Unable to load client print control Help me please - does this link work at all? How client print control could be installed separately? Thank you.

hamishahern SSC-Addicted Points: 498 More actions · Answer 5

we have just told our users to export as pdf, and print from that, in the meantime.

mpowney SSC Journeyman Points: 89 More actions · Answer 6

I've found so far that when printing from a ReportViewer control in an ASP.NET web app, clicking the Reporting Services print button displays the message "Unable to load client print control". My environment is as follows:

- Local machine is on a different domain to the Reporting Server

- Local machine is running IE7

- SSRS Server is also running IE7

- SSRS ReportServer site is in the Local Intranet zone of local machine

- ASP.NET web site is also in the Local Intranet zone of the local machine

- Ditto for the SSRS server

I have tried the following variations:

- ReportViewer control property "AsyncRendering" set to true or false (iframes may allow for more relaxed security restrictions in IE)

- ASP.NET web app hosting the ReportViewer control running on local machine, within the SSRS ReportServer virtual site on SSRS server, and on a separate virtual site on SSRS server.

The only time I've managed to get the RSClientPrint control to work is when using the SSRS ReportServer site to render the reports directly (i.e. not using a ReportViewer web control in an ASP.NET site).

Siva Gurusamy SSCrazy Points: 2711 More actions · Answer 7

I have faced this and this is how to overcome the Activex Issue.

Solution:

1. Grant Admin rights to the user on his own machine (Many companies do not grant this right to users of their own machines for obvious security reasons).

2. Let the user go to Report manager (http://myreportserver/reports/pages/folder.aspx), and try Print a report. Now the Activex will prompt and install.

3. Print sample report.

4. Revoke admin rights for the user.

5. Go to Report manager. Print a report. the user should be able to.

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation

Ashutosh Jha Old Hand Points: 374 More actions · Answer 8

Just uninstall KB956391 window xp sp2 security update, and then try, hope it will work for you guys.

Matt Lavery SSC Enthusiast Points: 159 More actions · Answer 9

I know this post is pretty old but it was most likely due to a security update for Kill Bits released by MS and then fixed with a subsequent security update released for SQL Server.

Need to make sure all of your environments are patched though to prevent accidental return to old versions and experiencing this issue further.

More info on this issue available in my blog http://matticus-au.blogspot.com/2009/04/report-viewer-returning-unable-to-load.html

david.key SSC Rookie Points: 33 More actions · Answer 10

Having same issue with workstation. KB956391 isn't available to uninstall. Does anyone have another solution? Also have tried adding reporting server to trusted site and verified all active x control enabled in security settings of browser.

Martin Stephenson SSCrazy Points: 2950 More actions · Answer 11

I have had many of the same problems with people pushing out hotfixes without letting me know what was about to happen and then wondering why printing failed.

I have installed KB954606 on production server and I can now print reports, However I have a development server which wont accept the hotfix as it is patched to 9.0.4035 and is at to high a patch level for me to do it. I cant print reports from this server, any ideas?