Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing Database Name in 9.0 vs 8.5

Status
Not open for further replies.

skuhlman

Programmer
Jun 10, 2002
260
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top