In CR8.5, when you selected a SQL stored procedure as your datasource, it would return something that looked like this:
MyFirstDatabase.dbo.Proc(sp_MyStoredProcedure)
To get the report to run using a stored procedure with the same name in a different database you could strip off the first part leaving only:
PROC(sp_MyStoredProcedure)
Once you did that, the report would run in any database that contained a stored procedure of that name and having the correct privilegs.
In CR9.0, I'm having a hard time figuring out how to acomplish this same thing. How do I do it?
Thanks for your help.
MyFirstDatabase.dbo.Proc(sp_MyStoredProcedure)
To get the report to run using a stored procedure with the same name in a different database you could strip off the first part leaving only:
PROC(sp_MyStoredProcedure)
Once you did that, the report would run in any database that contained a stored procedure of that name and having the correct privilegs.
In CR9.0, I'm having a hard time figuring out how to acomplish this same thing. How do I do it?
Thanks for your help.