Crystal Enterprise:Most Recent Data in the Report

[ssudha]

Hi All,

I am calling my reports from a JSP page (unmanaged) that uses stored procedures to display the records. However, the reports are not displaying the recent data upon subsequent calls to the reports.

If I use "init=actx:connect" then it is fine, but how to force the report to connect to database on every call, without using "init", because the application can be used in Netscape also. The application has 60 reports. Please help ! The sample report given by Crystal Decisions on how to force a refresh will not help since it requires changing all the 60 reports.

Thanks in advance.

 

[Naith]

It's not the 'init' which is incompatible with Netscape. It's the actx viewer. If you want to view in both Netscape and IE, use the java viewer or something.

As far as reporting cached data is concerned, there are many areas you might check for this. Firstly, you have ":connect" specified, so the passed data is doing all it can to refresh against the database.

You might also want to minimise the number of minutes between database refreshes in CE. In your page server, set the refresh button for "Minutes between database refreshes" on. Ensure that "Viewer refresh always hits the database" is also set on.

Also set your idle job closed period to one minute. This makes the web component server drop cached data after a minute.

Naith