Troubleshooting
Problem
A stored procedure was developed and published in the Framework Manager package. The stored procedure executes for the report correctly the first time, but when parameters are changed and the report is rerun, then the stored procedure is not re-executed as it should be for the report.
Resolving The Problem
First when creating the prompt in Report Studio, make sure that the same Parameter name is used as defined in the Stored Procedure. Using prompt macros to provide the parameter values to the stored procedure resolves the problem. If the parameter values are in the format #prompt('Order Number','integer')# this works and the stored procedure will execute correctly for the report when it is rerun.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg22013904