Refreshing Crystal Report 8.5 from browser (IIS 5)

[kinglywarrior]

I'm trying to get Crystal Reports to refresh while viewing them in a web browser (CR 8.5, IE6, IIS 5).

I got some code from CrystalDecisions website a while ago for viewing reports in a browser, but this code only works with scheduling the reports. This won't work because the report has to be run with a parameter coming from the current intranet .asp page. When I try and just call the reports with a href anchor (we have the viewer installed) the report comes up, but various errors occur when trying to refresh the report, depending on how the connection with the report was set up. I've tried ODBC, OLE DB, using SQL or Windows authentication, and can get the report to refresh in the Crystal Enterprise program, but not in the browser.

What is a way I can view and refresh a report from the web browser (code or other suggestions)?

Thanks much,
kw

 

[ignoreme]

Are you using the ActiveXviewer.asp, HTMLviewer.asp, etc.?

From my experience with using ActiveXviewer, we could not use the refresh button because it would require a refresh of the data id which it could not.

The report was static and had to be recreated again if the data changed.

Do you have stored procedures tied to the report? If so, when you refresh, those stored procedures need some parameter value to execute and refresh the data to the report.

My two cents.

 

[kinglywarrior]

Yes, I am using the ActiveX viewer. I'll look in to HTMLViewer, it's not something I'm familiar with.

And the reports are based off of stored procedures. So far, I've been using the Select Expert to handle parameters, like of a date needs to be in a certain range I've handled that in Crystal and not in the stored procedure code. Are you suggesting that when I call the report I pass parameters in some way that they can be passed to the stored proc?

Thanks so much 4 the input!!!

 

[ignoreme]

Well, no.

When you call the call the report, you should pass it some parameters that will be needed by the stored procedures.

The report takes those parameters and uses them to call the stored procedures.

However, the report does not retain the values from the parameters, thus you need to recreate the report (call it again from whatever process you use) to attain an update of data in the report. It will then execute the stored procedure again for the data.

Good luck!