WCS Caching results

[grantkj]

I'm using Crytals Enterprise 8 connected to Oracle and serving up reports via the web.

The intent is to run on demand reports, but I'm finding that Crystal is caching results for me, sometimes.

The JSP app I have is generating URLs of the form:

http://test/reports/Simple.rpt?user...port&export_fmt=U2FPDF:0&promptex-SomeParam=x

Any ideas? I have tried a few things and my guess is that Crystal sets a cookie to keep track of how currently you;ve requested that URL. That is just a wild guess...

Is there some server level caching that can be turned off?

 

[dwi]

You should look at the Crystal Enterprsie On line Documentation under Web Developers Guide and look at the CONNECT parameter: Re-establishes a connection to the Page Server. The CONNECT parameter must be appended to the INIT parameter

 

[grantkj]

This is from the ce8_urlcommands.pdf file right after the discussion about the CONNECT option:

Note: Re-establishing a connection to the Page Server is not the same as
refreshing a report against a database. While the connection to the Page Server
enables the user to reset parameter values and view a different set of
information, if the report contains saved data, it will not need to access the
database for this information. For more details on refreshing a report, see
Refreshing web report data.


I'm pretty confused: for a SQL based report with no saved data, how can it do anything except go to the database and "refresh" its data? Another point is that CONNECT has to be tagged onto to the viewer type parameter and in my case I'm exporting to a file type of PDF, RTF Excel or Word, not using a viewer.