SSRS ReportViewer : Unable to load client print control

找了幾天終於通過下面的文章解決了（下載sp）。。。沒空翻譯，大家將就將就

 

 

From time to time I post fixes that I have found that aren’t on the net.  It’s so others don’t have to go through the same aggravation as myself.  This one relates to SQL Server Reporting Services (SSRS).  More precisely we have an ASP.Net application written in C# that uses the report viewer control to show reports.  However, when you want to print the report you need to run an ActiveX print control.  If you remove this from Internet Explorer, IE can’t load it any more.

FIRST CHECK TO MAKE SURE THESE 2 UPDATES ARE INSTALLED

Microsoft Report Viewer Redistributable 2005 Service Pack 1
Microsoft Report Viewer Redistributable 2008 Service Pack 1

You must restart IIS after installing these.  There are older versions available so make certain you have Service Pack 1 editions.

If you are still having the issue, try the following fixes.

Fix #1 - Simplest

We are running the 3.5 Framework.  I’m not certain that was a prerequisite though.  We simply change the version of the component from 8 to version 9.  Open all your ASPX pages and replace

Register Assembly=”Microsoft.ReportViewer.WebForms, Version=8.0.0.0

  with

Register Assembly=”Microsoft.ReportViewer.WebForms, Version=9.0.0.0

Fix #2 - This fix simply got the 8.0 version of the control to re-download.

Part 1
Add you site to the trusted sites.

I ran the following parts as well.  Each consists of a few steps.  I’m not sure if Part 2 was needed.

Part 2
—————————————————————————————————–
Step 1:
Paste the following text in a text editor such as Notepad. Then, save the file by using the .reg file name extension. You can apply this .reg file to client system by double-clicking it.

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Internet Explorer/ActiveX Compatibility/{FA91DF8D-53AB-455D-AB20-F2F023E498D3}]
“Compatibility Flags”=dword:00000400

Step 2:
On the client systems which face the issue, this could be tested out -
1. Unregister RSClientPrint.dll
2. Open Internet Explorer
3. Got to Tool - > Internet Options.
4. Click on ‘Programs’ tab
5. Click on ‘Manage add-ons’.
6. Select and Delete the ‘RSClientPrint Class’ ActiveX Control if it exists
7. Select ‘Security’ tab.
8. Select ‘Intranet Zone’ and click on ‘Custom Level’
9. Enable ‘Automatic prompting for ActiveX controls’
10. Select ‘Prompt’ for ‘Download signed ActiveXcontrols’ and ‘Run ActiveX
controls and plug-ins’
11. Restart the Internet Explorer
12. Try to print the report, this time it should prompt you to run the ActiveX
controls and plug-ins.
13. Click ‘Yes’

Part 3
—————————————————————————————————–
Step 1:
Paste the following text in a text editor such as Notepad. Then, save the file by using the .reg file name extension. You can apply this .reg file to client system by double-clicking it.

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Internet Explorer/ActiveX Compatibility/{FA91DF8D-53AB-455D-AB20-F2F023E498D3}]
“Compatibility Flags”=dword:00000400
[HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/Microsoft/Internet Explorer/ActiveX Compatibility/{FA91DF8D-53AB-455D-AB20-F2F023E498D3}]
“Compatibility Flags”=dword:00000400

Step 2:
On the client systems which face the issue, this could be tested out -
1. Unregister RSClientPrint.dll
2. Open Internet Explorer
3. Got to Tool - > Internet Options.
4. Click on ‘Programs’ tab
5. Click on ‘Manage add-ons’.
6. Select and Delete the ‘RSClientPrint Class’ ActiveX Control if it exists
7. Select ‘Security’ tab.
8. Select ‘Intranet Zone’ and click on ‘Custom Level’
9. Enable ‘Automatic prompting for ActiveX controls’
10. Select ‘Prompt’ for ‘Download signed ActiveXcontrols’ and ‘Run ActiveX
controls and plug-ins’
11. Restart the Internet Explorer
12. Try to print the report, this time it should prompt you to run the ActiveX
controls and plug-ins.
13. Click ‘Yes’