exporting to Excel using npviewer

[Former Member]

I am using CR version 8.5. I installed the npviewer manually on user machines without a full Crystal install.  The viewer displays the report, but we cannot export the report to any file type, especially Excel.

My question is how to export using the npviewer. We are distributing machines with Windows 7 and IE 8.0. However, the export button does not work. Whenever the export button is clicked on, the process starts. It asked where to save the file, what format, etc. Whenever the user selects Excel as the file type, the only option is Excel 5.0. The user then names the file and clicks save. CR acts like it is exporting, but whenever it asks the user if they want to open the file after exporting, nothing happens if they click open the file. Also if they go to the folder where the file was supposed to have been saved, there is no file there.

Does anyone know how to fix this? We really need to have this option.

Thanks for any help.  We are planning on upgrading in September as that will be our new fiscal year, but we need this option for the next couple of months until the upgrade has been done.

[Former Member · Accepted solution]

I have found the solution to this issue, so if anyone else has this problem below is the answer.

1)    Open Internet Explorer

2)    Go to Internet Options and click on Security Tab

3)    Click on Internet

4)    Slide Security Level Zone to Low

5)    Uncheck enabled protected mode

6)    Click on Local Intranet

7)    Slide Security Level Zone to Low

😎    Click on Trusted Sites

9)    Uncheck Require Server Verification (HTTPS:) for all sites in this zone

10)    Add url for report page

11)    Click Apply

12)    Click OK

Go to a report and run the report.  Export the report to Excel.  There will be several messages about Protected mode, but ignore those.  After saving the file in a folder, review to make sure the file is there and open it using Excel.

Close Internet Explorer

Open Internet Explorer and go to Internet Options.  Click on Reset all Zones to default level and save.

[Former Member · Accepted solution]

Wow. This is amazing and weird news in one

Noting that in one of the posts on this thread, Netscape was mentioned, I decided to do a bit more searching / asking around here. As it happens, right around the time of CR 8.5 I stepped out of the support role. Once I got back, I quickly caught up to CR 8.5 (or so I thought). Unfortunately I never heard of NPViewer. Anyhow. As I do more research on this, I run into an old hand who actually remembered supporting it. According to him, even then Netscape was a minor player and perhaps that is why I never got up to snuff on this.

The weird thing is that you actually got this working on Windows 7 and IE 8.0(?). I have never heard of anyone else ever getting the ActiveX viewer working on WIN 7 - unless they used CRXI R2 (11.5) and even then it's flaky).

But I do thank you for hanging in there and for posting the solution.

- Ludek