Skip to Content
0
Former Member
Dec 12, 2011 at 10:32 PM

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

64 Views

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?