How to force a Refresh for CE10 Web Report Server URL report

[amurgett]

I have a url to a report on the CE10 server (the .rpt sits in a shared folder and is not managed by CE10), the user double clicks the url (iexplorer) icon on their machine and the report opens. The problem is that even if the underlying data changes, the caching performed by the page/cache servers just returns the old/now invalid output.

Crystal 10 is used for the report with CE10.

An example of the URL is as follows :

http://100.10.60.83/crystal/livelink.rpt?user0=LU_ReportFolderContent&password0=password

I have seen documents stating that refresh can be forced (just like clicking the lightning bolt in the viewer) by adding 'RF=1' to the URL. I have tried this with the Java and ActiveX smart viewers but no joy.

I have also seen that for the HTML viewers you need to add 'cmd=rfsh&vfmt=html_page&viewer=html_page&page=1' but still no joy here.

Another doc, regarding BOXI discussed using 'sRefresh=Y', this didn't work either !

Ultimately, once this is sorted there may be another problem in that the desired URL exports to Excel (data only). Thus my 'ideal' url will be .......

http://100.10.60.83/crystal/livelin...ord0=password&cmd=EXPORT&;EXPORT_FMT=U2FXLS:4

<..... with the refresh code (whatever that is) added to this.

Does anyone have any ideas how to force refresh. I am pulling out what little hair I have left !!

Thanks

Andrew