Refreshing a report based on a stored procedure - New parameter values

[Former Member]

I have a report based on a stored procedure. Everything is working ok, the SP takes the parameters and creates the output/report. My problem though is when I refresh the report, using new parameter values, nothing happens except the old report comes back. The SP takes about 1 minute to complete the first time, but when I refresh it comes back right away. The parameters are displayed on the report, and they show the new parameter values I entered, but the data does not reflect that. The only way to get it to use the new parameter values is to do a Verify. That always works.

Is there a way to get it to refresh? Our users use Infoview and Verify is not available on Infoview. The refresh on Infoview does nothing, just like in the Desktop client. Only Verify works to use the new parameter values in the SP to generate the report.

I set the parameter in Report Options and Options "Verify stored procedure on refresh" to ON but that isn't doing anything.

Any ideas?

[abhilash_kumar]

Hi,

What is the version of the CR designer and what database is it?

-Abhilash

[Former Member]

Database is Oracle 11

Crystal Reports 2008 Version 12.2.0.290

[abhilash_kumar]

Is it 11gR1 or 11gR2?

As 11gR2 is not supported with Crystal Reports 2008 SP2.

-Abhilash

[Former Member]

I figured this out. I initially didn't have any of the detail on the report. That may have had something to do with the refresh not rerunning the procedure.

The goal of the procedure is to output the data to a file instead of the report because the output is enormous. So, actually doing the FETCH inside the SP instead of allowing Crystal to do the FETCH may have also caused this issue.

I figured out that I could create a cursor (not the REF cursor) in the SP, open it, fetch loop, write to file, close. After that, open the REF cursor, a second cursor that does nothing but count the total number of records processed, put that number on the report, and everything works fine. Refreshes take the new parameters.