Skip to Content
author's profile photo Former Member
Former Member

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

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 12, 2011 at 11:03 PM

    Hi,

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

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.