CE10 URL to run report on Web Reports Server. How do I refresh ?

[amurgett]

This is soooo bugging me, I know it's possible as i've seen code to make this happen with earlier versions of Crystal but it just won't work for me .....

I have a url to a report on the CE10 server, 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.

The URL is as follows :

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

I have seen documents (maybe not for CE10) 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 URL exports to Excel (data only). Thus my 'ideal' url will be .......

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

<..... with the refresh code added to this.

Does anyone have any ideas. I am pulling out what little hair I have left !!

Thanks

Andrew