Hello all,
I have a situation where I'd like the report to pass the parameter to a stored procedure rather than prompt the user for it.
For example, I have 5 reports which are the same in all cases. Each report is built on a stored procedure with no parameters so each report has a stored procedure of it's own. The only thing I'm changing in each stored procedure is one value for each report. What I'd like to do is have the report pass the value specific to that report to the stored procedure so the user won't get prompted for a value. Then I can have only one stored procedure rather than 5.
I'm using CR 8.5 with Sql Server 2000
Thanks in advance,
bill
I have a situation where I'd like the report to pass the parameter to a stored procedure rather than prompt the user for it.
For example, I have 5 reports which are the same in all cases. Each report is built on a stored procedure with no parameters so each report has a stored procedure of it's own. The only thing I'm changing in each stored procedure is one value for each report. What I'd like to do is have the report pass the value specific to that report to the stored procedure so the user won't get prompted for a value. Then I can have only one stored procedure rather than 5.
I'm using CR 8.5 with Sql Server 2000
Thanks in advance,
bill