Crystal Active X Viewer Refresh Problem

[ToneV]

I have been using the Active X Viewer for several months to view a crystal report via our intranet. This report is scheduled to run every 10 minutes in Crystal Enterprise 10. It is exported to a network folder and overwrites the old file. So, if a user has their browser open for a long period of time, they can press the browser refresh button and pull in the most current report. Occassionally, when the browser refresh button is pressed, I get a Crystal Report Viewer error and all it says is "An error has occurred". I click OK and hit refresh again and it works fine. This only happens about half the time. Any ideas?

 

[Turkbear]

Hi,
Not a way I would use to do that, but: If the Refresh command happens when the report is being changed, an error will be thrown, since a file cannot be opened when it is being written to ( or deleted).


Why not just put a shortcut on the user's desktop that calls the report and have the user run it when needed?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ToneV]

This error occurs even when the report is not changed. I have many people viewing this report at the same time and they do open it when needed. Actually, a .rpt file is the only format that will overwrite the old file while it is opened by a user through Crystal Active X Viewer. Every desktop does have a shortcut this Report.asp.

 

[Turkbear]

Hi,
What are you using to call the report ( what is in report.asp)
Leaving the ActiveX viewer ( and the browser) open for a long time could well cause the authentication or connection to the data to time-out ( also, Refresh does not 'always' refresh..It can depend on the browser's settings)..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ToneV]

I am using the code provided by Business Objects for Crystal Report Viewer.

<%@ LANGUAGE="VBSCRIPT" %>
<%reportname = "report.rpt"%>
<!-- #include file="AlwaysRequiredSteps.asp" -->
<!-- #include file="MoreRequiredSteps.asp" -->
<!-- #include file="SmartViewerActiveX.asp" -->

The shortcut on the desktops are pointed to report.asp in the virtual directory. Enterprise is doing the work and pulling in the data (report.rpt)...I am just directing the users to the report, not to the database. When it is working and I hit refresh on the browser, I do get the latest instance of the report after the 10 minute scheduling is up. So the refresh does seem to work....just get the annoying error ocassionally.

 

[Turkbear]

Hi,
as an alternative, you could avoid the asp altogether and use a URL-based call for your published report:

[COLOR=blue]
[URL unfurl="true"]http://yourceserver/viewrpt.cwr?id=yourreportID&apsname=Guest&apsauthtype=secEnterprise&init=actx&promptex-WORK_REQUEST_NO=12[/URL]
[/color]

Use whatever authentication is needed ( &apsname=Myuser&apspassword=letmein for instance) and pass the parameters, if needed, as shown in the example ..

Create a shortcut using this URL and let your users run as needed..It should avoid the open browser related problems..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ToneV]

I will give that a shot. Thanks for you help!