Friday, April 12, 2013

Fix the Crystal Report Viewer Issue



Problem

If this fails to load the Active X control into the clients browser (and this maybe because the customer has a security policy in place that means only admins can download the control) please see instructions for manually installing the crystal reports viewer

Resolution

Manually install the Crystal Reports Viewer in a client’s browser

Note: this process does not work if the server is x86 and the client machine is x64 - produces 
module not found and/or different CPU type errors.

Firstly you will need to find the following cab file on the Server on which crystal reports is installed: ActiveXViewer.cab

For Crystal 10 it is installed in C:\Program Files\Common Files\Crystal
Decisions\2.5\crystalreportviewers10\ActiveXControls\ActiveXViewer.cab

For Crystal 11 it is installed in C:\Program Files\Common Files\Business
Objects\3.0\crystalreportviewers11\ActiveXControls\ActiveXViewer.cab

Within the cab files are the following 3 dlls (you can right click on the cab file and explore to see the files within) – you need to copy the following 3 dlls onto the client machine in step 3 below:-

CRVIEWER.DLL
SWEBRS.DLL
SVIEWHLP.DLL

1) Check to see if the following three files exist on the Client Machine

CRVIEWER.DLL
SWEBRS.DLL
SVIEWHLP.DLL

2) If they exist, then un-register the files:

Run cmd.exe as an administrator and for each dll enter the command

Regsvr32 /u pathtofile\filename

3) Copy these three dll files to the client’s windows\system32 directory

CRVIEWER.DLL
SWEBRS.DLL
SVIEWHLP.DLL

4) Register each file.

Run cmd.exe as an administrator and for each dll enter the command
Regsvr32 pathtofile\filename


5) Add web sites to intranet zone and Check Active X settings:-

Note: These instructions are based on Internet Explorer 7 Browsers

Click on Tools >Internet Options
Click on the Security Tab
Select Local Intranet Zone
Click on the Sites Button
In the popup window click on the Advanced Button
In the Box “Add this website to the Zone” enter http://*.mysite.net
Click on the add button
Click on the close button
Click on the OK button
You should now be back at the Security tab

Click on the “custom level” button
Scroll down to the settings for the category “Active X controls”
Ensure that the following are set within this category
Allow previously unused ActiveX controls to run without prompt = Enable
Allow Scriptlets = Enable
Automatic prompting for ActiveX Controls = Enable
Binary and script behaviours = Enable
Display video and animation on a webpage that does not use external media player = Disable
Download signed Active X controls = Prompt
Download unsigned Active X controls = Disable
Initials and script Active X controls not marked as safe for scripting = Disable
Run ActiveX controls and plugins = Enable
Script Active X controls marked as safe for scripting = Enable
Click on OK
Click on OK

6) Try and obtain a report in your web site

In your IE browser login to the your website and try to generate a report
You may be prompted to install the active X control – allow the installation, allow the active X control to run.

That’s it. The report should be displayed.

No comments:

Post a Comment