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:00000400Step 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:00000400Step 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’
